I would like to create a report that can be run when an attestation is complete. It would essentially be a report against AttestationCase for a particular attestation policy grouped by XInserted or PolicyProcessed as there may be several attestation cases for a policy (they will run quarterly).
I read this forum post: http://en.community.dell.com/techcenter/iam/f/4789/p/19561203/20561020.aspx. Looks like I need to come up with some SQL and create a custom report. My questions before I start are:
- Can reports have some kind of user input or do I need to create a separate report for each attestation policy?
- Same question but for a particular date when the attestation was started. How would I select a particular run?
- Does anyone have an existing report against AttestationCase that they can share as a starting point?
Thanks,
Aaron