SUM_STAT status other than (R,T,F)
We are checking the SUM_STAT for every billing cycle and status should not be other than (R,T,F). Below query to execute and check the status as per Billing cycle date Can you please help me with step by step procedure and which tool should be install excluding Prometheus/grafana like (PDI, oracle db exporter)?? DB- oracle Application: xyz Query run in: Database Data base name: GBSNPRD Host name: abc IP: xx.xx.xxx.xxx Query: SELECT DISTINCT CS.SUM_STAT FROM sebs.INVCE_DCLAR_PRIOD I, sebs.CDRV_SUM CS WHERE I.INVCE_PRIOD_NO = CS.INVCE_PRIOD_NO AND CS.MOD_INVCE_PRIOD_NO = MOD(I.INVCE_PRIOD_NO,400) and TRUNC(I.INVCE_PRIOD_START_DT) >= '01-JUL-2022' AND TRUNC(I.INVCE_PRIOD_END_DT) = '31-JUL-2022' --Billing cycle date --Billing cycle date INVCE_PRIOD_START_DT and INVCE_PRIOD_END_DT -- TRUNC(I.INVCE_PRIOD_START_DT) >='01-MMM-YYYY' AND TRUNC(I.INVCE_PRIOD_END_DT) = '07- MMM-YYYY' -- TRUNC(I.INVCE_PRIOD_START_DT) >='08- MMM-YYYY' AND TRUNC(I.INVCE_PRIOD_END_DT) = '14- MMM-YYYY' -- TRUNC(I.INVCE_PRIOD_START_DT) >='15- MMM-YYYY' AND TRUNC(I.INVCE_PRIOD_END_DT) = '21- MMM-YYYY' -- TRUNC(I.INVCE_PRIOD_START_DT) >='01- MMM-YYYY' AND TRUNC(I.INVCE_PRIOD_END_DT) = '15- MMM-YYYY' -- TRUNC(I.INVCE_PRIOD_START_DT) >='01- MMM-YYYY' AND TRUNC(I.INVCE_PRIOD_END_DT) = '31- MMM-YYYY' -- You received this message because you are subscribed to the Google Groups "Prometheus Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/prometheus-users/431e362c-1bb2-452e-9767-729e502a660dn%40googlegroups.com.
