Finding the source of a notification email

Products

• CA Harvest Software Change Manager - OpenMake Meister
• CA Harvest Software Change Manager

Issue/Introduction

I am getting an automatic email notification.  The subject line is as follows:

"CCC/Harvest Message"

When I search for a notification process, there are none with that subject line.

What is the best way to find where these messages are coming from?

Environment

Harvest Software Change Manager all versions

Resolution

These SQL queries can produce a list of all notify processes in the Harvest database (works with Oracle and with SQL Server):

For stand-alone notify processes:

SELECT E.ENVIRONMENTNAME, S.STATENAME, N.PROCESSOBJID, N.PROCESSNAME, 
N.MAILFACILITY, N.SUBJECT, N.MESSAGE, E.ENVISACTIVE 
FROM HARENVIRONMENT E 
INNER JOIN HARSTATE S ON E.ENVOBJID = S.ENVOBJID 
INNER JOIN HARNOTIFY N ON S.STATEOBJID = N.STATEOBJID

For pre-linked and post-linked notify processes:

SELECT E.ENVIRONMENTNAME, S.STATENAME, E.ENVISACTIVE, SP.PROCESSNAME AS PARENT, 
LP.PROCESSPRELINK, N.PROCESSNAME, N.MAILFACILITY, N.SUBJECT, N.MESSAGE 
FROM HARENVIRONMENT E 
INNER JOIN HARSTATE S ON E.ENVOBJID = S.ENVOBJID 
INNER JOIN HARSTATEPROCESS SP ON S.STATEOBJID = SP.STATEOBJID 
INNER JOIN HARLINKEDPROCESS LP ON SP.PROCESSOBJID = LP.PARENTPROCOBJID AND SP.STATEOBJID = LP.STATEOBJID INNER JOIN HARNOTIFY N ON LP.PROCESSOBJID = N.PROCESSOBJID AND LP.PARENTPROCOBJID = N.PARENTPROCOBJID

Additional Information

More information about setting up notification messages in Harvest can be found here: Set Up the Mail Utilities