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