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
  • , can you post the query that your screenshot is using? It has the framework for what you want, we just need to modify it to do counts and then some unions with the various conditions. Below is probably close to what you're looking for

    Select Count(AnyconnectUserName)as [Total Clients Using], '4.9.0.5042' as [Any Connect Version]
    FROM <INSERT NAME OF TABLE>
    WHERE AnyConnectClientVersion like '%4.9.0.5042%'
    UNION ALL 
    (Select Count(AnyconnectUserName)as [Total Clients Using], '4.8.01090' as [Any Connect Version]
    FROM <INSERT NAME OF TABLE>
    WHERE AnyConnectClientVersion like '%4.8.01090%'
    )

Children