Discover Active Directory Computers with Missing Company Information
Discover computers within your network which do not have a company filled in their Active Directory information. Lansweeper scans a wide variety of AD information from computers which can be used to audit your IT environment. This allows you to find users or computers missing specific information in AD that they should have, without the need of creating and running custom PowerShell or Command Line scripts. Make sure that your AD computers all have the required information by running the audit below.
Active Directory Computer Without Company Query
Select Top 1000000 tsysOS.Image As icon, tblAssets.AssetID, tblAssets.AssetName, Coalesce(tblADComputers.Company, N'') As Company, tblAssets.Domain, tblAssets.Username, tblAssets.Userdomain, tblAssets.IPAddress, tblAssets.Description, tblAssetCustom.Manufacturer, tblAssetCustom.Model, tblAssetCustom.Location, tsysIPLocations.IPLocation, tsysOS.OSname As OS, tblAssets.SP As SP, tblADComputers.IsEnabled As EnabledInAD, tblAssets.Firstseen, tblAssets.Lastseen From tblAssets Inner Join tblADComputers On tblAssets.AssetID = tblADComputers.AssetID Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode Left Join tsysIPLocations On tsysIPLocations.StartIP <= tblAssets.IPNumeric And tsysIPLocations.EndIP >= tblAssets.IPNumeric Where Coalesce(tblADComputers.Company, N'') = '' And tblAssetCustom.State = 1 Order By tblAssets.AssetName