Generate Audit Report

IdentityIQ (IIQ) IIQ Discussion and Questions
, ,
1

Which IIQ version are you inquiring about?

8.1,8.2

Share all details about your problem, including any error messages you may have received.

I am looking to generate an audit report of all user activity of the default admin “spadmin” after enabling audit configuration in global settings. For eg, in a scenario where the administrator goes and deletes a Role for demonstration purposes, the report needs to capture that event. I found the AuditEvent Object in the debug console and spt_audit_event table in the iiq database. But those wont help in generating a proper format of the report. Any thoughts on how to go about it?

Thanks,
Suresh

2

AllAuditEventsReportDefinition.xml (1.9 KB)
spt_audit_events.csv (125.2 KB)

  1. Attached is a report that I customized and it doesn’t seem to be working it is throwing a null pointer exception.
  2. And also, attached is a complete snapshot my AuditEvent Database.

Can someone help me with regards to what Am I doing wrong?

Appreciate your kind help!

Thanks,
Suresh

3

Hi @sjagirdar1580, I tried updating the columns section to include the field attribute matching the property name and it worked. I have attached the updated TaskDefinition.
All_audit_event_report.xml (2.2 KB)
Hope this helps!

4

Great! It worked..!!

Cheers,
Suresh