→ 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: 
PapaTuck
Engaged Sweeper III

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

1 ACCEPTED SOLUTION
ErikT
Lansweeper Tech Support
Lansweeper Tech Support

@PapaTuck

 

When you click through in the report, you trigger a built-in data object that unfortunately cannot be changed. 
 

View solution in original post

1 REPLY 1
ErikT
Lansweeper Tech Support
Lansweeper Tech Support

@PapaTuck

 

When you click through in the report, you trigger a built-in data object that unfortunately cannot be changed.