Display all Active directory group

[boupjof]

This report is for list all active directory group scan by lansweeper and made hyperlink for group detail.

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

Replace "mylansweeperserver" by the name of your Lansweeper server (and the port of the web console in case it isn't port 80).

[Michaelzip0]

I keep getting 

This site can’t be reached Check if there is a typo in ls.

DNS_PROBE_FINISHED_NXDOMAIN 

When I click on any of the group links to see who is all in them

[Mister_Nobody]

You have to change server name in URL to your own.

[Daniel_B]

@Mister Nobody: I changed your report as well to make it compatible to SQL Compact which does not support the IsNull function.

[Mister_Nobody]

Our variant has counter with users and subgroups and pre-Windows 2000 groups handler:

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

[Susan_A]

Thank you for the contribution, boupjof. I did replace the varchar entry in your report with nvarchar, as SQL Compact databases don't recognize varchar values. They only support nvarchar.