→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Patrik_Felix
Engaged Sweeper
Hi

Is it possible to make at report that only shows the information when a asset where ON
in the Uptime calendar ( calculate all the GREEN results )

The goal with the report is to see how many hours the Asset has totaly been on since first seen i lansweeper

// Patrik
1 ACCEPTED SOLUTION
Susan_A
Lansweeper Alumni
There is no easy way to do this with a SQL report, as what is stored in the database are just uptime events: reboots, shutdowns... The Summary tab of computer webpages uses a special procedure to convert this information into a calendar. We posted a sample report that attempts to summarize the uptime calendar here, but this report only works in SQL Server, may be slow to run and is limited in days.

View solution in original post

1 REPLY 1
Susan_A
Lansweeper Alumni
There is no easy way to do this with a SQL report, as what is stored in the database are just uptime events: reboots, shutdowns... The Summary tab of computer webpages uses a special procedure to convert this information into a calendar. We posted a sample report that attempts to summarize the uptime calendar here, but this report only works in SQL Server, may be slow to run and is limited in days.