separate a table with different values

Hello Everyone,

I'm making a dashboard about a value that I'm capturing via UnDP, when pulling data from the Orion.NPM.CustomPollerStatus table it returns the status values and name of the VPN in the same table.

With SWQL I can take these values and separate them to be able to create a status dashboard for my VPN

Example

VPN Name | status
x.x.x.x | UP

I'm using this query with SWQL:

SELECT  RowID, Status FROM Orion.NPM.CustomPollerStatus

Find more posts tagged with

vpn

SWQL

Modern Dashboards

orionsdk

npm

sdk

Accepted answers

All comments

adam.beedell

Do you mean like;

SELECT RowID FROM Orion.NPM.CustomPollerStatus

SELECT Status FROM Orion.NPM.CustomPollerStatus

?

Or text like x.x.x.x appears in Status (not sure how that'd happen) you could separate using the verbs CharIndex, SubString and Replace to select status twice, and on one drop at the pipe, and on the other chop after the pipe.

LeBeauUK

Rather than using Orion.NPM.CustomPollerStatus, look at using Orion.NPM.CustomPollerStatusOnNode. I have a query that looks at disk status in a dis array:

SELECT Nodes.NodeID, Nodes.ObjectSubType, Nodes.IPAddress, Nodes.Caption, Nodes.Status, NPMCPSPD.Status as [Disk Status], NPMCPSPD.DisplayName as [Disk Controller]

FROM Orion.Nodes as Nodes

INNER JOIN Orion.NPM.CustomPollerStatusOnNode as NPMCPSPD on (Nodes.NodeID = NPMCPSPD.NodeID) and (NPMCPSPD.CustomPollerID = '2a3e03ed-ecd3-4a3f-80b2-52de2c1f1ef0') and (NPMCPSPD.status <> 'online')

Lucas023

Hello guys, thanks for the help, but I solve this using the following query:

SELECT  RowID, I.Status as IPadress, S.Status as Status 
FROM Orion.NPM.CustomPollerStatus as I
INNER JOIN Orion.NPM.CustomPollerStatus as S ON I.RowID = S.RowID
where I.Status like 'INET-%'
and 
S.Status not like 'INET%'