0 Replies Latest reply on Feb 28, 2017 10:00 AM by kt617

    Universal Device Poller Query Serial Number

    kt617

      Hello, I set up a new Universal Device Poller to collect Cisco Serial Numbers. This is working and I can see the data being returned in the NPM web panel.

       

      I need to query this data via the API.

       

      Here is the query I am using. This returns several results. HOWEVER the "Current Value" field has the error message: 'CurrentValue': u'Not available for tabular pollers'.

       

      What table do I need to query to return the value of the pollers?

       

      QUERY

       

      mssql_query = '''
          SELECT
              n.NodeID,
              n.CustomPollerAssignmentID,
              n.Description,
              n.CustomPollerID,
              n.DisplayName,
              n.CurrentValue
          FROM
              Orion.NPM.CustomPollerAssignment n
          WHERE
              n.DisplayName like '%SERIALNUMCISCO'
          '''
      

       

      RESULT

       

      {u'CurrentValue': u'Not available for tabular pollers', u'DisplayName': u'entPhysicalSerialNumCISCO', u'Description': None, u'CustomPollerID': u'138e121e-38ac-449f-9ea1-5ffb18226adf', u'u_node_id': 123, u'CustomPollerAssignmentID': u'60fa92fe-c308-4d76-96db-a9b2d9aebf69'}