Creating a report for CiscoEnvMonTempStatusValueF... Univ. Device Poller

charpham

I wold like to create a report that displays the top temperature cisco devices.  I am wondering if someone who is knowledgable in SQL could create a basic sql script for me with these parameters.

I am also wondering if this is a service that Solarwinds can provide?

kweise

Charpham,

You should be able to create that report just using report writer.  I don't think you'll need a custom SQL report. Create a new "Current Status of Nodes, Interfaces, etc." report.  On the Select Fields tab, add the Node Name field from the Node Details menu under Network Nodes.  Add another Field for Status from the Custom Node Pollers menu under Custom Pollers (Current Status.)  Set the sort on this field to descending.

On the Filter Results tab, add a new elementary condition.  Click on the first * after Records where and change it to Poller Name from the Custom Node Pollers meun under Custom Pollers (Current State.)  Click the * after the "is equal to" clause.  This should open a drop down list of your pollers.  Find the ciscoEnvMonTemperatureStatusValueFarrenheit poller from the drop down list.  If you just want the Top X temperatures, click on the Top XX tab and change it to "Show only the Top ____ Records and type in the number of records you want on the report.  Finally, go the Field Formatting tab, click on the Status field and change the column header to say "Temperature."

Hopefully this is what you're looking for.  If you have any questions, just let me know.

Kevin