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 Query
Select Top 1000000 tsysOS.Image As icon, tblAssets.AssetID, tblAssets.AssetName, 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, tblAssets.Firstseen, tblAssets.Lastseen 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 Left Join tsysIPLocations On tblAssets.IPNumeric >= tsysIPLocations.StartIP And tblAssets.IPNumeric <= tsysIPLocations.EndIP Where tblComputersystem.PartOfDomain = 1 And tblAssetCustom.State = 1 Order By tblAssets.AssetName