I need a Report

[timerland86]

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.

[ProfileNL]

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 🙂