Multiple UDPs Table as Inner Join instead of Outer Join

jroberts110

Is there a way on the tabular display in NPM that when pulling multiple OIDs via Universal Device Pollers to have the table display as an inner join instead of an outer join?  Ie - only show rows that have results from both OIDs.  In my case I'm pulling on hook/off hook stats from a Cisco VG224 which returns an index between 5 and 29 and I need that to match up to the actual interface name.  I can poll the interface name OID but that returns all ports, not just FXS.  When I put the two into a table in NPM it shows all port names on the box with the on hook / off hook status next to the ones that are FXS.

What I get currently:

What I'd like to see:

Thanks in advance for any assistance.

jroberts110

I was actually able to do it using a Custom Query object with the following code:

SELECT port, alias, status FROM

(SELECT d.Status as status, d.RowID

  FROM Orion.NPM.CustomPollerStatus d

  WHERE d.CustomPollerAssignmentID=

                (SELECT a.CustomPollerAssignmentID

                FROM Orion.NPM.CustomPollerAssignment a

                WHERE a.NodeID=${NodeID} and a.AssignmentName LIKE 'cvaIfFXSHookStatus%')) x

JOIN

(SELECT c.Status as port, c.RowID

  FROM Orion.NPM.CustomPollerStatus c

  WHERE c.CustomPollerAssignmentID=

                (SELECT b.CustomPollerAssignmentID

                FROM Orion.NPM.CustomPollerAssignment b

                WHERE b.NodeID=${NodeID} and b.AssignmentName LIKE 'ifName%')) y

ON x.RowID=y.RowID

JOIN

(SELECT e.Status as alias, e.RowID

  FROM Orion.NPM.CustomPollerStatus e

  WHERE e.CustomPollerAssignmentID=

                (SELECT f.CustomPollerAssignmentID

                FROM Orion.NPM.CustomPollerAssignment f

                WHERE f.NodeID=${NodeID} and f.AssignmentName LIKE 'ifAlias%')) z

ON x.RowID=z.RowID

ORDER BY ABS(x.RowID);

Not exactly ideal, but it works.