Report to show PC Groups and Users - can I add whether account disabled

[jbates]

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

[jbates]

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]

Create a report based on tblUsers and include tblUsers.Disabled. Enabled/disabled status is only scanned for local accounts, not for domain accounts.

[jbates]

Hi, any thoughts on this ..I'm really stuck !
Any pointers would be helpful.

many thanks
John