How do I create KPI modern dashboard for VPN connected user total

Question

We just upgraded to Orion 2020.2. I am looking at the "My Dashboards" feature and want to create the KPI box with all my VPN routers reporting their connected users. My failure I am having is creating the SWQL query to display the data. Would anyone have the layout in the graphical query builder? I am not well versed in SQL or SWQL queries. Any help is much appreciated

dunky2k · Accepted Answer

rshrewsbery are you looking for something as simple as the widget below to display a count of users connected? If the above is what you are looking to achieve then the below SWQL should give you the desired results. SELECT count ([data].[RemoteAccessSessions].[UserName]) AS [Number] FROM orion.asa.node AS data where [data].[RemoteAccessSessions].[EncryptionAlgorithm] = 1 and ([data].[RemoteAccessSessions].[NodeId] = XXX or [data].[RemoteAccessSessions].[NodeId] = XXX ) and [data].[RemoteAccessSessions].[DisconnectedTime] is null Where the XXX is the Solarwinds NodeID of your ASA Devices, in our situation we only have 2 of then, but if you have 5 then you will have to expand this line to cover all 5 devices.

sunvad · Answer

Slightly modified and the count is exactly what you see in the 'Remote Access VPN' tab 
 
 SELECT count ([data].[RemoteAccessSessions].[UserName]) AS [Number] FROM orion.asa.node AS data where [data].[RemoteAccessSessions].[SessionStatus] = 1 and ([data].[RemoteAccessSessions].[NodeId] = XXX or [data].[RemoteAccessSessions].[NodeId] = XXX ) and [data].[RemoteAccessSessions].[DisconnectedTime] is null

How do I create KPI modern dashboard for VPN connected user total

Top Replies