cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 10

UnDP in columns instead of rows

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)InterfaceIDStatus (polled values)
locIfInputQueueDrops on router1 Te 1/3856970
locIfInOverrun  on router1 Te 1/3856970
locIfReliab  on router1 Te 1/385697255
locIfOutputQueueDrops  on router1 Te 1/385697186

 

I need something like this:

InterfaceIDlocIfInputQueueDropslocIfInOverrunlocIfReliablocIfOutputQueueDrops
8569700255186

 

Is there a way to do this in the poller or does that need to be done in a SWQL query?

Labels (3)
Tags (3)
0 Kudos
0 Replies