Need swql query for the below system kpi metrics for modern dashboard 1. System uptime 2. Availablity

Bamee89

Need swql query for the below system kpi metrics for modern dashboard 

1. System uptime

2. Availablity

bourlis

Bamee89,

There are several options in the Content Exchange | Modern Dashboards.  I posted on several months back most likely covers what your looking for.

 Node based YTD Availability Dashboard 

My KPI metrics are based on availability and not necessarily system uptime.  In most cases what your looking at the same thing.... <and outage>.  You can have uptime and no availability, which in the end is the same things as no uptime and no availability.

But here's a SWQL query that will give you a KPI YTD availability for all nodes in your instance.

 

SELECT
    round (AVG(n.ResponseTimeHistory.Availability),3) AS [Availability]
    FROM Orion.Nodes AS n
    WHERE (1=1 
    and (n.status <> '9')) 
    and (n.ResponseTimeHistory.DateTime >= TOLOCAL(CONCAT(YEAR(GETDATE()), '-01-01'))))
with nolock