Forum Discussion

emetzler's avatar
emetzler
Icon for Neophyte rankNeophyte
7 months ago
Solved

Reporting on sqlStatusCode in SQL Server Connection Status MSSQLSERVER

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.  M...
reporting
  • Anonymous's avatar
    Anonymous
    7 months ago

    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). 

Anonymous's avatar
Anonymous
7 months ago

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). 

emetzler's avatar
emetzler
Icon for Neophyte rankNeophyte
7 months ago

Thank you!  This is exactly what I needed!