I have seen a couple posts where other people like myself needed a report that shows an overall average availability for a specific group of nodes. Below is a SQL query I use to pull the total average availability, for the previous month, for Windows and Linux servers within our environment.
So if you need to know the total percentage of availability for all Windows / Linux servers within your environment last month, this is it.
I basically just took the SQL query SolarWinds was using in the report writer for their "Monthly Average Availability" report and doctored it to pull the exact information I needed. Just putting this out here in hopes it may help someone else out. Enjoy!
DECLARE @startOfCurrentMonth DATETIME
SET @startOfCurrentMonth = DATEADD(month, DATEDIFF(month, 0, CURRENT_TIMESTAMP), 0)
sub.SummaryMonth AS Month_Of,
AVG (sub.AVERAGE_of_Availability) as Total_Average
SELECT TOP 10000 Nodes.VendorIcon AS Vendor_Icon,
Nodes.Caption AS NodeName,
Nodes.MachineType AS Machine_Type,
AVG(ResponseTime.Availability) AS AVERAGE_of_Availability,
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community.
More than 150,000 members are here to solve problems, share technology and best practices, and directly
contribute to our product development process.
Learn more today by joining now.