# Logstash input jdbc

**URL:** <https://discuss.elastic.co/t/logstash-input-jdbc/372240>\
**Category:** Discussions en français\
**Created:** [December 19, 2024, 5:19pm UTC](https://discuss.elastic.co/t/logstash-input-jdbc/372240 "2024-12-19T17:19:12Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![mamadou\_yassaou\_bah](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mamadou_yassaou_bah/32/136168_2.png) [@mamadou\_yassaou\_bah](https://discuss.elastic.co/u/mamadou_yassaou_bah)\
**Post date:** [December 19, 2024, 5:19pm UTC](https://discuss.elastic.co/t/logstash-input-jdbc/372240/1 "2024-12-19T17:19:12Z")

</div>

bonjour j'ai besoin d'aide sur logstash input jdbc  
je voudrais savoir comment je pourrai faire un select de tel sorte que si c'est le 1 2 3 du mois du date systeme il charge les données du mois precedent et a partir 4 du mois il charge les donnes de ce mois

```auto
` jdbc {
    jdbc_driver_library => "..."
    jdbc_driver_class => "..."
    jdbc_connection_string => "..."
    jdbc_user => "..."
    jdbc_password => "..."
    schedule => "*/10 * * * *" # Chaque 10 minutes
    statement => "
        SELECT count(*) Nombre, filename, calldate, 'VOI' SERVICE
        FROM BD_INTERCO.interco_202411 i2
        WHERE calldate <= CURDATE()
          AND calldate > DATE_SUB(CURDATE(), INTERVAL 27 DAY)
        GROUP BY filename, calldate
        UNION
        SELECT count(*) Nombre, filename, calldate, 'SMS' SERVICE
        FROM BD_INTERCO.SMSINTERCO_202411 s2
        WHERE calldate <= CURDATE()
          AND calldate > DATE_SUB(CURDATE(), INTERVAL 27 DAY)
        GROUP BY filename, calldate
    "
    tags => ["binterco_file"]
}
`

```

et la ou j'ai mit les ... se sont des informations sensible comme explique si haut c'est le select que j'arrive pas a changer

---

<div class="post-metadata">

**Author:** ![mamadou\_yassaou\_bah](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mamadou_yassaou_bah/32/136168_2.png) [@mamadou\_yassaou\_bah](https://discuss.elastic.co/u/mamadou_yassaou_bah)\
**Post date:** [December 23, 2024, 9:28am UTC](https://discuss.elastic.co/t/logstash-input-jdbc/372240/2 "2024-12-23T09:28:47Z")

</div>

besoin d'aide  
please ???