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 1.3.6.1.4.1.9.2.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
FROM Orion.NPM.CustomPollerStatusOnInterface
Returns this:
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:
InterfaceID | locIfInputQueueDrops | locIfInOverrun | locIfReliab | locIfOutputQueueDrops |
85697 | 0 | 0 | 255 | 186 |
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 |
Te2/0/3 | 85697 | 85697 | 0 | 10Gbps | 1 | 1 |
Te2/0/3 | 85697 | 85697 | 186 | 10Gbps | 1 | 1 |
Te2/0/3 | 85697 | 85697 | 255 | 10Gbps | 1 | 1 |
How do I consolidate those rows into a single column and separate Status into separate columns?