Forum Discussion

emetzler's avatar
emetzler
Icon for Neophyte rankNeophyte
11 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
    11 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
11 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
11 months ago

Thank you!  This is exactly what I needed!