Creating Self-Documenting Monitor Solution Reports
Been messing the last few days with a combination of t-sql and Word macros to create a way of documenting the policies and rules for Altiris Monitor 7.1 servers.
All pretty much done, so am writing up for CONNECT.
Here's a taster graphic though of the end-result which was created by,
- Running some SQL
- Pasting the results into Excel
- Copy/Pasting table from Excel into Word
- Clicking on a Macro button
- Selecting a table layout and adjusting columns
All in all a couple minutes work! The symbols you see are shorthands for severity, agentbased/agentless, repeats and alert reset method.