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
Store

Anyconnect sessions Widget- total # with multiple nodes

Does anyone have a SWQL query for a custom widget that allows you to pull in number of active anyconnect sessions for multiple firewalls? Do I just need to repeat the last 2 lines with the other node ID's or is there a way to to add multiple node id's in the same line?

I am not great at writing these and the one I have only queries one node.

SELECT
count ([data].[RemoteAccessSessions].[UserName]) AS [Number]
FROM orion.asa.node AS data
where [data].[RemoteAccessSessions].[EncryptionAlgorithm] = 1
and ([data].[RemoteAccessSessions].[NodeId] = XXXXor [data].[RemoteAccessSessions].[NodeId] = XXXX)
and [data].[RemoteAccessSessions].[DisconnectedTime] is null

Also if you have any other cool SWQL queries for anyconnect sessions feel free to share them to me

Thanks

Find more posts tagged with

Comments

mmayer5823

Using any connect as well and its a pretty simple query.

SELECT CurrentValue

FROM Orion.NPM.CustomPollerAssignmentOnNode

Where NodeID = 'XXXX' AND DisplayName LIKE 'VPNCurrentUsers' OR NodeID = 'XXXX' AND DisplayName LIKE 'VPNCurrentUsers'

acf6276

Right but I have multiple firewalls so how would I tie them all into the same widget query with multiple node id's.

Quick Links

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