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
  • is this what you're trying to accomplish?

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

Children