topic Re: Custom reports in Server Management (Insight Manager 7)

Custom reports

Ayman Altounji — Wed, 22 May 2002 23:00:00 GMT

I was wondering if anybody has some custom reports for graphing historical data. I know that the data is there but I don't have the time to teach myself SQL queries. What I am hoping for is to graph and trend analisys of disk, processor and memory utilization.

Re: Custom reports

Ayman Altounji — Wed, 12 Jun 2002 23:00:00 GMT

I am looking for the same type of thing, trying to select the event based query but insight only let youchoose device query.

Re: Custom reports

Ayman Altounji — Wed, 21 Aug 2002 23:00:00 GMT

Any one figure this out?

Re: Custom reports

Sylvain Amyot — Tue, 04 Nov 2003 13:59:41 GMT

I am looking for the same thing. Tried to graph in Excel and Crystal Report but could not get the graph to come out right. Anybody using the historical data for disk space and find a way to graph?

Re: Custom reports

Rob Buxton — Tue, 04 Nov 2003 14:11:59 GMT

Yep,
I use a perl script to create a CSV File and then import that into Excel.

I format a SQL Query based on the Server name passed and extract all Historical Disk Data and then sort it.

I'm not a SQL Expert, but to get the most out of this you'll need to know the basics.
Using the supplied report generator and MS Query you can view the SQL generated and use that.
I don't know of any off the shelf packages that easily do what you want.

Re: Custom reports

Sylvain Amyot — Tue, 04 Nov 2003 14:42:20 GMT

Thanks for the reply.

I am able to create sql queries to extract what I need from the historical tables but because I cannot figure out how to display the indexinstance across the top instead of the column, I cannot get a graph for each indexinstances. For the case of used disk space, each numbers in indexinstances is a reference to a logical drive. I think this is how I can graph it but I am not sure.

If anybody has done this in either Excel or Crystal Report, I would appreciate know how.

Thanks