05-03-2017 12:03 PM
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
08-17-2023 05:15 PM
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
06-20-2017 02:06 PM
06-20-2017 01:23 PM
05-31-2017 06:32 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now