Computer Part of a Domain

Find All Workstations and Servers Which Are Part of an Active Directory Domain

Identify computers missing from your active directory. Get a complete list of all computers that are part of an active directory domain. This also allows you to verify whether any computers are missing from the domain that should be included. If there are computers missing, most likely they will still be in a workgroup. You can find all the computers in a workgroup with the computers part of a workgroup report.

Computer Part of domain

Click to Open - Computer Part of Domain Query
Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetUnique,
  tblAssets.Domain,
  tsysOS.OSname,
  tblAssets.Description,
  tblComputersystem.Lastchanged,
  tsysOS.Image As icon,
  tblAssetCustom.State
From tblAssets
  Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblAssetCustom.State = 1 And tblComputersystem.PartOfDomain = 1
Order By tblAssets.AssetName

Run This Report in 3 Easy Steps

Download-Install-Lansweeper

1. Download & Install Lansweeper

Save-and-Run-the-Report

3. Run the Report

Download Lansweeper to Run this Report

Harness the Power of Reporting