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 |
Is there a way to do this in the poller or does that need to be done in a SWQL query?