Need to Send an Advanced Analytics Search Report as a Scheduled Email

Which IIQ version are you inquiring about?

8.3p1

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

I have a report that I need to schedule to run and email the CSV results monthly to certain people in our organization. The report was configured by creating the search within Advanced Analytics, then saving the search as a report. I see that the report shows up under the “My Reports” tab, and it allows me to schedule it to run monthly. But, I still need this report emailed to certain users when it is run every month. I do not see a way to configure the search report to send the results over email to certain users, as you would be able to do with a typical report. This needs to occur every month and we need to automate this process (rather than simply scheduling the report to run and manually going into SailPoint to save the results and send them to the specific users). How can this be done? Can I edit the XML to add a signature to send the email results to certain users? Do i need to configure a whole new custom report?

you can edit the xml and just add the format of attachment csv/pdf and users to receive email and then schedule it.

 <entry key="emailFileFormat">
        <value>
          <List>
            <String>CSV</String>
          </List>
        </value>
      </entry>
      <entry key="emailIdentities">
        <value>
          <List>
            <String>identityidusername</String>
          </List>
        </value>
      </entry>
1 Like

Thanks a lot! This worked.