Deleted chart report for Windows OS

[arupert]

Is there anyway to recover accidentally deleted reports? I am looking for the SQL for the Windows OS chart report.

[arupert]

Exactly what i was looking for. Excellent, thank you.

[Hemoco · Accepted solution]

You can recreate the report in the report builder.

Name: Chart: Windows operating systems

SQL syntax:


Select Top 1000000 tsysOS.OSname,
Count(tblAssets.AssetID) As Total
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblAssetCustom.State = 1 And tblAssets.Assettype = -1
Group By tsysOS.OSname
Order By Total Desc