2 weeks ago
Hi,
I am using the following report to get the total OS count by Windows version.
The SQL query is set to only display "Active" devices. However, when clicking on the totals, the list expands and there are both, "Active" and "Non-active."
Does anyone have a suggestion to completely hide all of the "Non-active" devices found using this report?
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
Solved! Go to Solution.
2 weeks ago
When you click through in the report, you trigger a built-in data object that unfortunately cannot be changed.
2 weeks ago
When you click through in the report, you trigger a built-in data object that unfortunately cannot be changed.
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now