How to Reduce Graph Clutter In Reports With AD Group Filtering

I’m having issues with the reporting graphs, as large user numbers are making some of the graphs too compressed to read.

If your reports have so many users that graphs start to become cluttered, the best approach is to segment/filter your reports out by AD group. You can do this by creating AD group based filters for your scheduled reports.

Dynamic Domain Group Member Filtering

In more complex environments, such as those maintained by Managed Service Providers and SaaS Providers, you may need to dynamically filter reports based on membership in domain groups. When you turn on dynamic domain group filtering, Remote Desktop Reporter restricts the data returned to a report based on current domain group membership at run time. In other words, it builds a dynamic SQL query when executed that will only match (or alternatively, exclude) a select list of users. This is ideal if membership in groups change frequently – whenever the report is built manually or scheduled, the Active Directory server will always be consulted to get the most up-to-date list of users for a given group.

To enable dynamic group member filtering, first select the Username field to filter on when in Filter Design Mode. Then, click the Build button to build a filter based on the Username field. When in Filter Build Mode, check the Dynamically return all members from domain group option, and the select (or type in) the name of the AD group whose member list will be obtained when the report is run. If you want the report to only return records where the user is a member of the group, select the Return ONLY the selected items option. Conversely, if you want the report to exclude all records where the user is a member of a specific domain group, select the Exclude the selected items option.

Once you select the appropriate group, click OK to return back to Filter Design Mode. You will now see that there is a descriptor in the Username field that is structured like so: USERNAMEIN:[DOMAIN\GROUP NAME] or USERNAMENOTIN:[DOMAIN\GROUP NAME]. You can use this shorthand in the future (make sure you include the USERNAMEIN or USERNAMENOTIN designator, colon, and DOMAIN and GROUP NAME bounded in square brackets.)