Display multiple UnDP values in a table

The following SWQL was used to consolidate 48 individual UnDP values into a single table via a Custom Table widget.

UnDPs were named DCBouputNameA1-B6, DCBouputFuseStatusA1-B6, DCBouputEnableA1-B6, and DCBoutputCurrentA1-B6.

select a.CurrentValue as [Name], fuse.CurrentValue as [FuseStatus], enable.CurrentValue as [Enable], current.CurrentValue as [Current]

from orion.npm.CustomPollerAssignment a

join orion.npm.CustomPollers b on a.CustomPollerID=b.CustomPollerID

join orion.Nodes n on a.NodeID=n.NodeID

join (select a.CurrentValue, substring(b.UniqueName,17,2) as breaker

from orion.npm.CustomPollerAssignment a

join orion.npm.CustomPollers b on a.CustomPollerID=b.CustomPollerID

join orion.Nodes n on a.NodeID=n.NodeID

where n.DisplayName like '%DCB%'

and b.UniqueName like 'DCBoutputCurrent%') as current on substring(b.UniqueName,14,2)= current.breaker

join (select a.CurrentValue, substring(b.UniqueName,20,2) as breaker

from orion.npm.CustomPollerAssignment a

join orion.npm.CustomPollers b on a.CustomPollerID=b.CustomPollerID

join orion.Nodes n on a.NodeID=n.NodeID

where n.DisplayName like '%DCB%'

and b.UniqueName like 'DCBoutputFuseStatus%') as fuse on substring(b.UniqueName,14,2)= fuse.breaker

join (select a.CurrentValue, substring(b.UniqueName,16,2) as breaker

from orion.npm.CustomPollerAssignment a

join orion.npm.CustomPollers b on a.CustomPollerID=b.CustomPollerID

join orion.Nodes n on a.NodeID=n.NodeID

where n.DisplayName like '%DCB%'

and b.UniqueName like 'DCBoutputEnable%') as enable on substring(b.UniqueName,14,2)= enable.breaker

where n.DisplayName like '%DCB%'

and b.UniqueName like 'DCBoutputName%'

ORDER BY b.UniqueName

Find more posts tagged with

There are no comments yet

Cisco ASR Devices
Cisco ASR Devices.pollerCisco ASR Devices
Basic SWQL Syntax
SWQL is built on the framework of SQL and as such supports most of the standard clauses as part of a query. A very simple example query is: SELECT Caption, IPAddress, Vendor, ResponseTime FROM Orion.Nodes Dissecting this query is relatively straightforward: show some fields (Caption, IP address, Vendor, and Response Time)…
Cisco ASA SSL Tunnels
Active SSL Tunnels-ASA.UnDPThis poller *should* display the number of Active SSL VPN (Anyconnect) Tunnels currently connected to your box. However, I tried it with my 5520 running 8.0.4 and for some reason I get a OID Not Supported. Here's my post in the forum: *EDIT* This is confirmed working with at least Interm release…
HP ProCurve Switches Hardening check
HP ProCurve Switches Hardening check.xmlGeneral hardening for HP switches