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';