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

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/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.

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

Resolution

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.