Kathyrn - thanks for feedbacks. We also have had to rely heavily on custom queries to piece all this together as the Admin License portlets are more geared towards governing and monitoring licenses than reporting on end user capabilities. And none of them can be exported to excel or such?
Business Challenge: The end users of our organisation are still inquirying why an enterprise system with three/four levels of security access (auto, instance, obs, global) doesn't provide a standard out of box report or end user portlet for viewing access rights. In our case, we extensively use OBS and Supervisors would like to be able to run report or porlets by Resource OBS node and get a listing of all resources in the node and all their corresponding access rights. i will lobby for enhancement, but would like feedback on whether v14.2 jaspersoft capabilities will make this objective easier.
Queries can be translated into a NSQL Query and then put into a Portlet.
Portlets can have data exported into Excel.
I hope this helps.
Agreed. Much thanks for sharing. I just wished that this was standardized oob directly as all implementations that i've encountered over last 10+ years have similiar needs on overall governance and auditing of access rights. Idea perhaps.