Availability dashboard for network devices for week, month and last 24 hrs.

Hi Ken, Could you please help in providing the SWQL query for nodes availability for last 7 days for 100% and 0%

Find more posts tagged with

Accepted answers

Take a look at [mention:b4896b5b7bf14a1ba6eb90371a8f13aa:6b577b8c04704e209d29b6772bf67243] in the [mention:611dcbeac4a744629d169bd937026c93:393e7426ce8b492199490c0b60cb1f1e] wiki. It should give you some information about doing date spans.

All comments

Seashore

Here is a Query that should give you what you want.

Adjust it so it fits your needs.

SELECT TOP 100
    N.Caption AS [NodeName]
    ,AVG(N.ResponseTimeHistory.Availability) AS [Availability]
FROM Orion.Nodes as N
WHERE
    N.ResponseTimeHistory.DateTime>ADDDAY(-7,GETUTCDATE())
GROUP BY N.Caption
ORDER BY AVG(N.ResponseTimeHistory.Availability)

VenkatesG

Could you please help with the query for monthly and last 24 hours

KMSigma.SWI

VenkatesG

Hi @KMSigma.SWI I would like to combined the output of all different % of availability in pie chart. instead creating different values separately.

Ex: > 90%, <90 into one Pie chart. But by using HAV clause we are unable to UNION the two different select statements.

your help would much appreciated. Our requirement is to present the different % of availability in pie chart for last 7 days, 30 days. so on. similar to NCM backup status Pie chart.