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"
