Skip to main content
Solved

MYSQL Query

  • March 27, 2023
  • 2 replies
  • 71 views
C
Forum|alt.badge.img+8

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

Best answer by tkmeisterooo

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.

    2 replies

    T
    Forum|alt.badge.img+6
    • tkmeisterooo
    • Steward **
    • Answer
    • March 27, 2023

    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.

    C
    C
    Forum|alt.badge.img+8
    • carnabil
    • Author
    • Steward ***
    • March 27, 2023

    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.

    Terms & ConditionsCookie settingsAccessibility statement