cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Arjan
Engaged Sweeper II
Good day support,

I'm encountering a bit of a challenge at the moment with some reports on Active Directory group memberships.
We currently have some nesting in our Active Directory which works as follows

Group 'Application1' and 'Application2' are member of group 'Role1'
Then we assign an end user to 'Role1' which would will make him/her member of the underlying groups as well (which is nice as you keep access to a certain role instead of an individual).

However, in LANsweeper, I cannot see any groups in a group in my reports.
So when I look at these groups, they appear empty but in reality they have multiple role groups assigned.
Is there any way I can make this visible?

PS: Also checked the user page, where I can see the 'Role1' group, but also on this page I cannot see the underlying groups.

Select Top 1000000 Coalesce(tblADGroups.Name, tblADObjects.sAMAccountName,
'unknown') hyperlink_name_Group,
'http://servername/report.aspx?det=web50usersbyadgroup&title=Active%20Directory%20group:%20' + Coalesce(tblADGroups.Name, tblADObjects.sAMAccountName, 'unknown') + '&@id=' + Cast(tblADGroups.ADObjectID As nvarchar) As hyperlink_Group,
tblADGroups.Description,
tblADGroups.LastChanged,
Count(tblADMembership.ChildAdObjectID) counter
From tblADGroups
Left Join tblADObjects On tblADObjects.ADObjectID = tblADGroups.ADObjectID
Inner Join tblADMembership On tblADObjects.ADObjectID =
tblADMembership.ParentAdObjectID
Group By tblADGroups.Description,
tblADGroups.LastChanged,
tblADObjects.sAMAccountName,
tblADGroups.Name,
tblADGroups.ADObjectID
Order By hyperlink_name_Group
4 REPLIES 4
grandfinalemike
Engaged Sweeper

this report is perfect for our needs.  But is there a way to update the built in web50 report that lists the users in the group, to include the email address as well, or other user attributes.  I am unable to find the resultant report to modify

heybobby1
Engaged Sweeper III
Lansweeper doesn't support nested AD groups. I wish it did.
Arjan
Engaged Sweeper II
@ LANsweeper support. Is this possible at the moment or is this something that could be implemented as a new feature?
ILLUMIASPA
Engaged Sweeper
Good day everyone,
we are also facing the same issue/limitation.
Someone has find a way to get a report that include also nested groups?
Thanks for your help.

Best Regards