→ 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: 
arupert
Engaged Sweeper III
Is there anyway to recover accidentally deleted reports? I am looking for the SQL for the Windows OS chart report.
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
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

View solution in original post

2 REPLIES 2
arupert
Engaged Sweeper III
Exactly what i was looking for. Excellent, thank you.
Hemoco
Lansweeper Alumni
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