This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Universal Device Poller Query Serial Number

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'}