Report Query

marksmink

I'm looking to produce a report that shows the availability of nodes for yesterday, this month and this year all on the same chart for each node. It would be ideal to have this available from the Solarwinds website or be able to publish this elsewhere. Does anyone have any ideas on how this can be done?

Thanks in advance.

Cheers,

Mark

JohnM

With some of the reports I've been making (namely searching for devices that are "dead") I've had to do some customization.

What I do is make a Custome SQL report. I know a fair amount of SQL, and that's about all you need for what I've been doing.

I make a report of what I want, and go to options, and choose the "Show SQL" option. It'll bring up another tab in your report maker showing the SQL. You can browse through that and add in fields and various criteria to bring up.

So, here's what I'd do in your situation:

1) Create your report for your week report, then show the SQL.

2) Create your report for the month report, then show the SQL.

3) Create your report for the year report, then show the SQL.

4) Compare these 3 reports' SQL statements that correspond to what they'd be doing had you hit "Execute SQL" for any of them.

5) You should be able to see where the SQL statements for search are, what fields they bring up, and things like this. It's not too difficult to add in various fields or criteria here to include all 3 reports (at least I hope so, as I haven't seen any of your reports).

6) Looking at the SQL database will give you a nice view of the fields available, and kinda how to access them.

So, if you have a Table named Nodes and there's a field called Caption, you can add in your SQL query "Nodes.Caption" to retrieve that info for you.


I know this isn't that specific, but if there's anything you want me to expand upon, or anything, let me know. I've been working with customizing reports with SQL for a while now.


JohnM

Bandag - World Leader in Retread