→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

Showing results for 
Show  only  | Search instead for 
Did you mean: 
Engaged Sweeper
Hi, I need a report.
All devices which have entered "FD102" in Custom1 or are in the OU "102".

The devices in Custom1 are created manually. The Pcs in the OU are automatically there, I need for the inventory a query to display all devices which are either in the OU or what certain specified under Custom1.
Engaged Sweeper III

Select Top (1000000) tblAssets.AssetName, tblAssetcustom.Custom1, tblADComputers.OU
From tblAssets
Inner Join tblAssetcustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblADcomputers on tblAssets.AssetID = tblADComputers.AssetID
Where Custom1 = 'FD102' Or OU ='102'

I'm recommending you to take a look at the SQL language because lansweeper reports/queries are basicly made by SQL. Once you understand how SQL works, creating reports/queries wont be a hard task 🙂