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.
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