The Team Tab of a Project is showing recent updates from a user who is no longer Active in CA PPM, in the field "Last Updated By."
They are originating from a user who has left the company, and whose user record is both Inactive and Locked.
The source of these updates is not known.
There are no Jobs against this user's name shown in the Job Logs.
This query enabled us to identify each time the issue occurred:
(inv.code) AS Project_CODE,
inv.name AS PROJECT_NAME,
abc.user_name AS USER_NAME,
FROM inv_investments inv
JOIN prteam team
ON inv.id = team.prprojectid
INNER JOIN cmn_sec_users abc
ON inv.manager_id = abc.id
WHERE team.last_updated_by = 5104008
BETWEEN TO_DATE('2018/03/01', 'yyyy/mm/dd') AND
Where "team.last_updated_by" is the ID of the user (Resource) who is Inactive and who shows against the Last Modified By date.
And the date range allows you to narrow down the results to a current time period.
<Please see attached file for image>
A result here indicates that an update has been made by the nominated user.
Inactive users should not be making entries.
Note that this query does not check whether the user is Active or Inactive.