→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
jbates
Engaged Sweeper
Hi,

I have a report which shows my Windows PC and Servers. It gives a list of the groups and shows the group members, either local or domain. It mearly does what I want ...but I also need to know whether the accounts are enabled or disabled. Want to run this to perform an uadit check ..so need to be able to see that local guest is disabled.

Can anyone help please ?

Here is my current report:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tblUsersInGroup.Groupname As [Group],
tblUsersInGroup.Domainname As User_Domian,
tblUsersInGroup.Username As User_Name
From tblAssets
Inner Join tblUsersInGroup On tblAssets.AssetID = tblUsersInGroup.AssetID
Where tblUsersInGroup.Accounttype = 1
Order By tblAssets.AssetID,
tblUsersInGroup.Groupname
3 REPLIES 3
jbates
Engaged Sweeper
Hi ...thanks for that.

I had just about worked it out. As you say, the problem was becuase of the domain accounts. I know run it as two separate selections and then join them together.

many thanks
John
Hemoco
Lansweeper Alumni
Create a report based on tblUsers and include tblUsers.Disabled. Enabled/disabled status is only scanned for local accounts, not for domain accounts.
jbates
Engaged Sweeper
Hi, any thoughts on this ..I'm really stuck !
Any pointers would be helpful.

many thanks
John