Jetzt Ausprobieren

Active Directory Enabled/Disabled Computers Audit

Active Directory

Find Disabled Active Directory Computers

Active Directory is used in almost all organizations to organize and manage both devices and users. Lansweeper can scan assets directly from active directory along with a wide range of active directory attributes like the status of AD computers. This audit gives you a list of all your active directory assets and whether they are enabled or disabled. Lansweeper will find any enabled Active Directory computer and disabled active directory computer. Additionally, basic information about the computers is also displayed and they are hyperlinked so you can click through to individual computers to take a look at all the details. This lets you easily find disabled computers without the need of Powershell scripts or CMD commands and shows it all in one overview. Enabled Disabled AD Computers  

Active Directory Enabled/Disabled Computers Query

Select Top 1000000 Coalesce(os.Image, at.AssetTypeIcon10) As Icon,
  a.AssetID,
  a.AssetName,
  Case
    When Coalesce(adc.IsEnabled, 0) = 0 Then 'False'
    Else 'True'
  End As EnabledInAD,
  at.AssetTypename As Type,
  a.Domain,
  a.Username,
  a.Userdomain,
  a.IPAddress,
  a.Description,
  ac.Manufacturer,
  ac.Model,
  Case (a.Assettype)
    When -1 Then os.OSname
    When 11 Then ls.OSRelease
    When 13 Then mi.SystemVersion
    Else ''''
  End As OS,
  a.SP As SP,
  ac.Location,
  tsysIPLocations.IPLocation,
  a.Firstseen,
  a.Lastseen
From tblAssets a
  Inner Join tblADComputers adc On a.AssetID = adc.AssetID
  Inner Join tblAssetCustom ac On a.AssetID = ac.AssetID
  Inner Join tsysAssetTypes at On at.AssetType = a.Assettype
  Inner Join tblState s On s.State = ac.State
  Left Join tsysOS os On a.OScode = os.OScode
  Left Join tblLinuxSystem ls On ls.AssetID = a.AssetID
  Left Join tblMacOSInfo mi On mi.AssetID = a.AssetID
  Left Outer Join tsysIPLocations On a.LocationID = tsysIPLocations.LocationID
Where s.Statename = 'Active'
Order By adc.IsEnabled Desc,
  a.Assettype,
  a.AssetName

Show

Hide