Custom reports

[Ayman Altounji]

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.

[Ayman Altounji]

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

[Ayman Altounji]

Any one figure this out?

[Sylvain Amyot]

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?

[Rob Buxton]

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.

[Sylvain Amyot]

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