→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
eac
Engaged Sweeper III
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.
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
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

View solution in original post

3 REPLIES 3
Hemoco
Lansweeper Alumni
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
Engaged Sweeper III
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
Lansweeper Alumni
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