Question

Terminated operators - Audit request

Hi - our auditors would like a list of the users that have been removed from our pega platform application over the last quarter. Is there a query against a table that can be run to get the user identifier and the date they were removed from the pr_operator table? I'm thinking that information is stored somewhere since if you recreate a user that was previously removed you can see all of the change history for the id.

***Edited by Moderator: Lochan to update platform capability tags***

Correct Answer
November 21, 2019 - 1:44am

Hi Mark,

 

When you delete an operator from Designer Studio, the record will be deleted from pr_operators table, but the record related to this operator will be present in pr_history_data table.

You can write a select query to list out all the operators record from this table using where clause (where pxobjclass= 'History-Data-Admin-Operator-ID').

 

Regards,
Vikash

Comments

Keep up to date on this post and subscribe to comments

November 21, 2019 - 1:44am

Hi Mark,

 

When you delete an operator from Designer Studio, the record will be deleted from pr_operators table, but the record related to this operator will be present in pr_history_data table.

You can write a select query to list out all the operators record from this table using where clause (where pxobjclass= 'History-Data-Admin-Operator-ID').

 

Regards,
Vikash

November 21, 2019 - 2:52am

By the way it isn't really recommended to remove operator. It would be better to just block them from receiving/processing any work. 

November 21, 2019 - 7:59am
Response to MarcLasserre_GCS

When a user has left the company they must be removed from all systems.