Modern Dashboard AnyConnect VPN Client Version Proportional Widget Help

I am having difficulties trying to get a pie or donut chart created with data that shows the total number of AnyConnect VPN clients on specific AnyConnect Client versions. If anyone has a good SWQL query that can pull this type of data I would appreciate it. I tried using the graphical query builder and could not figure out a way to get a value for VPN RA Session ClientInfo, Thanks!

Top Replies

Parents Reply
  • modifying it to below should work

    SELECT Count(n.UserName) as [Total Clients Using], n.ClientInfo as [Version]
    FROM Orion.ASA.RemoteAccessSessions n
    WHERE (ClientInfo LIKE '%AnyConnect%') and (ClientInfo LIKE '%4.8.01090%')
    group by n.clientinfo
    UNION ALL
    (SELECT Count(n.UserName) as [Total Clients Using], n.ClientInfo as [Version]
    FROM Orion.ASA.RemoteAccessSessions n
    WHERE (ClientInfo LIKE '%AnyConnect%') and (ClientInfo LIKE '%4.9.05042%')
    group by n.clientinfo)

    we can simplify it even more like this, just know that if you want to start adding filters for certain types then you'll probably have to use a quey like above

    SELECT count(n.UserName) as [Total Clients Using], n.ClientInfo as [Version]
    FROM Orion.ASA.RemoteAccessSessions n
    group by n.clientinfo

Children