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.
Click to Open - Active Directory Computer Without Company Query
Select Top 1000000 tblAssets.AssetID, tblAssets.AssetUnique, tblAssets.Domain, tsysOS.OSname, tblAssets.IPAddress, Coalesce(tblADComputers.Company, N'') As Company, tsysOS.Image As icon, tblADComputers.Lastchanged 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 Where Coalesce(tblADComputers.Company, N'') = '' And tblAssetCustom.State = 1 Order By tblAssets.AssetName