← back to articles

Access Report Generator

Access Report Generator

All TRIRIGA access control relies on manager-maintained security groups, each configured for specific user profiles.

While straightforward for basic profile assignments, auditing becomes problematic with hundreds of groups. Reviewing access levels across numerous objects becomes tedious and error-prone.

The tool addresses this by extracting access data for each group across all TRIRIGA objects. Data flows through Excel and macro processing, ultimately delivering organized, tabular results.

Collaboration

"Kush was the brains behind this. Helped with the SQL to get the raw data and also the macro to make it readable." — Kushal Chandarana

Evolution

Initial versions handled basic reporting. Later enhancements incorporated navigation override considerations and single-group data exports.

The solution serves large TRIRIGA implementations well, streamlining security group administration and compliance verification.