• State Not Answered
  • +2 person also asked this people also asked this
  • Locked Locked
  • Replies 3 replies
  • Subscribers 97 subscribers
  • Views 7217 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Reports on attestation cases

aaronanderson
over 10 years ago

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:

  1. Can reports have some kind of user input or do I need to create a separate report for each attestation policy?
  2. Same question but for a particular date when the attestation was started. How would I select a particular run?
  3. Does anyone have an existing report against AttestationCase that they can share as a starting point?

Thanks,

Aaron

  • 0 over 8 years ago

    Hi Aaron,

    Im wanting to achieve the same thing, have you had any success with this?

     

    Thanks, 

    Ash

  • 0 over 8 years ago
    Hi,

    1) You can have custom parameters in the report. In your case, I think what you are looking for are 2 parameters - one which takes the attestation policy and one which takes the date after which cases were denied. I would suggest looking at some OOTB reports in report editor to see how input variables work.

    2) This would be controlled by the SQL query you write. The query would incorporate the report variable (e.g. XDateUpdated > @FromDate) where @FromDate is the input variable you take in your report

    3) Sorry, I don't have any queries readily available. If you can write the SQL to extract the data you want, you've done the hard part of generating the report :)
  • 0 over 8 years ago

    Aaron,

    Attached is for the customer how their custom report created in Report Editor. The reports have been used in their PROD. HTH.

    4382.Custom Report Using D1IM Report Editor.pdf