Forum Discussion

emetzler's avatar
emetzler
Icon for Neophyte rankNeophyte
20 days 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
  • Stuart_Weenig's avatar
    Stuart_Weenig
    20 days 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). 

Stuart_Weenig's avatar
Stuart_Weenig
Icon for Mastermind rankMastermind
20 days 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
    16 days ago

    Thank you!  This is exactly what I needed!