Jetzt Ausprobieren

Computer Part of a Domain

Active Directory Hardware Operating System

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

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

Show

Hide