Active Directory reports

[eac]

I need to make a report containing all the user accounts with their statuses (enabled/disabled).
Can you give me a hint on how to get access to useraccountcontrol attribute?

Thanks.

[Hemoco · Accepted solution]

You can run the report below to list AD users, but please note that the useraccountcontrol attribute and user status (enabled/disabled) are not scanned.

Select * from tblADusers

[eac]

Thanks a lot for the answer, but no, it's not helping me.
I need the domain users exclusively. It was my mistake I didn't specified this.

[Hemoco]

Hi,

This information is not scanned in Active Directory but it is for local users.
Hope the following report helps you out.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblUsers.Name,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblUsers.Disabled,
tblUsers.Status,
tblUsers.BuildInAdmin
From tblAssets
Inner Join tblUsers On tblAssets.AssetID = tblUsers.AssetID
Order By tblAssets.AssetName,
tblUsers.Name