Hi, Yes you are right, but I am doing this configuration using Prometheus. As I studied, Oracle is enterprise DB, and can not connect directly on Grafana. That's why I want information that is there any configuration in Prometheus so we can visualize it on Grafana?
My question is for both the service. On Thursday, July 13, 2023 at 4:20:34 PM UTC+5:30 Brian Candler wrote: > 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/f23bf856-4098-4b6e-8be7-c6c12c32a7d9n%40googlegroups.com.
