Uptime Report SQL query

Are you specifically looking for a report?  Because this isn't hard to mock up in a Modern Dashboard.

If it is a report, what fields do you want and over what timeframe?

Are you specifically looking for a report?  Because this isn't hard to mock up in a Modern Dashboard.

If it is a report, what fields do you want and over what timeframe?

I need a report since management doesn't have a login to Solarwinds.  This report will show that availability over the last 7 days

I am looking for something like the dashboard shown.   But we will also need the Node, Availability, and Node Notes for all nodes with less than say 99% uptime over the week.

We are setting up the report to email weekly.   This is mostly going to our Exec team and I know they will not log in to Solarwinds.   They will probably only spend about 2 min looking at the report.

Sorry - dumb question, but how are they going to get reports if they don't have a login?

Why not give them a (read-only) login and make their default page this dashboard?

I'm just trying to understand the needs.

HI,

Can you share this query to create the above mentioned dashboard. 

If i click on any tab , will it take it to list of nodes ? Please share me query on naga.vempati@gmail.com

I uploaded the dashboard (which contains the query to the Content Exchange.

Hey Kevin,  I would like to run just the SWQL queries separately to add some of these to a exec dashboard without the JSON.  Is that possible?

KMSigma can you please assist with SWQL behind these KPI widgets?

I imported and edited the dashboard to get the SWQL. From the great KMSigma Importing/Exporting Modern Dashboards - Orion SDK - The Orion Platform - THWACK - SolarWinds Community

)

SELECT COUNT(*) AS [100% Available]
FROM (
SELECT [Nodes].Caption
     , AVG([Nodes].ResponseTimeHistory.Availability) AS [Availability]
FROM Orion.Nodes AS [Nodes]
WHERE [Nodes].VendorInfo.Name = 'Windows' -- Put whatever filters here
AND [Nodes].ResponseTimeHistory.DateTime BETWEEN GETDATE() - 7 AND GETDATE() -- this is where you define your time period
GROUP BY [Nodes].Caption
HAVING AVG([Nodes].ResponseTimeHistory.Availability) = 100
)

SELECT COUNT(*) AS [99.9% Available]
FROM (
SELECT [Nodes].Caption
     , AVG([Nodes].ResponseTimeHistory.Availability) AS [Availability]
FROM Orion.Nodes AS [Nodes]
WHERE [Nodes].VendorInfo.Name = 'Windows' -- Put whatever filters here
AND [Nodes].ResponseTimeHistory.DateTime BETWEEN GETDATE() - 7 AND GETDATE() -- this is where you define your time period
GROUP BY [Nodes].Caption
HAVING AVG([Nodes].ResponseTimeHistory.Availability) < 100
   AND AVG([Nodes].ResponseTimeHistory.Availability) >= 99.9
)

SELECT COUNT(*) AS [99% Available]
FROM (
SELECT [Nodes].Caption
     , AVG([Nodes].ResponseTimeHistory.Availability) AS [Availability]
FROM Orion.Nodes AS [Nodes]
WHERE [Nodes].VendorInfo.Name = 'Windows' -- Put whatever filters here
AND [Nodes].ResponseTimeHistory.DateTime BETWEEN GETDATE() - 7 AND GETDATE() -- this is where you define your time period
GROUP BY [Nodes].Caption
HAVING AVG([Nodes].ResponseTimeHistory.Availability) < 99.9
   AND AVG([Nodes].ResponseTimeHistory.Availability) >= 99
)

SELECT COUNT(*) AS [95% Available]
FROM (
SELECT [Nodes].Caption
     , AVG([Nodes].ResponseTimeHistory.Availability) AS [Availability]
FROM Orion.Nodes AS [Nodes]
WHERE [Nodes].VendorInfo.Name = 'Windows' -- Put whatever filters here
AND [Nodes].ResponseTimeHistory.DateTime BETWEEN GETDATE() - 7 AND GETDATE() -- this is where you define your time period
GROUP BY [Nodes].Caption
HAVING AVG([Nodes].ResponseTimeHistory.Availability) < 99
   AND AVG([Nodes].ResponseTimeHistory.Availability) >= 95
)

SELECT COUNT(*) AS [90% Available]
FROM (
SELECT [Nodes].Caption
     , AVG([Nodes].ResponseTimeHistory.Availability) AS [Availability]
FROM Orion.Nodes AS [Nodes]
WHERE [Nodes].VendorInfo.Name = 'Windows' -- Put whatever filters here
AND [Nodes].ResponseTimeHistory.DateTime BETWEEN GETDATE() - 7 AND GETDATE() -- this is where you define your time period
GROUP BY [Nodes].Caption
HAVING AVG([Nodes].ResponseTimeHistory.Availability) < 95
   AND AVG([Nodes].ResponseTimeHistory.Availability) >= 90
)

SELECT COUNT(*) AS [Sub 90% Available]
FROM (
SELECT [Nodes].Caption
     , AVG([Nodes].ResponseTimeHistory.Availability) AS [Availability]
FROM Orion.Nodes AS [Nodes]
WHERE [Nodes].VendorInfo.Name = 'Windows' -- Put whatever filters here
AND [Nodes].ResponseTimeHistory.DateTime BETWEEN GETDATE() - 7 AND GETDATE() -- this is where you define your time period
GROUP BY [Nodes].Caption
HAVING AVG([Nodes].ResponseTimeHistory.Availability) < 90
)

Thanks Steven,  works like a champ 

Thanks stevenstadel