Report for how long all computers have been switched on over X days

[markdeacon]

Hi,

Now we have a uptime calendar available which is brilliant by the way. I'm wondering if anyone is able to help me create a report that shows how long in hours all of the scanned computers have been switched on over the last X number of days.

Or even better one that would allow you to enter a start date and end date for the report.

We have our scanning server configured to keep all power on data for 365 days.

Thanks in advance,

Mark

[1000ghz · Accepted solution]

Try this:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.IPAddress,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.Uptime,
tblAssets.Username,
tblAssets.Description
From tblAssets
Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Where tblAssetCustom.State = 1
Order By tblAssets.Uptime Desc

The only problem is that the UPTIME counters are in seconds, it means you have to convert them.

Uptime/60 = Minutes
Uptime/3600 = hours
Uptime/3600/24 = Days

Regards,
Enzo