Forum Discussion

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

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
    4 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

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
4 months ago

Thank you!  This is exactly what I needed!