TRY NOW

Active Directory Computer Without Company Audit

Active Directory

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 has no company filled in

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

Show

Hide

NO CREDIT CARD REQUIRED

Ready to get started?
You’ll be up and running in no time.

Explore all our features, free for 14 days.