→ 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: 
timerland86
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.
1 REPLY 1
ProfileNL
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 🙂