1 Reply Latest reply on Feb 28, 2014 5:35 PM by zackm

    How can I display Up Time - Report Writer

    gl3nn13

      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?

       


        • Re: How can I display Up Time - Report Writer
          zackm

          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.CUSTOMPOLLERASSIGNMENTID
          JOIN CUSTOMPOLLERS CP ON CP.CUSTOMPOLLERID = CPA.CUSTOMPOLLERID
          WHERE 
            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