→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
RobertMcD
Engaged Sweeper
Ive seen a lot of report with the server uptime in Days but I am trying to create a report that uses the Uptime Calendar information to calculate a % value against a given period i.e. Calendar Month.

Has anyone tried this and succeeded?
1 ACCEPTED SOLUTION
Susan_A
Lansweeper Alumni
You should be able to find the total uptime for the month on the computer webpage itself, but there's no easy way to include this information in a SQL report. What is stored in the database are just the uptime events: reboots, shutdowns etc. Computer webpages use a special procedure to convert this information into an uptime calendar.

We did post a sample report that summarizes uptime information here, but this will only work for databases hosted in SQL Server. The report can be slow to run as well and is not easily modifiable.

View solution in original post

1 REPLY 1
Susan_A
Lansweeper Alumni
You should be able to find the total uptime for the month on the computer webpage itself, but there's no easy way to include this information in a SQL report. What is stored in the database are just the uptime events: reboots, shutdowns etc. Computer webpages use a special procedure to convert this information into an uptime calendar.

We did post a sample report that summarizes uptime information here, but this will only work for databases hosted in SQL Server. The report can be slow to run as well and is not easily modifiable.