Solved

MySQL Tables Structure

  • 27 November 2023
  • 3 replies
  • 115 views
V
Badge +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. 

icon

Best answer by rchauvel 27 November 2023, 08:42

View original

3 replies

rchauvel
Rank
Userlevel 5
Badge +17

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
Badge +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
Rank
Userlevel 5
Badge +17

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

Reply


Terms & ConditionsCookie settings