Skip to main content

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

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.

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


Terms & ConditionsCookie settings