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
