How to identify scheduled reports emailed to a user removed from UIM then stop the report from being sent to this user?

Document ID : KB000115168
Last Modified Date : 17/09/2018
Show Technical Document Details
Introduction:
After deleting a user from UIM, it was discovered that this user set up reporting behaviors in UMP that email this account directly.  Need to know how to change this behavior.
Question:
How to identify scheduled reports emailed to a user removed from UIM then stop the report from being sent to this user?
Environment:
UIM/UMP 8.51
Answer:
Execute the following SQL query against the UIM database to identify scheduled reports that are emailed:

select ue.recipient,uj.name from umpEmailInfo ue
left join umpJob uj on
ue.id = uj.emailInfo where emailInfo is not NULL;

This will generate a list of email address templates configured and the names of the Scheduled report job associated with the email templates.
With this information, it is possible to go into the UMP ReportScheduler portlet and do one of the following for the reports that are mailed to this user:

1. Disable the report job
2. Delete the report job
3. Modify the Delivery email template for the report job and specify a new set of recipients.