Dynamic Lookup Tables and Compare Timestamps with each other to create a notification

Hello everyone,

does anyone have an idea how I can implement the following:

I receive start and end dates of a downtime from a log file in the following format: “2024-07-09 12:59:28”. I need to write these into a “Dynamic Lookup Table”. Then, I need to compare the downtimes or intervals with an event that has a timestamp. If the event’s timestamp falls within the interval, nothing should happen, but if it falls outside the interval, a notification should be sent out. Could someone please help me with this problem? I’ve been stuck on it for a while and don’t know exactly how to implement it. Like in the pipeline, which Function do I have to use and how would the data Adapter or Cache look a like ? I would appreciate it so much, if someone of you could help me. Thanks in Advance.

2. Describe your environment:

  • OS Information:
    Windows, I have the Security License
  • Package Version:
    Graylog 6.0.3
  • Service logs, configurations, and environment variables: