network availability & vpn connected users KPI widget

Good Afternoon thwack community! I've been trying to mess with the SQL query or the graphical query builder but can't seem to get the network wide availability % (as a KPI widget) and same with vpn connected users. Anyone had any luck? Thanks!

Top Replies


    Guys, i set this up for my environment and works fine for me, we use Cisco Anyconnect as the VPN client.

    VPN Widget


    To achieve the above i used the SWQL below where the XXX is the Solarwinds…


    if you change the 'WHERE' statement to read as below instead, this should give you the stats for the current month only and reset on the start of each month.

    WHERE (MONTH(i.DateTime) <= Month…