Monthly reports displaying accesses in applications

[ACCUTECH SA]

Hello all

I have a requirement from a customer to display specific reports. The use case is as follows:

We have to generate a report choosing the period (eg monthly report) and in this report we need the following info. What users were created/modified/disabled in that time frame along with the accesses in the applications in scope. Also, we need to figure out which of these accesses were assigned from IAM and which of these were assigned directly to the endpoint.

Is this possible ? I know there are OOTB reports that contain such info (eg Entitlement Quality Report), but they are not covering the whole use case.

Any advice ?

Thank you,

Gerasimos

[Sumeet Mahajan]

Getting the desired information in form of reports for auditing or showing to management would be difficult OOTB.

Though information is present in IDM and IP db tables, the information needs to be extracted via SQL join queries.

One option to export data into csv, you may use Pentaho PDI Kettle scripts. Otherwise you need to go with reporting solution like Jasper.

Hope that helps.

Regards,

Sumeet