09-30-2015 10:19 AM
Select Top 1000000 tblADGroups.Name As hyperlink_name_Group,
'http://mylansweeperserver/report.aspx?det=web50usersbyadgroup&title=Active%20Directory%20group:%20'
+ tblADGroups.Name + '&@id=' + Cast(tblADGroups.ADObjectID As nvarchar) As hyperlink_Group,
tblADGroups.Description,
tblADGroups.LastChanged
From tblADGroups
Order By hyperlink_name_Group
01-16-2024 11:07 PM
I keep getting
This site can’t be reached Check if there is a typo in ls.
01-17-2024 03:52 AM
You have to change server name in URL to your own.
10-15-2015 03:28 PM
10-15-2015 11:40 AM
Select Top 1000000 Coalesce(tblADGroups.Name, tblADObjects.sAMAccountName,
'unknown') hyperlink_name_Group,
'http://ls/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
Inner 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
10-14-2015 01:07 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now