Skip to main content
Solved

MYSQL Query

  • Mar 27, 2023 12:13 PM UTC
  • 2 replies
  • 91 views
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.

View original

    2 replies

    Forum|alt.badge.img+6
    • tkmeisterooo
    • Steward ***
    • Answer
    • Mar 27, 2023 2:22 PM UTC

    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.

      Forum|alt.badge.img+8
      • carnabil
      • Author
      • Builder *
      • Mar 27, 2023 3:09 PM UTC

      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 & ConditionsAccessibility statement