Some Nice-to-have SQLs

The SQL scripts have been grouped in the following categories.    Components, Component-Interfaces related queries    Portal Navigation    Process Scheduler    Users, Roles and Permissions    Users logged in    SQLs related to PS-Query    Trees Category: Components, Component-Interfaces related queries 01) SQL Query to find search records in a CI     SELECT SEARCHRECNAME, ADDSRCHRECNAME       FROM PSBCDEFN      WHERE BCNAME = 'AJ_MAP_XLAT_TBL_CI'; 02) SQL QUERY TO FIND OUT THE RECORDS EXPOSED BY A CI     SELECT DISTINCT RECNAME       FROM PSBCITEM      WHERE BCNAME = 'AJ_MAP_XLAT_TBL_CI'; 03) SQL Query to find out the Component associated with a Component Interface     SELECT BCPGNAME,MARKET,MENUNAME      FROM PSBCDEFN      WHERE BCNAME = 'AJ_MAP_XLAT_TBL_CI'; 04) Identify which USER, ROLE and PERMISSION-LIST has access to a Component Interface     SELECT DISTINCT R.ROLEUSER AS USER_IDS, C.ROLENAME as ROLE,  P.CLASSID AS PERMISSION_LIST       FROM PSROLEUSER R,