I able to use the following SWQL Query to get a total session count for all my VPN appliances.
SELECT DISTINCT
count ([data].[RemoteAccessSessions].[UserName]) AS [Total Sessions]
FROM orion.asa.node AS data
where [data].[RemoteAccessSessions].[EncryptionAlgorithm] = 1
and ([data].[RemoteAccessSessions].[NodeId] = XXX or [data].[RemoteAccessSessions].[NodeId] = XXX or [data].[RemoteAccessSessions].[NodeId] = XXX or [data].[RemoteAccessSessions].[NodeId] = XXX) and [data].[RemoteAccessSessions].[DisconnectedTime] is null
However, I would like to also display the individual count for each node in the same SWQL Query as well.
Total Session = ### , Node 1 Sessions = ###, Node 2 Sessions = ###
