SUM_STAT status other than (R,T,F) monitoring on Grafana

[Pratik Gujar 2]

                              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'

[Brian Candler]

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)

[Pratik Gujar 2]

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.