1 of 1 people found this helpful
Try this (hide the NodeID field from the results set to make the device names hyperlinks to the node details page for each one):
SELECT N.NODEID, N.CAPTION AS 'DEVICE', N.LOCATION AS 'LOCATION', CPS.STATUS AS 'CURRENT STATUS', CPS.DATETIME AS 'LAST POLLED' FROM NODES N JOIN CUSTOMPOLLERASSIGNMENT CPA ON N.NODEID = CPA.NODEID JOIN CUSTOMPOLLERSTATUS CPS ON CPA.CUSTOMPOLLERASSIGNMENTID = CPS.CUSTOMPOLLERASSIGNMENTID WHERE CPA.CUSTOMPOLLERID IN (SELECT CUSTOMPOLLERID FROM CUSTOMPOLLERS WHERE UNIQUENAME = 'UPSADVBATTERYREPLACEINDICATOR') ORDER BY CPS.STATUS, N.LOCATION, N.CAPTION
@Zack_Mutchler, I'd like to learn where your process is accomplished. What you've pasted in looks like something from Notepad++, and I'm not sure where in NPM this data is created. Can you help me out by going through the beginning steps? E.g.: 1) Login to NPM, or RDP to the Main Poller and start Report Writer, or Go into NPM and start up Alert Manager, then . . .
Hey There this is great!!!
Could I define the Status to just batteryNeedsReplacing and add a custom property called CustomerName defining just the Customer Name (neft)