API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Apr 28th, 2017
63
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 17.13 KB | None | 0 0
raw download clone embed print report
  1. /* Formatted on 4.28.2017 11:25:52 (QP5 v5.115.810.9015) */
  2. SELECT 'Broadband' AS "Domain",
  3. 'Açik Problem Sayisi' AS "Kategori",
  4. COUNT ( * ) AS "Adet"
  5. FROM SMKONS.ROOTCAUSEM1 r1
  6. WHERE LOWER (r1.ASSIGNMENT) IN
  7. ('crm operasyon',
  8. 'css',
  9. 'crm gelir güvencesi',
  10. 'data operasyon',
  11. 'crm konfigürasyon',
  12. 'bas')
  13. AND r1.RCSTATUS NOT IN ('Closed', 'Abandoned')
  14. UNION ALL
  15. SELECT 'Broadband',
  16. 'Açilan Problem Sayisi' AS "Kategori",
  17. COUNT ( * ) AS "Adet"
  18. FROM SMKONS.ROOTCAUSEM1 r1
  19. WHERE LOWER (r1.ASSIGNMENT) IN
  20. ('crm operasyon',
  21. 'css',
  22. 'crm gelir güvencesi',
  23. 'data operasyon',
  24. 'crm konfigürasyon',
  25. 'bas')
  26. AND open_time > SYSDATE - 30
  27. UNION ALL
  28. SELECT 'Broadband',
  29. 'Kapatilan Problem Sayisi' AS "Kategori",
  30. COUNT ( * ) AS "Adet"
  31. FROM SMKONS.ROOTCAUSEM1 r1
  32. WHERE LOWER (r1.ASSIGNMENT) IN
  33. ('crm operasyon',
  34. 'css',
  35. 'crm gelir güvencesi',
  36. 'data operasyon',
  37. 'crm konfigürasyon',
  38. 'bas')
  39. AND tt_pm_close_time > SYSDATE - 30
  40. UNION ALL
  41. SELECT 'Broadband', 'Açik IM Sayisi', COUNT ( * )
  42. FROM smkons.probsummarym1
  43. WHERE LOWER (ASSIGNMENT) IN
  44. ('crm operasyon',
  45. 'css',
  46. 'crm gelir güvencesi',
  47. 'data operasyon',
  48. 'crm konfigürasyon',
  49. 'bas')
  50. AND INCIDENT_ID IN (SELECT INCIDENT_ID
  51. FROM SMKONS.INCIDENTSM1
  52. WHERE OPEN NOT IN ('Resolved', 'Closed'))
  53. UNION ALL
  54. SELECT 'Broadband', 'Açilan IM Sayisi', COUNT ( * )
  55. FROM smkons.probsummarym1
  56. WHERE LOWER (ASSIGNMENT) IN
  57. ('crm operasyon',
  58. 'css',
  59. 'crm gelir güvencesi',
  60. 'data operasyon',
  61. 'crm konfigürasyon',
  62. 'bas')
  63. AND open_time > SYSDATE - 30
  64. UNION ALL
  65. SELECT 'Broadband', 'Kapatilan IM Sayisi', COUNT ( * )
  66. FROM smkons.probsummarym1
  67. WHERE LOWER (ASSIGNMENT) IN
  68. ('crm operasyon',
  69. 'css',
  70. 'crm gelir güvencesi',
  71. 'data operasyon',
  72. 'crm konfigürasyon',
  73. 'bas')
  74. AND close_time > SYSDATE - 30
  75. UNION ALL
  76. SELECT 'Broadband', 'PM Bagli Açik Im Sayisi', COUNT (DISTINCT source)
  77. FROM smkons.screlationm1
  78. WHERE depend IN
  79. (SELECT ID
  80. FROM SMKONS.ROOTCAUSEM1 r1
  81. WHERE LOWER (r1.ASSIGNMENT) IN
  82. ('crm operasyon',
  83. 'css',
  84. 'crm gelir güvencesi',
  85. 'data operasyon',
  86. 'crm konfigürasyon',
  87. 'bas')
  88. AND r1.RCSTATUS NOT IN ('Closed', 'Abandoned'))
  89. AND source IN
  90. (SELECT "NUMBER"
  91. FROM smkons.probsummarym1
  92. WHERE INCIDENT_ID IN
  93. (SELECT INCIDENT_ID
  94. FROM SMKONS.INCIDENTSM1
  95. WHERE OPEN NOT IN
  96. ('Resolved', 'Closed')))
  97. UNION ALL
  98. SELECT 'Broadband', 'PM Bagli Açilan Im Sayisi', COUNT (DISTINCT source)
  99. FROM smkons.screlationm1
  100. WHERE depend IN
  101. (SELECT ID
  102. FROM SMKONS.ROOTCAUSEM1 r1
  103. WHERE LOWER (r1.ASSIGNMENT) IN
  104. ('crm operasyon',
  105. 'css',
  106. 'crm gelir güvencesi',
  107. 'data operasyon',
  108. 'crm konfigürasyon',
  109. 'bas')
  110. AND r1.RCSTATUS NOT IN ('Closed', 'Abandoned'))
  111. AND source IN (SELECT "NUMBER"
  112. FROM smkons.probsummarym1
  113. WHERE open_time > SYSDATE - 30)
  114. UNION ALL
  115. SELECT 'Broadband', 'PM Bagli Kapatilan Im Sayisi', COUNT (DISTINCT source)
  116. FROM smkons.screlationm1
  117. WHERE depend IN
  118. (SELECT ID
  119. FROM SMKONS.ROOTCAUSEM1 r1
  120. WHERE LOWER (r1.ASSIGNMENT) IN
  121. ('crm operasyon',
  122. 'css',
  123. 'crm gelir güvencesi',
  124. 'data operasyon',
  125. 'crm konfigürasyon',
  126. 'bas')
  127. AND r1.RCSTATUS NOT IN ('Closed', 'Abandoned'))
  128. AND source IN (SELECT "NUMBER"
  129. FROM smkons.probsummarym1
  130. WHERE close_time > SYSDATE - 30)
  131. UNION ALL
  132. SELECT 'Fixed' AS "Domain",
  133. 'Açik Problem Sayisi' AS "Kategori",
  134. COUNT ( * ) AS "Adet"
  135. FROM SMKONS.ROOTCAUSEM1 r1
  136. WHERE (r1.ASSIGNMENT) IN
  137. ('SOM Uygulama',
  138. 'TMS Destek PM',
  139. 'Mobil OHM Destek PM',
  140. 'Kurumsal OHM Destek PM',
  141. 'Bireysel OHM PM',
  142. 'ARECA-PCOM',
  143. 'ATS EOE',
  144. 'BGW EOE',
  145. 'CEBILL EOE',
  146. 'DASETS EOE',
  147. 'DHS EOE',
  148. 'FLEXIBILL EOE',
  149. 'FMS EOE',
  150. 'SMARTBILL EOE',
  151. 'TMS EOE',
  152. 'TTO EOE',
  153. 'TTS EOE',
  154. 'xDSL EOE',
  155. 'Olo Portal Destek PM',
  156. 'Dasets Destek PM',
  157. 'XDSL Destek PM',
  158. 'TTVM Portal Destek PM',
  159. 'KMZP Destek PM',
  160. 'Telaura Uygulama',
  161. 'OCSP Destek PM',
  162. 'CW Uygulama',
  163. 'aTTIP Uygulama',
  164. 'Siebel Uygulama')
  165. AND r1.RCSTATUS NOT IN ('Closed', 'Abandoned')
  166. UNION ALL
  167. SELECT 'Fixed',
  168. 'Açilan Problem Sayisi' AS "Kategori",
  169. COUNT ( * ) AS "Adet"
  170. FROM SMKONS.ROOTCAUSEM1 r1
  171. WHERE (r1.ASSIGNMENT) IN
  172. ('SOM Uygulama',
  173. 'TMS Destek PM',
  174. 'Mobil OHM Destek PM',
  175. 'Kurumsal OHM Destek PM',
  176. 'Bireysel OHM PM',
  177. 'ARECA-PCOM',
  178. 'ATS EOE',
  179. 'BGW EOE',
  180. 'CEBILL EOE',
  181. 'DASETS EOE',
  182. 'DHS EOE',
  183. 'FLEXIBILL EOE',
  184. 'FMS EOE',
  185. 'SMARTBILL EOE',
  186. 'TMS EOE',
  187. 'TTO EOE',
  188. 'TTS EOE',
  189. 'xDSL EOE',
  190. 'Olo Portal Destek PM',
  191. 'Dasets Destek PM',
  192. 'XDSL Destek PM',
  193. 'TTVM Portal Destek PM',
  194. 'KMZP Destek PM',
  195. 'Telaura Uygulama',
  196. 'OCSP Destek PM',
  197. 'CW Uygulama',
  198. 'aTTIP Uygulama',
  199. 'Siebel Uygulama')
  200. AND open_time > SYSDATE - 30
  201. UNION ALL
  202. SELECT 'Fixed',
  203. 'Kapatilan Problem Sayisi' AS "Kategori",
  204. COUNT ( * ) AS "Adet"
  205. FROM SMKONS.ROOTCAUSEM1 r1
  206. WHERE (r1.ASSIGNMENT) IN
  207. ('SOM Uygulama',
  208. 'TMS Destek PM',
  209. 'Mobil OHM Destek PM',
  210. 'Kurumsal OHM Destek PM',
  211. 'Bireysel OHM PM',
  212. 'ARECA-PCOM',
  213. 'ATS EOE',
  214. 'BGW EOE',
  215. 'CEBILL EOE',
  216. 'DASETS EOE',
  217. 'DHS EOE',
  218. 'FLEXIBILL EOE',
  219. 'FMS EOE',
  220. 'SMARTBILL EOE',
  221. 'TMS EOE',
  222. 'TTO EOE',
  223. 'TTS EOE',
  224. 'xDSL EOE',
  225. 'Olo Portal Destek PM',
  226. 'Dasets Destek PM',
  227. 'XDSL Destek PM',
  228. 'TTVM Portal Destek PM',
  229. 'KMZP Destek PM',
  230. 'Telaura Uygulama',
  231. 'OCSP Destek PM',
  232. 'CW Uygulama',
  233. 'aTTIP Uygulama',
  234. 'Siebel Uygulama')
  235. AND tt_pm_close_time > SYSDATE - 30
  236. UNION ALL
  237. SELECT 'Fixed', 'Açik IM Sayisi', COUNT ( * )
  238. FROM smkons.probsummarym1
  239. WHERE (ASSIGNMENT) IN
  240. ('SOM Uygulama',
  241. 'TMS Destek PM',
  242. 'Mobil OHM Destek PM',
  243. 'Kurumsal OHM Destek PM',
  244. 'Bireysel OHM PM',
  245. 'ARECA-PCOM',
  246. 'ATS EOE',
  247. 'BGW EOE',
  248. 'CEBILL EOE',
  249. 'DASETS EOE',
  250. 'DHS EOE',
  251. 'FLEXIBILL EOE',
  252. 'FMS EOE',
  253. 'SMARTBILL EOE',
  254. 'TMS EOE',
  255. 'TTO EOE',
  256. 'TTS EOE',
  257. 'xDSL EOE',
  258. 'Olo Portal Destek PM',
  259. 'Dasets Destek PM',
  260. 'XDSL Destek PM',
  261. 'TTVM Portal Destek PM',
  262. 'KMZP Destek PM',
  263. 'Telaura Uygulama',
  264. 'OCSP Destek PM',
  265. 'CW Uygulama',
  266. 'aTTIP Uygulama',
  267. 'Siebel Uygulama')
  268. AND INCIDENT_ID IN (SELECT INCIDENT_ID
  269. FROM SMKONS.INCIDENTSM1
  270. WHERE OPEN NOT IN ('Resolved', 'Closed'))
  271. UNION ALL
  272. SELECT 'Fixed', 'Açilan IM Sayisi', COUNT ( * )
  273. FROM smkons.probsummarym1
  274. WHERE (ASSIGNMENT) IN
  275. ('SOM Uygulama',
  276. 'TMS Destek PM',
  277. 'Mobil OHM Destek PM',
  278. 'Kurumsal OHM Destek PM',
  279. 'Bireysel OHM PM',
  280. 'ARECA-PCOM',
  281. 'ATS EOE',
  282. 'BGW EOE',
  283. 'CEBILL EOE',
  284. 'DASETS EOE',
  285. 'DHS EOE',
  286. 'FLEXIBILL EOE',
  287. 'FMS EOE',
  288. 'SMARTBILL EOE',
  289. 'TMS EOE',
  290. 'TTO EOE',
  291. 'TTS EOE',
  292. 'xDSL EOE',
  293. 'Olo Portal Destek PM',
  294. 'Dasets Destek PM',
  295. 'XDSL Destek PM',
  296. 'TTVM Portal Destek PM',
  297. 'KMZP Destek PM',
  298. 'Telaura Uygulama',
  299. 'OCSP Destek PM',
  300. 'CW Uygulama',
  301. 'aTTIP Uygulama',
  302. 'Siebel Uygulama')
  303. AND open_time > SYSDATE - 30
  304. UNION ALL
  305. SELECT 'Fixed', 'Kapatilan IM Sayisi', COUNT ( * )
  306. FROM smkons.probsummarym1
  307. WHERE (ASSIGNMENT) IN
  308. ('SOM Uygulama',
  309. 'TMS Destek PM',
  310. 'Mobil OHM Destek PM',
  311. 'Kurumsal OHM Destek PM',
  312. 'Bireysel OHM PM',
  313. 'ARECA-PCOM',
  314. 'ATS EOE',
  315. 'BGW EOE',
  316. 'CEBILL EOE',
  317. 'DASETS EOE',
  318. 'DHS EOE',
  319. 'FLEXIBILL EOE',
  320. 'FMS EOE',
  321. 'SMARTBILL EOE',
  322. 'TMS EOE',
  323. 'TTO EOE',
  324. 'TTS EOE',
  325. 'xDSL EOE',
  326. 'Olo Portal Destek PM',
  327. 'Dasets Destek PM',
  328. 'XDSL Destek PM',
  329. 'TTVM Portal Destek PM',
  330. 'KMZP Destek PM',
  331. 'Telaura Uygulama',
  332. 'OCSP Destek PM',
  333. 'CW Uygulama',
  334. 'aTTIP Uygulama',
  335. 'Siebel Uygulama')
  336. AND close_time > SYSDATE - 30
  337. UNION ALL
  338. SELECT 'Fixed', 'PM Bagli Açik Im Sayisi', COUNT (DISTINCT source)
  339. FROM smkons.screlationm1
  340. WHERE depend IN
  341. (SELECT ID
  342. FROM SMKONS.ROOTCAUSEM1 r1
  343. WHERE (r1.ASSIGNMENT) IN
  344. ('SOM Uygulama',
  345. 'TMS Destek PM',
  346. 'Mobil OHM Destek PM',
  347. 'Kurumsal OHM Destek PM',
  348. 'Bireysel OHM PM',
  349. 'ARECA-PCOM',
  350. 'ATS EOE',
  351. 'BGW EOE',
  352. 'CEBILL EOE',
  353. 'DASETS EOE',
  354. 'DHS EOE',
  355. 'FLEXIBILL EOE',
  356. 'FMS EOE',
  357. 'SMARTBILL EOE',
  358. 'TMS EOE',
  359. 'TTO EOE',
  360. 'TTS EOE',
  361. 'xDSL EOE',
  362. 'Olo Portal Destek PM',
  363. 'Dasets Destek PM',
  364. 'XDSL Destek PM',
  365. 'TTVM Portal Destek PM',
  366. 'KMZP Destek PM',
  367. 'Telaura Uygulama',
  368. 'OCSP Destek PM',
  369. 'CW Uygulama',
  370. 'aTTIP Uygulama',
  371. 'Siebel Uygulama')
  372. AND r1.RCSTATUS NOT IN ('Closed', 'Abandoned'))
  373. AND source IN
  374. (SELECT "NUMBER"
  375. FROM smkons.probsummarym1
  376. WHERE INCIDENT_ID IN
  377. (SELECT INCIDENT_ID
  378. FROM SMKONS.INCIDENTSM1
  379. WHERE OPEN NOT IN
  380. ('Resolved', 'Closed')))
  381. UNION ALL
  382. SELECT 'Fixed', 'PM Bagli Açilan Im Sayisi', COUNT (DISTINCT source)
  383. FROM smkons.screlationm1
  384. WHERE depend IN
  385. (SELECT ID
  386. FROM SMKONS.ROOTCAUSEM1 r1
  387. WHERE (r1.ASSIGNMENT) IN
  388. ('SOM Uygulama',
  389. 'TMS Destek PM',
  390. 'Mobil OHM Destek PM',
  391. 'Kurumsal OHM Destek PM',
  392. 'Bireysel OHM PM',
  393. 'ARECA-PCOM',
  394. 'ATS EOE',
  395. 'BGW EOE',
  396. 'CEBILL EOE',
  397. 'DASETS EOE',
  398. 'DHS EOE',
  399. 'FLEXIBILL EOE',
  400. 'FMS EOE',
  401. 'SMARTBILL EOE',
  402. 'TMS EOE',
  403. 'TTO EOE',
  404. 'TTS EOE',
  405. 'xDSL EOE',
  406. 'Olo Portal Destek PM',
  407. 'Dasets Destek PM',
  408. 'XDSL Destek PM',
  409. 'TTVM Portal Destek PM',
  410. 'KMZP Destek PM',
  411. 'Telaura Uygulama',
  412. 'OCSP Destek PM',
  413. 'CW Uygulama',
  414. 'aTTIP Uygulama',
  415. 'Siebel Uygulama')
  416. AND r1.RCSTATUS NOT IN ('Closed', 'Abandoned'))
  417. AND source IN (SELECT "NUMBER"
  418. FROM smkons.probsummarym1
  419. WHERE open_time > SYSDATE - 30)
  420. UNION ALL
  421. SELECT 'Fixed', 'PM Bagli Kapatilan Im Sayisi', COUNT (DISTINCT source)
  422. FROM smkons.screlationm1
  423. WHERE depend IN
  424. (SELECT ID
  425. FROM SMKONS.ROOTCAUSEM1 r1
  426. WHERE (r1.ASSIGNMENT) IN
  427. ('SOM Uygulama',
  428. 'TMS Destek PM',
  429. 'Mobil OHM Destek PM',
  430. 'Kurumsal OHM Destek PM',
  431. 'Bireysel OHM PM',
  432. 'ARECA-PCOM',
  433. 'ATS EOE',
  434. 'BGW EOE',
  435. 'CEBILL EOE',
  436. 'DASETS EOE',
  437. 'DHS EOE',
  438. 'FLEXIBILL EOE',
  439. 'FMS EOE',
  440. 'SMARTBILL EOE',
  441. 'TMS EOE',
  442. 'TTO EOE',
  443. 'TTS EOE',
  444. 'xDSL EOE',
  445. 'Olo Portal Destek PM',
  446. 'Dasets Destek PM',
  447. 'XDSL Destek PM',
  448. 'TTVM Portal Destek PM',
  449. 'KMZP Destek PM',
  450. 'Telaura Uygulama',
  451. 'OCSP Destek PM',
  452. 'CW Uygulama',
  453. 'aTTIP Uygulama',
  454. 'Siebel Uygulama')
  455. AND r1.RCSTATUS NOT IN ('Closed', 'Abandoned'))
  456. AND source IN (SELECT "NUMBER"
  457. FROM smkons.probsummarym1
  458. WHERE close_time > SYSDATE - 30)
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!