SOME USEFUL COMMAND IN DAILY OPERATION

FIND OUT XREF CORELATION :

SELECT MAX(DECODE(SUBSTR(XREF_COLUMN_NAME,0,3), 'BRM', XREF_COLUMN_NAME, NULL)) SOURCE_ID,
    MAX(DECODE(SUBSTR(XREF_COLUMN_NAME,0,3), 'BRM', VALUE, NULL)) BRM,
    MAX(DECODE(XREF_COLUMN_NAME, 'COMMON', VALUE,NULL)) COMMON,
    MAX(DECODE(SUBSTR(XREF_COLUMN_NAME,0,4), 'SEBL', VALUE,NULL)) SIEBEL
  FROM (select * from xref_data where row_number in
(select row_number from xref_data where value in ('0.0.0.1 /billinfo 3199952544 0')))
  WHERE IS_DELETED     ='N'
  AND (XREF_TABLE_NAME ='oramds:/apps/AIAMetaData/xref/CUSTOMERPARTY_BILLPROFILEID.xref')
  GROUP BY row_number,
    XREF_TABLE_NAME;


FIND INSTANCES BETWEEN TIMESTAMP :

select b.ID, Decode(a.state,5,'SUCCESS','FAILED') "STATUS",a.component_name,b.title,

TO_CHAR(a.creation_date,'MM/DD/YYYY HH24:MI:SS') "CRERATED DATE TIME", TO_CHAR(a.modify_date,'MM/DD/YYYY HH24:MI:SS')"MODIFIED TIME",

TO_CHAR(SUBSTR((a.modify_date-a.creation_date),15,2))*60+TO_CHAR(SUBSTR((a.modify_date-a.creation_date),18,6)) "Duration in Seconds"

from VFQ_SOAINFRA.cube_instance a,VFQ_SOAINFRA.composite_instance b where

a.cmpst_id=b.ID and component_name like '%QueryServiceUsageBRMCommsProvABCSImplProcess%'

and a.creation_date between

TO_DATE('11/23/2015 10:00:00','MM/DD/YYYY HH24:MI:SS') and

TO_DATE('11/23/2015 13:00:00','MM/DD/YYYY HH24:MI:SS')

order by creation_date desc ;

FIND INSTANCES FROM TITLE :

select b.ID "Instance ID",b.title "Name",a.composite_name"Composite",Decode(a.state,5,'SUCCESS','FAILED')"Instance State",a.modify_date "Time",
TO_CHAR(SUBSTR((a.modify_date-a.creation_date),18,6)) "Execution_Time" from cube_instance a,composite_instance b where
a.cmpst_id=b.ID and b.title like '%1-212121212121%' order by 5 desc;

CURL COMMAND :

curl -H "Content-type: text/xml;charset=UTF-8" --data "<?xml version='1.0' encoding='UTF-8'?><soapenv:Envelope xmlns:soapenv='http://schemas.xmlsoap.org/soap/envelope/' xmlns:cus='http://siebel.com/CustomUI' xmlns:data='http://www.siebel.com/xml/MITProvisionItemsIO/Data'><soapenv:Header><UsernameToken xmlns='http://siebel.com/webservices'>AIAINDB</UsernameToken><PasswordText xmlns='http://siebel.com/webservices'>AIAINDB</PasswordText><SessionType xmlns='http://siebel.com/webservices'>Stateful</SessionType><SessionToken xmlns:siebel-header='http://siebel.com/webservices'></SessionToken></soapenv:Header></soapenv:Envelope>" "http://avpr-crmlb:7777/eai_enu/start.swe?SWEExtSource=WebService&SWEExtCmd=Execute&WSSOAP=1"