Active Directory Reports

[jons115]

I am looking to create two reports, one that shows only domain administrators and another showing all domain users, which also shows if the users are disabled.
Thanks for your help regarding this.

[Hemoco · Accepted solution]

jons115 wrote:
which also shows if the users are disabled

Lansweeper does not store this information in the database, so you cannot report on it. For the remaining data, please use the reports below.

All domain users

Select * from tbladusers

Domain administrators

Select Top 1000000 tblADusers.Username,
tblADusers.Userdomain,
tblADusers.Firstname,
tblADusers.Lastname,
tblADusers.Name,
tblADusers.Displayname
From tblADusers
Inner Join tblUsersInGroup On tblUsersInGroup.Username = tblADusers.Username
And tblUsersInGroup.Domainname = tblADusers.Userdomain
Where tblUsersInGroup.Admingroup = 1