Setting up several UnDP's to gather interface data. The poller config does not allow me to get all of the data from the top OID 184.108.40.206.220.127.116.11.2.1.1, so I have to create multiple pollers. The result is that all the data goes in a table that puts each poller output in a separate row, but all the data is under just one column. I need each poller's output to have a separate column so that I can join the data with the interfaces table.
SELECT AssignmentName, InterfaceID, Status
|AssignmentName (poller)||InterfaceID||Status (polled values)|
|locIfInputQueueDrops on router1 Te 1/3||85697||0|
|locIfInOverrun on router1 Te 1/3||85697||0|
|locIfReliab on router1 Te 1/3||85697||255|
|locIfOutputQueueDrops on router1 Te 1/3||85697||186|
I need something like this:
I can join it to the Orion.NPM.Interfaces table easily enough, but then I have extra rows of duplicated data:
|Interface||InterfaceID||InterfaceID1||Status1||Speed||%in Util||%Out Util|
How do I consolidate those rows into a single column and separate Status into separate columns?
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.