I am not an SQL expert. Would like to create a clickable report for all the Active Directory Groups (Security and Distribution). Something similar to which we have built in report for Departments.
Note: Also there are groups which contain "Computer Objects" instead of user objects.
Creating a report where you can click through is not really supported at the moment. You can do it, but that would not easily be maintainable. The best might be to create a report that lists your AD users together with the AD groups they are member of. This page provides an example.
Please note that AD groups will only be added to your Lansweeper database if you are scanning the OU in which the AD group accounts are location with Domain User Scanning.
Creating a report where you can click through is not really supported at the moment. You can do it, but that would not easily be maintainable. The best might be to create a report that lists your AD users together with the AD groups they are member of. This page provides an example.
Please note that AD groups will only be added to your Lansweeper database if you are scanning the OU in which the AD group accounts are location with Domain User Scanning.