Server Management Suite

 View Only

Creating Self-Documenting Monitor Solution Reports 

Sep 06, 2013 01:58 PM

 

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,

  1. Running some SQL
  2. Pasting the results into Excel
  3. Copy/Pasting table from Excel into Word
  4. Clicking on a Macro button
  5. 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.

Mon_RuleReportTbl.PNG

Statistics
0 Favorited
0 Views
0 Files
0 Shares
0 Downloads

Tags and Keywords

Comments

Sep 09, 2013 06:19 AM

I've got you now... yes HTML output would work well... scheduled task to generate it... maybe highlight changes somehow... only create a new Monitor Export if there has been changes...  will mull.....

Sep 09, 2013 06:09 AM

Yup, hence it would be easier to generate the data in html :D.

Note that I'm not talking about generating the report inside the console. I don't know what happened to me but lately I'm very happy to pull data outisde and put it on html off side.

May be it's just because the loading is much faster in those cases, specially as I'm doing this on the patch trend reporting etc.

Sep 09, 2013 05:48 AM

Ahh... It can be done a raw data, but the reason why I went to Word/Excel/Macro with this is that there are too many fields which are important. The result is a sea of text which is just not pleasant for dyslexics.

Also, this approach was created to help automate the creation of server documentation, where Microsoft Word is generally the file format of choice.

I know, it's a crazy world....

So.. I reasoned that I could replace these fields with specific single character graphics to create a report which contained all the information but in a nicer way.

I've got to put in place some more icons before I consider it a job well done though. For example, the Server Task and Client Task columns could be replaced with a single column of 'Tasks' with an icon prefix to designate the task type.

Sep 09, 2013 05:16 AM

I have nothing.

I was just wondering if we could find a way to generate the same type of reports without going thru the word and excel phases ;).

Sep 06, 2013 05:47 PM

Hi Ludovic.. Didn't see anything like this on my console which details monitor ploicy/rule/metric  configuration as succinctly as this.

Scared to ask... but what reports do you have?

Sep 06, 2013 04:14 PM

Out of curiosity, are you missing nice reports from the console, or you just wanted to play around?

Related Entries and Links

No Related Resource entered.