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