Reporting on sqlStatusCode in SQL Server Connection Status MSSQLSERVER

Question

Hello, all!I'm a bit new to reporting on LM and am trying to wrap my head around it.  I'm trying to make a report on the sql server uptime status from SQL Server Connection Status > MSSQLSERVER.  My end goal is to display the percentage of uptime over the past 24 hours, using whatever graph is necessary.I was directed to report on the sqlStatusCode, but that's not necessarily a rule set in stone.  Whenever I look into the Raw Data tab, I see a table that has everything I could...

LM User · Accepted Answer

You need an SLA report. This report calculates what percentage of the time the selected metric meets the criteria. Your criteria would be server uptime > 0 (or maybe greater than a very small number).