Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.
Endpoint Management Community Blog

Creating Self-Documenting Monitor Solution Reports

Created: 06 Sep 2013 • 6 comments
ianatkin's picture
0 0 Votes
Login to vote

 

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

Comments 6 CommentsJump to latest comment

Ludovic Ferre's picture

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

I am currently off-net, on a retreat of some kind. I'll be back real soon, and you sure will hear from me then ;-).

Ludovic FERRÉ
Principal Remote Product Specialist
Symantec

0
Login to vote
ianatkin's picture

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?

Ian Atkin, IT Services, Oxford University, UK

Connect Etiquette: "Mark as Solution" those posts which resolve your problem, and give a thumbs up to useful comments, articles and downloads

0
Login to vote
Ludovic Ferre's picture

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 ;).

I am currently off-net, on a retreat of some kind. I'll be back real soon, and you sure will hear from me then ;-).

Ludovic FERRÉ
Principal Remote Product Specialist
Symantec

0
Login to vote
ianatkin's picture

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.

Ian Atkin, IT Services, Oxford University, UK

Connect Etiquette: "Mark as Solution" those posts which resolve your problem, and give a thumbs up to useful comments, articles and downloads

0
Login to vote
Ludovic Ferre's picture

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.

I am currently off-net, on a retreat of some kind. I'll be back real soon, and you sure will hear from me then ;-).

Ludovic FERRÉ
Principal Remote Product Specialist
Symantec

0
Login to vote
ianatkin's picture

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.....

Ian Atkin, IT Services, Oxford University, UK

Connect Etiquette: "Mark as Solution" those posts which resolve your problem, and give a thumbs up to useful comments, articles and downloads

0
Login to vote