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...