‎11-16-2021 05:10 PM
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
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now