Solved

MYSQL Query

  • 27 March 2023
  • 2 replies
  • 39 views

Badge +7

Hello, I am preparing a MYSQL query that returns all the alerts that are in the acknowledged state. The problem is that I don't see the way to also obtain the comment that each one of them has.

 

Any ideas?

 

Thanks

icon

Best answer by tkmeisterooo 27 March 2023, 16:22

View original

2 replies

Badge +3

Hi,
I dont know how your query looks like but i think that You have to join centreon_storage.acknowledgements table which have comment_data field.

Badge +7

Hi,

Yes, that was what I thought. I have detected that the problem is that the records are not being deleted from the table and there are thousands of Acknowledgments. For some reason they were saved as persistent_comment true and many others without deletion_time.

I understand that this table should only be those that are active.

Thanks for the help.

Reply