Asset Uptime Report from Calendar

[NathanGibson]

I'm looking for a report to have the weekly/monthly average power-on time for all assets. 

The information that is contained on the Uptime calendar when selecting a specific asset is what I want in a report format. 

I did see this previous post from 2016 that links to a since removed page. 

https://community.lansweeper.com/t5/reports-analytics/asset-totalt-uptime-from-uptime-calendar/m-p/2... 

https://www.lansweeper.com/Forum/yaf_postst10565_Calculate-computer-online-time--needs-SQL-Server.as... 

Anyone have any ideas how to accomplish this? 

[DavidPK]

Hi

We've created a sample report. Instructions for adding this report to your Lansweeper installation can be found here: https://www.lansweeper.com/knowledgebase/how-to-add-a-report-to-your-lansweeper-installation/

If you are interested in building or modifying reports, we do recommend:
Reviewing some SQL tutorials, as the Lansweeper report builder is a standard SQL editor. If you know SQL, you know how to build Lansweeper reports as well. This seems like a good tutorial: https://www.w3schools.com/sql/
Making use of our database dictionary, which explains in great detail what each database table and field stores. More information on the dictionary can be found here: https://www.lansweeper.com/knowledgebase/accessing-the-lansweeper-database-documentation/
Checking out our report library: https://www.lansweeper.com/report/

Select Top 1000000 tblAssets.AssetID,

  tblAssets.AssetName,

  tblAssets.Domain,

  tsysAssetTypes.AssetTypename As AssetType,

  tblAssets.Username,

  tblAssets.Userdomain,

  tblAssets.IPAddress,

  tblAssetCustom.Manufacturer,

  tblAssetCustom.Model,

  tblAssetCustom.Serialnumber,

  tblAssets.Firstseen,

  tblAssets.Lastseen,

  tblAssets.Lasttried,

  Convert(nvarchar(10),Ceiling(Floor(Convert(integer,tblAssets.Uptime) / 3600 /

  24))) + ' days ' +

  Convert(nvarchar(10),Ceiling(Floor(Convert(integer,tblAssets.Uptime) / 3600 %

  24))) + ' hours ' +

  Convert(nvarchar(10),Ceiling(Floor(Convert(integer,tblAssets.Uptime) % 3600 /

  60))) + ' minutes' As Uptime,

  tsysOS.OSname,

  tsysOS.Image As icon

From tblAssets

  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID

  Left Join tsysOS On tblAssets.OScode = tsysOS.OScode

  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype

Where tsysAssetTypes.AssetTypename = 'Windows' And (tsysOS.OSname Like

    '%Win 2008%' Or tsysOS.OSname Like '%Win 2012%')