I created a new Universal device poller to gather CISCO Serial number information using the OID 18.104.22.168.22.214.171.124.6.3. I am using the Raw Value SNMP Get Table options.
I see this table information appear on the Node Details page from the Website I would like to add this information to a Historical Custom Poller report. I created the custom report with the correct fields but how do I import the data from the universal device poller?
I grabbed them a little differently, but to the same result. I wrote a SQL query that copies from the Custom Poller Status table to my Nodes table in a customproperty field:
SET SerialNumber = s.Status
FROM CustomPollerAssignment a JOIN CustomPollerStatus s ON a.CustomPollerAssignmentID=s.CustomPollerAssignmentID
JOIN Nodes n ON a.NodeID=n.NodeID
WHERE a.AssignmentName like 'CiscoSerialNum%' AND s.Status !=''
This implies CiscoSerialNum is the assingment name (name of poller) and SerialNumber is the field name in Nodes table.
This will probably work in your environment, tweaking the two above field names, but as always, before doing any DB tweaking, DO A BACKUP of your DB!!!
Hope this helps.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process. Learn more today by joining now.