1. Open MS SQL Management Studio copy paste below query in query window.
SELECT Prof.NAME AS 'Profile Name'
,ParNam.NAME AS 'Parameter Name'
,Par.VALUE AS 'Parameter Value'
FROM S_CM_PROF Prof
LEFT JOIN S_CM_PROF_PARM Par ON Par.CM_PROF_ID = Prof.ROW_ID
LEFT JOIN S_CM_CNCTR_PARM ParNam ON ParNam.ROW_ID = Par.CM_CNCTR_PARM_ID
WHERE 1=1
AND Prof.NAME = 'Email Profile Name'
2. Go to site map in Siebel Client search for Communication Drivers and Profile, copy the name of desired Email profile and add it in above query. Run the query and you will have all parameters and their values of that profile.
SELECT Prof.NAME AS 'Profile Name'
,ParNam.NAME AS 'Parameter Name'
,Par.VALUE AS 'Parameter Value'
FROM S_CM_PROF Prof
LEFT JOIN S_CM_PROF_PARM Par ON Par.CM_PROF_ID = Prof.ROW_ID
LEFT JOIN S_CM_CNCTR_PARM ParNam ON ParNam.ROW_ID = Par.CM_CNCTR_PARM_ID
WHERE 1=1
AND Prof.NAME = 'Email Profile Name'
2. Go to site map in Siebel Client search for Communication Drivers and Profile, copy the name of desired Email profile and add it in above query. Run the query and you will have all parameters and their values of that profile.
Comments
Post a Comment