ITCanopy

SELECT u.LOGIN as "User ID" ,res.NAME as "Responsibility" FROM S_USER u left join S_PER_RESP ri on ri.PER_ID = u.ROW_ID left join S_RESP res on res.ROW_ID = ri.RESP_ID WHERE  u.LOGIN IN (' USER.NAME ') ORDER BY u.LOGIN

SELECT TYPE AS 'Type' ,VAL AS 'Display Value' ,NAME AS 'Language-Independent Code' ,LANG_ID AS 'Language Name' ,ORDER_BY AS 'Order' ,ACTIVE_FLG AS 'Active' ,TRANSLATE_FLG AS 'Translate' ,MULTI_LINGUAL_FLG AS 'Multilingual' FROM S_LST_OF_VAL WHERE 1=1 AND TYPE = ' LOV_TYPE '

Get Row Id of Column from Siebel Tools and replace below: SELECT ROW_ID, NAME AS 'Column Name', LENGTH AS 'Column Length' FROM S_COLUMN WHERE ROW_ID = ' 1-6D23-JMI0 ' --UPDATE S_COLUMN SET LENGTH = '255' WHERE ROW_ID = ' 1-6D23-JMI0 '

Below is the query for getting workflow instance monitor values from table: select wfdl.NAME as 'WF Name' ,wfdl.DEPLOY_STATUS_CD as 'Status' ,wfdl.VERSION as 'WF Version' ,wfil.END_TS as 'Instance EndDate' ,wfil.STATUS_CD as 'Instance Status' ,wfsil.STEP_NAME as 'Step Name' ,wfsil.STATUS_CD as 'Step Status' ,wfsl.NAME as 'Process Name' ,wfsl.PROP_VAL as 'Process Value' from S_WFA_DEFN_LOG wfdl join S_WFA_INST_LOG wfil on wfdl.ROW_ID = wfil.DEFINITION_ID  --Process Instance join S_WFA_INSTP_LOG wfsil on wfil.ROW_ID = wfsil.INST_LOG_ID --Step Instance join S_WFA_STPRP_LOG wfsl on wfsil.ROW_ID = wfsl.STEP_LOG_ID  --Process Properties where wfdl.NAME = 'Workflow name with instance monitor level 3' --and wfil.STATUS_CD = 'COMPLETED' --and wfsil.STEP_NAME = 'step name' --and wfsl.NAME <> 'Error Message'