How to find out what element is firing email notifications in Maximo?

Body

The email notifications in Maximo are basically processed for communication templates and escalations records or workflow processes nodes where the email notification can be also configured.

For example, you can use escalations to monitor time-sensitive records and key performance indicators (KPIs). When you create escalation records, you can specify that email notifications are generated when a record reaches the defined escalation point.

For workflow, you can design a workflow process to generate notifications about the progress of a specific record. Notifications can be made through email or through pager, providing that your paging
system supports email. When you design a workflow process that includes email notifications, you can create the notification, and apply a communication template and change or complete the notification.

The email that the customer was getting all the time is this :

Subject: Your Service Request 14078 has been Sent.

But the customer did not know where this was coming from.

So, I had him to run this query to find what communication templates had a subject like that.

SELECT * FROM COMMTEMPLATE ORDER BY SUBJECT

We found there were 2 communication templates, called TPSENT and WOSENT. Then I asked the customer to find out whether those emails were coming from escalations or workflow processes, by running the SQL below :

SELECT * FROM ESCNOTIFICATION WHERE TEMPLATEID IN ('TPSENT','WOSENT')
(no results)

SELECT * FROM WFNOTIFICATION WHERE TEMPLATEID IN ('TPSENT','WOSENT')
(returned 3 rows)

We found the Workflow process called SR (Revision 68) was associated to both of those communication templates, on some of the nodes.

I asked customer to check the logic implemented in the WF process and then remove the communication which is no longer required. They will work on this, and since we found out where the emails are working from, customer will work on adjusting the logic in his WF process.

See ya