cancel
Showing results for 
Search instead for 
Did you mean: 
wiljam
Level 7

Need help with a Report.

Jump to solution

Can some one help me write a SQL scipt. I am trying to get a report together to show the last time our Batteries were tested on our UPS's. I would like to get a list of all UPS that are over 3 years since last replacement. I have located the MIB and have it loaded in the Custom Pollers and can see the information fromthe web page. I dont know anything about SQL scipts and dont see another way in any of the other reports that would get the information. any help would be appreciated.

This is the OID that I am trying to get into a report.

1.3.6.1.4.1.534.1.2.6

xupsBatteryLastReplacedDate

Tags (2)
0 Kudos
4 Replies
Highlighted
cdoyle
Level 11

Re: Need help with a Report.

Jump to solution

Hi Wiljam,

This should be posible using the standard Report Writer reports (checked this in v9.1).

Create a New "Current status of Nodes, Interfaces.." report.

On the Select Fields tab, you will need to add the Network Nodes->Node Details -> Node Name and Custom Pollers (current status)->Custom Node Pollers->Status fields, others as required. 

On the Filter Results tab, add the  Custom Pollers (current status)->Custom Node Pollers->Poller Name field, and change * to the name of your Universal Device Poller. 

For example, the filter might look like: Poller Name is equal to xupsBatteryLastReplacedDate

Cheers,

0 Kudos
wiljam
Level 7

Re: Need help with a Report.

Jump to solution

Works in 9.0 too. Thanks a lot. Time to go make upper management happy.

0 Kudos
wiljam
Level 7

Re: Need help with a Report.

Jump to solution

I have one more problem. When I sort on the date it always want to sort on the moment and not the year. Have any way around that?

0 Kudos
tosc00ter
Level 8

Re: Need help with a Report.

Jump to solution

Caroline,

Excellent post!  It worked like a champ.  However, when I try to sort by Ascending my report goes blank.

We've created two custom reports "Top 20 Warmest IDFs" and "Top 20 UPS Highest Output".

 

Node          Temp in Fahrenheit

IDF 5           79

IDF 3           75

IDF1            75

IDF2             73

IDF6            101

IDF18           105

0 Kudos