API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Nov 11th, 2016
127
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 14.66 KB | None | 0 0
raw download clone embed print report
  1. Hello Everyone,
  2.  
  3. I have this log file below, and I would like to extract the XML in the middle of it by using a field as input search <ns12:equipmentId>089471386301077634</ns12:equipmentId>, so the script should do a search in the log file by 089471386301077634 and return me the entire XML as <ns1:queryDeviceInfoBtRequest... till </ns1:queryDeviceInfoBtRequest>, any Idea how it could be done?
  4.  
  5.  
  6. ...
  7. ..
  8. .
  9. 2016/11/09 07:29:18
  10. Request:
  11. mqMessage:
  12. MQMD:[queue=EKS01A2T/EKS.QUERYDEVICEINFO,applicationOriginData= ,format=MQSTR ,backoutCount=0,characterSet=1208,correlationId=000000000000000000000000000000000000000000000000,encoding=273,expiry=500,messageId=414D51204450303141325420202020205788160022E00ACA,persistence=0,putApplicationName=WebSphere Datapower MQClient,putDateTime=2016-10-9T12:29:18.490-GMT,replyToQueueManagerName=DP01A2T ,replyToQueueName=76S.REPLY16 ,userId=null]
  13. Data:[<?xml version="1.0" encoding="UTF-8"?>
  14.  
  15. <ns1:queryDeviceInfoBtRequest xmlns:ns1="http://integration.sprint.com/integration/interfaces/queryDeviceInfoBtV1/v1/queryDeviceInfoBtV1">
  16. <ns3:mqMessageHeader xmlns:ns3="http://integration.sprint.com/public/interfaces/MQMessageHeaderV2.xsd">
  17. <ns3:messageHeaderVersion>2</ns3:messageHeaderVersion>
  18. <ns3:serviceName>queryDeviceInfoBt</ns3:serviceName>
  19. <ns3:serviceQualifier>76S</ns3:serviceQualifier>
  20. <ns3:serviceVersion>1</ns3:serviceVersion>
  21. <ns3:dialogTypeCode>2</ns3:dialogTypeCode>
  22. <ns3:dialogSubTypeCode>1</ns3:dialogSubTypeCode>
  23. <ns3:parentDialogReference>7V2-CONVID-aab02e21</ns3:parentDialogReference>
  24. <ns3:dialogReference>7V2-MSGID-SP-aab02e21</ns3:dialogReference>
  25. <ns3:applicationReference>7V2</ns3:applicationReference>
  26. <ns3:applicationGroup>7V2</ns3:applicationGroup>
  27. <ns3:componentGroup>Equipment</ns3:componentGroup>
  28. <ns3:componentName>queryDeviceInfoBt</ns3:componentName>
  29. <ns3:reqSentDateTime>2016-11-09T07:29:18.003-05:00</ns3:reqSentDateTime>
  30. <ns3:applicationUserId>7V2</ns3:applicationUserId></ns3:mqMessageHeader>
  31. <data xmlns="http://integration.sprint.com/integration/interfaces/queryDeviceInfoBtV1/v1/queryDeviceInfoBtV1">
  32. <ns12:queryDeviceInfo xmlns="http://integration.sprint.com/interfaces/validateDevice/v8/validateDeviceV8.xsd" xmlns:ns2="http://integration.sprint.com/common/header/WSMessageHeader/v2" xmlns:ns3="http://integration.sprint.com/common/ErrorDetailsV2.xsd" xmlns:ns4="http://integration.sprint.com/interfaces/queryDeviceResourceInfo/v1/queryDeviceResourceInfo.xsd" xmlns:ns5="http://integration.sprint.com/interfaces/queryCdmaDeviceInfo/v2/queryCdmaDeviceInfoV2.xsd" xmlns:ns6="http://integration.sprint.com/interfaces/queryAccountDeviceList/v1/queryAccountDeviceList.xsd" xmlns:ns7="http://integration.sprint.com/interfaces/queryDeviceCapabilities/v2/queryDeviceCapabilitiesV2.xsd" xmlns:ns8="http://integration.sprint.com/interfaces/validateGiveBackDevice/v1/validateGiveBackDevice.xsd" xmlns:ns9="http://integration.sprint.com/interfaces/queryDeviceResourceInfo/v2/queryDeviceResourceInfoV2.xsd" xmlns:ns10="http://integration.sprint.com/interfaces/validateDevice/v7/validateDeviceV7.xsd" xmlns:ns11="http://integration.sprint.com/interfaces/queryDeviceList/v1/queryDeviceList.xsd" xmlns:ns13="http://integration.sprint.com/interfaces/queryDeviceHistoryByResource/v1/queryDeviceHistoryByResource.xsd" xmlns:ns14="http://integration.sprint.com/interfaces/querySubscriberDeviceList/v1/querySubscriberDeviceList.xsd" xmlns:ns15="http://integration.sprint.com/interfaces/queryDeviceCatalogInfo/v1/queryDeviceCatalogInfo.xsd" xmlns:ns16="http://integration.sprint.com/interfaces/validateDevice/v6/validateDeviceV6.xsd" xmlns:ns17="http://integration.sprint.com/interfaces/queryDeviceOrderHistory/v1/queryDeviceOrderHistory.xsd" xmlns:ns18="http://integration.sprint.com/interfaces/validateBuybackDevice/v1/validateBuybackDevice.xsd" xmlns:ns19="http://integration.sprint.com/interfaces/validateDevice/v9/validateDeviceV9.xsd" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns12="http://integration.sprint.com/interfaces/queryDeviceInfo/v1/queryDeviceInfo.xsd">
  33. <ns12:info>
  34. <ns12:equipmentId>089471386301077634</ns12:equipmentId>
  35. <ns12:checkPreviouslyActivated>true</ns12:checkPreviouslyActivated>
  36. <ns12:brandCode>BST</ns12:brandCode></ns12:info></ns12:queryDeviceInfo></data></ns1:queryDeviceInfoBtRequest>]
  37.  
  38.  
  39. 2016/11/09 07:29:18
  40. OutputQMgr/OutputQueue:[null/EKS.VALDVC]
  41. MQPutMessage:
  42. MQMD:[applicationOriginData= ,backoutCount=0,characterSet=819,correlationId=000000000000000000000000000000000000000000000000,encoding=273,expiry=500,messageId=414D5120454B53303141325420202020C54617580FB08F20,persistence=2,putApplicationName=java ,putDateTime=2016-10-9T12:29:18.510-GMT,replyToQueueManagerName= ,replyToQueueName=EKS.REPLY03 ,userId=eaiowner ]
  43. Data:[1VALDVCBT 3 10 00000_EKS EKS eksSystem 00000000 089471386301077634 BST]
  44.  
  45.  
  46. 2016/11/09 07:29:18
  47. MQGetMessage:
  48. MQMD:[applicationOriginData= ,backoutCount=0,characterSet=819,correlationId=414D5120454B53303141325420202020C54617580FB08F20,encoding=273,expiry=500,messageId=414D5120454B53303141325420202020C54617580FB08F20,persistence=0,putApplicationName=java ,putDateTime=2016-10-9T12:29:18.520-GMT,replyToQueueManagerName=EKS01A2T ,replyToQueueName=EKS.REPLY03 ,userId=eaiowner ]
  49. Data:[4VALDVCBT_R 3 10 00000 EKS eksSystem 00000000010 Device is valid and cleared for use APPLE, INC IPH 6 GRAY 16 BST BOX SGL CG885909950249 35544007107182U0 SUCCESS CO I ]
  50.  
  51.  
  52. 2016/11/09 07:29:18
  53. Select rtrim(id.item_id), trim(id.serial_type), trim(id.item_ldesc), trim(id.item_sdesc), trim(id.item_ldesc), trim(id.manf_cd), trim(id.network_ind), trim(id.used_eqp), trim(sii.pool), trim(sii.location_id), trim(sii.activity_code), to_char(sii.activity_date, 'mmddyyyy'), trim(sii.item_ownership),rtrim(sii.curr_possession), trim(sii.missing_ind), trim(sii.in_repair_ind), trim(sii.in_transit_ind), trim(sii.comited_to_pos_ind), trim(sii.software_ver),rtrim(sii.SERIAL_NUMBER),trim(item_id_type) FROM serial_item_inv sii, item_definition id WHERE sii.serial_number= ? AND sii.item_id = id.item_id
  54. {[0]089471386301077634}
  55. jdbc:eaidb:dbpool
  56. [ com.sprint.eai.queryDeviceinfo.dao.QueryDeviceInfoDao : getEquipmentDetails ]
  57. Elapsed time (ms) =1
  58.  
  59. 2016/11/09 07:29:18
  60. select TRIM(manf_cd), TRIM(item_ldesc), TRIM(item_id_type) from item_definition where item_id = rpad(:mdlNbr,15) AND ROWNUM < 2
  61. {[0]885909950249}
  62. jdbc:eaidb:dbpool
  63. [ com.sprint.eai.queryDeviceinfo.dao.QueryDeviceInfoDao : getManufacturerInfo ]
  64. Elapsed time (ms) =1
  65.  
  66. 2016/11/09 07:29:18
  67. SELECT ea.ATTR_CODE FROM EQUIPMENT_ATTR ea, ITEM_DEFINITION id WHERE id.ITEM_ID = ea.ITEM_ID AND id.ITEM_ID = rpad(?,15)
  68. {[0]885909950249}
  69. jdbc:eaidb:dbpool
  70. [ com.sprint.eai.queryDeviceinfo.dao.QueryDeviceInfoDao : getDeviceDetailInfo ]
  71. Elapsed time (ms) =1
  72.  
  73. 2016/11/09 07:29:18
  74. select case when count(*) > 0 THEN 'true' else 'false' end from EQP_RULE_LINK where item_id = RPAD(:item_id, 15) and group_id in('MF','MT','MC','MB','M4')
  75. {[0]885909950249}
  76. jdbc:eaidb:dbpool
  77. [ com.sprint.eai.queryDeviceinfo.dao.QueryDeviceInfoDao : getDeviceDetailInfo ]
  78. Elapsed time (ms) =0
  79.  
  80. 2016/11/09 07:29:18
  81. SELECT DISC_AMT from EQUIP_AGR_GEN_ATTR WHERE ATTR_CODE= 'DISCELG'
  82. {}
  83. jdbc:eaidb:dbpool
  84. [ com.sprint.eai.queryDeviceinfo.dao.QueryDeviceInfoDao : getDeviceDetailInfo ]
  85. Elapsed time (ms) =1
  86.  
  87. 2016/11/09 07:29:18
  88. select TRIM(MODEL_NME) from device_info where wrls_dev_sku_nbr = TRIM(:item_id)
  89. {[0]885909950249}
  90. jdbc:eaidb:dbpool
  91. [ com.sprint.eai.queryDeviceinfo.dao.QueryDeviceInfoDao : getMarketingName ]
  92. Elapsed time (ms) =1
  93.  
  94. 2016/11/09 07:29:18
  95. SELECT decode(sa.cross_fleet_ind, 'Y', 'true', 'N','false', 'false') , decode(sa.dc_ind, 'Y', 'true', 'N','false', 'false') , decode(sa.cell_ind, 'Y', 'true', 'N','false', 'false') , decode(sa.pds_ind, 'Y', 'true', 'N','false', 'false') , decode(sa.mms_ind, 'Y', 'true', 'N','false', 'false') , decode(sa.sdgc_ind, 'Y', 'true', 'N','false', 'false') , decode(sa.gprs_ind, 'Y', 'true', 'N','false', 'false') , decode(sa.ext800_ind, 'Y', 'true', 'N','false', 'false') , decode(sa.ptt_ind, 'Y', 'true', 'N','false', 'false') FROM software_attr sa WHERE sa.item_id=rpad(:itemId, 15) AND (:phoneSoftware is null or sa.software_ver = :phoneSoftware)
  96. {[0]885909950249,[1]null,[2]null}
  97. jdbc:eaidb:dbpool
  98. [ com.sprint.eai.queryDeviceinfo.dao.QueryDeviceInfoDao : getPhoneSoftwareInfo ]
  99. Elapsed time (ms) =0
  100.  
  101. 2016/11/09 07:29:18
  102. SELECT ea.ATTR_CODE FROM EQUIPMENT_ATTR ea, ITEM_DEFINITION id WHERE id.ITEM_ID = ea.ITEM_ID AND id.ITEM_ID = rpad(?,15)
  103. {[0]885909950249}
  104. jdbc:eaidb:dbpool
  105. [ com.sprint.eai.queryDeviceinfo.dao.QueryDeviceInfoDao : getEquipAttrCode ]
  106. Elapsed time (ms) =1
  107.  
  108. 2016/11/09 07:29:18
  109. OutputQMgr/OutputQueue:[null/EKS.REQDVCHIST]
  110. MQPutMessage:
  111. MQMD:[applicationOriginData= ,backoutCount=0,characterSet=819,correlationId=000000000000000000000000000000000000000000000000,encoding=273,expiry=500,messageId=414D5120454B53303141325420202020C546175810B08F20,persistence=2,putApplicationName=java ,putDateTime=2016-10-9T12:29:18.540-GMT,replyToQueueManagerName= ,replyToQueueName=EKS.REPLY03 ,userId=eaiowner ]
  112. Data:[1REQDVCHISTBT 3 2 00000_EKS EKS eksSystem 00000000 089471386301077634E1 ]
  113.  
  114.  
  115. 2016/11/09 07:29:18
  116. MQGetMessage:
  117. MQMD:[applicationOriginData= ,backoutCount=0,characterSet=819,correlationId=414D5120454B53303141325420202020C546175810B08F20,encoding=273,expiry=500,messageId=414D5120454B53303141325420202020C546175855AB8F20,persistence=0,putApplicationName=java ,putDateTime=2016-10-9T12:29:18.560-GMT,replyToQueueManagerName=EKS01A2T ,replyToQueueName=EKS.REPLY03 ,userId=eaiowner ]
  118. Data:[4REQDVCHISTBT_R 3 2 00000 EKS eksSystem 200000001NMS REQDVCHISTBT REQDVCHISTBT nms_exception 00000115Server.704:NMS returned status_code=38, status_text=DOES_NOT_EXIST_IN_DB: No records found in SubscriberLinkHistory]
  119.  
  120.  
  121. 2016/11/09 07:29:18
  122. Response:
  123. mqMessage:
  124. MQMD:[applicationOriginData= ,format=MQSTR ,backoutCount=0,characterSet=1208,correlationId=414D51204450303141325420202020205788160022E00ACA,encoding=273,expiry=500,messageId=,persistence=0,putApplicationName=WebSphere Datapower MQClient,putDateTime=null,replyToQueueManagerName=DP01A2T ,replyToQueueName=76S.REPLY16 ,userId=null]
  125. Data:[<?xml version="1.0" encoding="UTF-8"?>
  126. <quer:queryDeviceInfoBtResponse xmlns:quer="http://integration.sprint.com/integration/interfaces/queryDeviceInfoBtV1/v1/queryDeviceInfoBtV1" xmlns:quer1="http://integration.sprint.com/interfaces/queryDeviceInfo/v1/queryDeviceInfo.xsd">
  127. <ns3:mqMessageHeader xmlns:ns3="http://integration.sprint.com/public/interfaces/MQMessageHeaderV2.xsd">
  128. <ns3:messageHeaderVersion>2</ns3:messageHeaderVersion>
  129. <ns3:serviceName>queryDeviceInfoBt</ns3:serviceName>
  130. <ns3:serviceQualifier>76S</ns3:serviceQualifier>
  131. <ns3:serviceVersion>1</ns3:serviceVersion>
  132. <ns3:dialogTypeCode>2</ns3:dialogTypeCode>
  133. <ns3:dialogSubTypeCode>4</ns3:dialogSubTypeCode>
  134. <ns3:parentDialogReference>7V2-CONVID-aab02e21</ns3:parentDialogReference>
  135. <ns3:dialogReference>7V2-MSGID-SP-aab02e21</ns3:dialogReference>
  136. <ns3:applicationReference>7V2</ns3:applicationReference>
  137. <ns3:applicationGroup>7V2</ns3:applicationGroup>
  138. <ns3:componentGroup>Equipment</ns3:componentGroup>
  139. <ns3:componentName>queryDeviceInfoBt</ns3:componentName>
  140. <ns3:reqSentDateTime>2016-11-09T07:29:18.003-05:00</ns3:reqSentDateTime>
  141. <ns3:applicationUserId>7V2</ns3:applicationUserId>
  142. <ns3:replyCompletionCode>0</ns3:replyCompletionCode>
  143. </ns3:mqMessageHeader>
  144. <quer:data>
  145. <quer1:queryDeviceInfoResponse>
  146. <quer1:equipmentInfo>
  147. <quer1:equipmentId>089471386301077634</quer1:equipmentId>
  148. <quer1:itemId>885909950249</quer1:itemId>
  149. <quer1:serialType>E</quer1:serialType>
  150. <quer1:esn>089471386301077634</quer1:esn>
  151. <quer1:esnHex>35544007107182</quer1:esnHex>
  152. <quer1:description>IPH 6 GRAY 16 BST BOX SGL</quer1:description>
  153. <quer1:manufacturer>436</quer1:manufacturer>
  154. <quer1:modelNumber>885909950249</quer1:modelNumber>
  155. <quer1:phoneModel>IPH 6 GRAY 16 BST BOX SGL</quer1:phoneModel>
  156. <quer1:possession>A</quer1:possession>
  157. <quer1:negativeInd>false</quer1:negativeInd>
  158. <quer1:cellInd>true</quer1:cellInd>
  159. <quer1:pdsInd>true</quer1:pdsInd>
  160. <quer1:pttInd>false</quer1:pttInd>
  161. <quer1:networkInd>C</quer1:networkInd>
  162. <quer1:pamInd>true</quer1:pamInd>
  163. <quer1:hppttInd>false</quer1:hppttInd>
  164. <quer1:evdoInd>true</quer1:evdoInd>
  165. <quer1:abGlmsInd>false</quer1:abGlmsInd>
  166. <quer1:previouslyActivated>N</quer1:previouslyActivated>
  167. <quer1:equipmentStatus>D</quer1:equipmentStatus>
  168. <quer1:inputSerialType>E</quer1:inputSerialType>
  169. <quer1:wiMaxInd>false</quer1:wiMaxInd>
  170. <quer1:lteInd>true</quer1:lteInd>
  171. <quer1:lteUiccType>U</quer1:lteUiccType>
  172. <quer1:iccId/>
  173. <quer1:uiccStatus/>
  174. <quer1:isBroadband2GoInd>false</quer1:isBroadband2GoInd>
  175. <quer1:isBlackberryDeviceInd>false</quer1:isBlackberryDeviceInd>
  176. <quer1:isDeviceInsuranceEligibleInd>Y</quer1:isDeviceInsuranceEligibleInd>
  177. <quer1:isAppleInsuranceApplicableInd>N</quer1:isAppleInsuranceApplicableInd>
  178. <quer1:isDeviceMRCDiscountEligibleInd>true</quer1:isDeviceMRCDiscountEligibleInd>
  179. <quer1:mrcDiscountAmount>5</quer1:mrcDiscountAmount>
  180. <quer1:marketingName>Boost iPhone 6 16GB</quer1:marketingName>
  181. </quer1:equipmentInfo>
  182. </quer1:queryDeviceInfoResponse>
  183. </quer:data>
  184. </quer:queryDeviceInfoBtResponse>]
  185. .
  186. ..
  187. ...
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!