How to Know the list of processes run by a User with distribution status description from backend in Peoplesoft

By default the "Process Monitor Process List(PS_PMN_PRCSLIST)" table will not have the description of the Distribution status it will have the Fieldvalue (i.e the translate field value of the DISTSTATUS field) of the distribution status. The below Query will give you the Description of the process distribution status.

Here is the Query to know the Processes ran by a user with its distribution status description:

SQL Syntax:  
select * from PS_PMN_PRCSLIST P,PSXLATITEM X where OPRID='<operator id>  and P.DISTSTATUS=X.FIELDVALUE

Example for The processes Run By the VP1 user:

select OPRID,PRCSINSTANCE, PRCSTYPE, RUNSTATUSDESCR, DISTSTATUS, X.XLATSHORTNAME as DISTSTATUSDESCR from PS_PMN_PRCSLIST,PSXLATITEM X where  X.FIELDNAME='DISTSTATUS' and X.Fieldvalue=DISTSTATUS and  OPRID ='VP1';

How To check the Report Distribution Node From Backend

Some times we may need to check the Report Distribution Node Details from the backend through any SQL Plus or Toad.

The table used for the Report Distribution Node is:  PS_CDM_DIST_NODE
The Query To Execute to know the distribution node details with its node name:

select * from PS_CDM_DIST_NODE where DISTNODENAME='<node_name>'

Replace the <node_name> withe node you want to search for.

Example for PROD node:  select * from PS_CDM_DIST_NODE where DISTNODENAME='PROD';