Notification

Icon
Error

Uptime Report duplicate powerstates

Posted: Tuesday, November 16, 2021 5:10:23 PM(UTC)
INNO-IT

INNO-IT

Member Alpha Tester Original PosterPosts: 10
1
Like
Hi lansweeper community,

I've a little report problem I hope you can help me with.

I want to create a report to get the uptime stats for some assets.
For this I've created a report to get the eventtype changes together with the eventtime.

The actual report is the following:
Code:
Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblUptime.EventTime,
  tblUptime.EventType,
  Case tblUptime.EventType
    When 1 Then 'power on'
    When 2 Then 'power off'
    When 3 Then 'Start sleep'
    When 4 Then 'End sleep'
    When 5 Then 'Unexpected shutdown'
  End As Event
From tblAssets
  Inner Join tblUptime On tblAssets.AssetID = tblUptime.AssetId
Where tblUptime.EventTime > GetDate() - 7
Order By tblUptime.EventTime Desc


The results seems at first fine, but it provides a lot of "duplicates" of the eventtype with a little difference in the eventtime (a few seconds) like this:
UserPostedImage

Do you have an idea where the double eventtypes comes from and how to avoid these?

Thank you very much.

Active Discussions

Lansweeper SSL with IIS Express Not working
by  fjca   Go to last post Go to first unread
Last post: Yesterday at 8:16:46 PM(UTC)
Lansweeper LsAgent Reliability Problems
by  marck1024  
Go to last post Go to first unread
Last post: Yesterday at 2:09:29 PM(UTC)
Lansweeper 32-BIT Linux LsAgent-linux
by  Anup Chhetri   Go to last post Go to first unread
Last post: Yesterday at 1:30:15 PM(UTC)
Lansweeper Default Scanned item intervals
by  SteelOG  
Go to last post Go to first unread
Last post: 1/25/2022 8:22:45 PM(UTC)
Lansweeper How to delete an asset
by  tgas   Go to last post Go to first unread
Last post: 1/25/2022 4:00:10 PM(UTC)
Lansweeper Can you track local printers attached to Desktops?
by  hirogen  
Go to last post Go to first unread
Last post: 1/25/2022 2:48:22 PM(UTC)
Lansweeper Duplicates - different IP address
by  Lenven   Go to last post Go to first unread
Last post: 1/25/2022 2:12:40 PM(UTC)
Lansweeper Antivirus Up to Date or Not?
by  Lindner  
Go to last post Go to first unread
Last post: 1/25/2022 12:46:21 PM(UTC)