→ 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: 
mydurian
Engaged Sweeper II
Hi All,

My boss wants to catch users whom do not turn off their PC after business hours.
Hence, would like to know whether it's possible to show this in a report?

Report Format looking for:

Hostname | Last Powered On DateTime | Scan Datetime | Durations | Last User Logged On |



thank you,

1 ACCEPTED SOLUTION
Daniel_B
Lansweeper Alumni
Could you give the following report a try:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tUptime.[Last power on time],
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.Lastseen As [Last scan],
Ceiling(tblAssets.Uptime /
3600) As [uptime since boot up during last scan (h)],
tblAssets.Username As [Last user logged on]
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Left Join (Select tblUptime.AssetId,
Max(tblUptime.EventTime) As [Last power on time]
From tblUptime
Where tblUptime.EventType In (1, 4)
Group By tblUptime.AssetId) tUptime On tUptime.AssetId = tblAssets.AssetID
Where tblAssetCustom.State = 1 And tblAssets.Assettype = -1
Order By tblAssets.AssetName

View solution in original post

1 REPLY 1
Daniel_B
Lansweeper Alumni
Could you give the following report a try:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tUptime.[Last power on time],
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.Lastseen As [Last scan],
Ceiling(tblAssets.Uptime /
3600) As [uptime since boot up during last scan (h)],
tblAssets.Username As [Last user logged on]
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Left Join (Select tblUptime.AssetId,
Max(tblUptime.EventTime) As [Last power on time]
From tblUptime
Where tblUptime.EventType In (1, 4)
Group By tblUptime.AssetId) tUptime On tUptime.AssetId = tblAssets.AssetID
Where tblAssetCustom.State = 1 And tblAssets.Assettype = -1
Order By tblAssets.AssetName