Sorry, but you have the wrong mailing list. This mailing list is for Prometheus.
Questions about Grafana should be addressed to the Grafana community: https://community.grafana.com/ (especially when the question is about Grafana talking to a database other than Prometheus) On Thursday, 13 July 2023 at 11:11:49 UTC+1 Pratik Gujar 2 wrote: > 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/e30c81b2-226b-4123-b562-f8995c28a7c8n%40googlegroups.com.
