Skip to main content
Solved

MySQL Tables Structure

  • November 27, 2023
  • 3 replies
  • 272 views
V
Forum|alt.badge.img+1

Hi Team, Good Day. 

One of our clients use MySQL database for storing Centreon related data. We tried to get exact tables where Centreon monitoring data like CPU, Memory, Disk space of host servers are stored into MySQL database but not found any clues. Can anyone please share the links / documentation having these useful tables information? Thank you. 

Best answer by rchauvel

Hello, not sure what you are trying to achieve here but be aware that directly accessing or modifying data in the database is not a recommended integration. I advise you rather look at the REST API that allows you to retrieve configuration information (e.g. hosts) and monitoring metrics.

    3 replies

    rchauvel
    Centreonian
    Forum|alt.badge.img+18
    • rchauvel
    • Centreonian
    • Answer
    • November 27, 2023

    Hello, not sure what you are trying to achieve here but be aware that directly accessing or modifying data in the database is not a recommended integration. I advise you rather look at the REST API that allows you to retrieve configuration information (e.g. hosts) and monitoring metrics.

    V
    Forum|alt.badge.img+1

    Thanks Chauvel for the quick response. From the apis given in your answer, can we get data like CPU, Memory, disk space of hosts for past few days? Or please share any apis links / documentation which give this data… 

    rchauvel
    Centreonian
    Forum|alt.badge.img+18
    • rchauvel
    • Centreonian
    • November 27, 2023

    Yes, the metrics API endpoints can retrieve data points between a start date and an end date either in JSON or in CSV.

    V
    Terms & ConditionsCookie settingsAccessibility statement