Active Directory Computers Without Location Data Audit

Discover Active Directory Computers with Missing Location Data

Discover computers within your network which do not have a location in their Active Directory information. Lansweeper scans a wide variety of AD information from computers which can be used to audit your IT environment. You can discover and list computers that do not have the required information in their active directory and take action more easily. No need to use PowerShell or Command Line scripts.

Active directory Computer has no location filled in

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

Audit and Take Action in 3 Easy Steps

Download-Install-Lansweeper

1. Download & Install Lansweeper

Save-and-Run-the-Report

3. Run the Audit & Take Action

Download Lansweeper to Run this Audit

Harness the Power of Reporting