Mutiple UnDP values on table

Version 1

    The Node Tabular Universal Device Poller as limitations such as unable to remove first column and unable to arrange columns.

     

    A better way would be to SWQL it.

    SELECT tmp1.VolName as [Volume], tmp3.VolSize as [Size(TB)], tmp2.VolUsage as [Usage(TB)], tmp4.VolUsagePct as [Usage(%)]

    FROM Orion.NPM.CustomPollerAssignment cpa

    INNER JOIN Orion.NPM.CustomPollers cp ON cp.CustomPollerID=cpa.CustomPollerID

    INNER JOIN Orion.NPM.CustomPollerStatus cps on cps.CustomPollerAssignmentID=cpa.CustomPollerAssignmentID

     

    left join (SELECT cps.status as [VolName], cps.RowID FROM Orion.NPM.CustomPollerAssignment cpa

               INNER JOIN Orion.NPM.CustomPollers cp ON cp.CustomPollerID=cpa.CustomPollerID

               INNER JOIN Orion.NPM.CustomPollerStatus cps on cps.CustomPollerAssignmentID=cpa.CustomPollerAssignmentID

               WHERE cp.UniqueName='VolName') tmp1 on tmp1.RowId = cps.RowID

     

    left join (SELECT cps.status as [VolUsage], cps.RowID FROM Orion.NPM.CustomPollerAssignment cpa

               INNER JOIN Orion.NPM.CustomPollers cp ON cp.CustomPollerID=cpa.CustomPollerID

               INNER JOIN Orion.NPM.CustomPollerStatus cps on cps.CustomPollerAssignmentID=cpa.CustomPollerAssignmentID

               WHERE cp.UniqueName='VolUsage') tmp2 on tmp2.RowId = cps.RowID

     

    left join (SELECT cps.status as [VolSize], cps.RowID FROM Orion.NPM.CustomPollerAssignment cpa

               INNER JOIN Orion.NPM.CustomPollers cp ON cp.CustomPollerID=cpa.CustomPollerID

               INNER JOIN Orion.NPM.CustomPollerStatus cps on cps.CustomPollerAssignmentID=cpa.CustomPollerAssignmentID

               WHERE cp.UniqueName='VolSize') tmp3 on tmp3.RowId = cps.RowID

     

    left join (SELECT cps.status as [VolUsagePct], cps.RowID FROM Orion.NPM.CustomPollerAssignment cpa

               INNER JOIN Orion.NPM.CustomPollers cp ON cp.CustomPollerID=cpa.CustomPollerID

               INNER JOIN Orion.NPM.CustomPollerStatus cps on cps.CustomPollerAssignmentID=cpa.CustomPollerAssignmentID

               WHERE cp.UniqueName='VolUsagePct') tmp4 on tmp4.RowId = cps.RowID

     

    WHERE cp.UniqueName = 'VolName'

    ORDER by [Volume] asc

     

    If you prefer SQL:

    SELECT tmp1.VolName as [Volume], tmp3.VolSize as [Size(TB)], tmp2.VolUsage as [Usage(TB)], tmp4.VolUsagePct as [Usage(%)]

    FROM CustomPollerAssignment cpa

    INNER JOIN CustomPollers cp ON cp.CustomPollerID=cpa.CustomPollerID

    INNER JOIN CustomPollerStatus cps ON cps.CustomPollerAssignmentID=cpa.CustomPollerAssignmentID

     

    left join (SELECT cps.Status as [VolName], cps.RowID

    FROM CustomPollerAssignment cpa

    INNER JOIN CustomPollers cp ON cp.CustomPollerID=cpa.CustomPollerID

    INNER JOIN CustomPollerStatus cps ON cps.CustomPollerAssignmentID=cpa.CustomPollerAssignmentID

    where cp.UniqueName = 'VolName'

    ) tmp1 on tmp1.RowId = cps.rowid

     

    left join (SELECT cps.Status as [VolUsage], cps.RowID

    FROM CustomPollerAssignment cpa

    INNER JOIN CustomPollers cp ON cp.CustomPollerID=cpa.CustomPollerID

    INNER JOIN CustomPollerStatus cps ON cps.CustomPollerAssignmentID=cpa.CustomPollerAssignmentID

    where cp.UniqueName = 'VolUsage'

    ) tmp2 on tmp2.RowID = cps.rowid

     

    left join (SELECT cps.Status as [VolSize], cps.RowID

    FROM CustomPollerAssignment cpa

    INNER JOIN CustomPollers cp ON cp.CustomPollerID=cpa.CustomPollerID

    INNER JOIN CustomPollerStatus cps ON cps.CustomPollerAssignmentID=cpa.CustomPollerAssignmentID

    where cp.UniqueName = 'VolSize'

    ) tmp3 on tmp3.rowid = cps.rowid

     

    left join (SELECT cps.Status as 'VolUsagePct', cps.RowID

    FROM CustomPollerAssignment cpa

    INNER JOIN CustomPollers cp ON cp.CustomPollerID=cpa.CustomPollerID

    INNER JOIN CustomPollerStatus cps ON cps.CustomPollerAssignmentID=cpa.CustomPollerAssignmentID

    where cp.UniqueName = 'VolUsagePct'

    ) tmp4 on tmp4.rowid = cps.rowid

     

    where cp.UniqueName = 'VolName'

    Order by [Volume] asc

     

    Thanks

    Amit