How do I create KPI modern dashboard for VPN connected user total

We just upgraded to Orion 2020.2. I am looking at the "My Dashboards" feature and want to create the KPI box with all my VPN routers reporting their connected users. My failure I am having is creating the SWQL query to display the data. Would anyone have the layout in the graphical query builder? I am not well versed in SQL or SWQL queries. Any help is much appreciated 

Top Replies

  •  are you looking for something as simple as the widget below to display a count of users connected?

    Widget.JPG

    If the above is what you are looking to achieve then the below SWQL should give you the desired…