How can I display Up Time - Report Writer

Question

Hey there I have a report.....

SELECT
N.NODEID,  
N.CAPTION AS 'DEVICE',
N.IP_ADDRESS AS 'IP ADDRESS',  
N.LOCATION AS 'LOCATION',  
CPS.STATUS AS 'CURRENT STATUS',  
CPS.DATETIME AS 'LAST POLLED',
N.CUSTOMERNAME AS 'CUSTOMER'

FROM NODES N

JOIN CUSTOMPOLLERASSIGNMENT CPA ON N.NODEID = CPA.NODEID

JOIN CUSTOMPOLLERSTATUS CPS ON CPA.CUSTOMPOLLERASSIGNMENTID = CPS.CUSTOMPOLLERASSIGNMENTID

WHERE N.DEVICE_TYPE = 'POWER'

ORDER BY CPS.STATUS, N.LOCATION, N.CAPTION

and I want it to show uptime of which the MIB is UPSBASICBATTERYTIMEONBATTERY.

Can Anyone help?

zackm · Accepted Answer

Are you looking for a report that shows the results of that specific UnDP?

Try this:

SELECT  N.NODEID,    N.CAPTION AS 'DEVICE',  N.IP_ADDRESS AS 'IP ADDRESS',    N.LOCATION AS 'LOCATION',    CPS.STATUS AS 'CURRENT STATUS',    CPS.DATETIME AS 'LAST POLLED'  N.CUSTOMERNAME AS 'CUSTOMER'FROM   NODES N JOIN CUSTOMPOLLERASSIGNMENT CPA ON N.NODEID = CPA.NODEID JOIN CUSTOMPOLLERSTATUS CPS ON CPA.CUSTOMPOLLERASSIGNMENTID = CPS.CUSTOMPOLLERASSIGNMENTIDJOIN CUSTOMPOLLERS CP ON CP.CUSTOMPOLLERID = CPA.CUSTOMPOLLERIDWHERE   CP.UNIQUENAME = 'UPSBASICBATTERYTIMEONBATTERY'AND   N.DEVICE_TYPE = 'POWER'ORDER BY   CPS.STATUS,   N.LOCATION,   N.CAPTION

If you are looking for something else, please elaborate.

- ZackM

http://www.loop1systems.com