ANCILE allows you to generate a comma separated value (.csv) summary report that includes information about each user's group assignments. Using Microsoft Excel, you can open and filter this summary report to determine the groups to which a user belongs.
- ANCILE uAlign
- Follow the steps to generate and download a uAlign summary report.
Open the summary report .csv file using Microsoft Excel.
NOTE: Ensure that Excel uses commas to delimit each column. The resulting spreadsheet should have a separate column for each field in the summary report.
In Microsoft Excel, select the entire spreadsheet and create a new pivot table.
In the new pivot table, assign the field names as follows:
- Assign the Username or Email field to Filters
- Assign the User groups field to Rows
Click the filter arrow next to Username or Email to filter the pivot table for the desired user. The user's assigned groups are listed in the pivot table, separated by commas.
In the example below, the pivot table indicates that user "ancile.demo.81" belongs to 2 groups: All Users and West Region.