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