Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

network availability & vpn connected users KPI widget

Good Afternoon thwack community! I've been trying to mess with the SQL query or the graphical query builder but can't seem to get the network wide availability % (as a KPI widget) and same with vpn connected users. Anyone had any luck? Thanks!

Find more posts tagged with

Accepted answers

dunky2k

@famore @nz1jvb

Guys, i set this up for my environment and works fine for me, we use Cisco Anyconnect as the VPN client.

VPN Widget

To achieve the above i used the SWQL below where the XXX is the Solarwinds NodeID of your ASA devices, we only have 2, but if you have more then that line will need expanded to include all of your ASA Devices

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

Network Availability Widget

To achieve the above widget i run the following SWQL query - bearing in mind that in my instance i'm looking at the last 30 rolling days and we have less that 2000 Nodes, these values below (in bold) would require adjusting for your environment.

select avg(orion_responseTime_availability_avg) as Net_Avail
from (
SELECT TOP 2000 aggSub._avg AS Orion_ResponseTime_Availability_avg
FROM Orion.Nodes n
LEFT JOIN ( select i.nodeid, avg(i.availability) as _Avg from orion.ResponseTime i
WHERE (i.DateTime > ADDDATE('day', -30, GETUTCDATE()))
group by i.NodeID ) aggsub ON aggsub.nodeid=n.NodeID )

All comments

nz1jvb

Trying to find the same thing, would love to see some examples

dunky2k

@famore @nz1jvb

Guys, i set this up for my environment and works fine for me, we use Cisco Anyconnect as the VPN client.

VPN Widget

Network Availability Widget

famore

thank you!!! that worked!

I compared it to my ASA also and connected users is accurate.

famore

@dunky2k

really appricate that reply!

Quick question, for the network availability, i was playing with the SWQL commands but is there a way to change it to "current month average"? So it updates on a daily basis's for the month and resets the average every month.

Thank you!!!!!!!

nz1jvb

Thanks a ton, that worked perfectly

dunky2k

@famore

if you change the 'WHERE' statement to read as below instead, this should give you the stats for the current month only and reset on the start of each month.

WHERE (MONTH(i.DateTime) <= Month((getdate())) and MONTH(i.DateTime) >= Month((getdate())))

dclick

sorry - you used an ASA query on your Palo and you got back connected vpn users? The only thing you modified was the node ID?