Forum Discussion

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

    Thank you!  This is exactly what I needed!