Derdack

Targeted Alert Notifications – Anywhere Actions

Derdack
  • Use Cases
    • Overview
    • Enterprise IT Alerting
    • IT Managed Services
    • Mobile Alerting in Manufacuring
    • Critical Operations Alerting in Banking & Financial
    • Field Service Dispatching in Energy & Utilities
    • Use Cases in other Industries
  • Products
    • Overview
    • Enterprise Alert®
      • Overview
      • Alert Notifications
      • On-call Duty Scheduling
      • Collaboration
      • Anywhere Remediation
      • Incident Mgmt. App
      • Integrations
      • Technical Support
      • Online Knowledge Base
      • Derdack FAQ
    • SIGNL4® Cloud
    • References & More
  • How to Buy
    • Overview
    • Pricing and Quotes
    • Azure Marketplace
  • About Derdack
    • About
    • Careers
    • Strategic Partners
    • Derdack Podcast
    • Contact Derdack
  • News & Blog
  • Request Demo
    • de de
  • News & Blog

    • Home
    • News & Blog
    • Customers
    • Tips & Tricks: Keeping Track of Event-Processing Delays

    Tips & Tricks: Keeping Track of Event-Processing Delays

    • December 23, 2021
    • CustomersIT OpsTechnical
    Tips & Tricks: Keeping Track of Event-Processing Delays

    What happened?

    A couple of weeks ago our partner Rok Ponikvar from S&T contacted me about an issue one of his customers faced. His customer complained that Enterprise Alert is not alerting on current issues and even if he creates a test ticket in his OBM system no alert goes out. After a little back and forth we concluded that Enterprise Alert is still processing historic data from an Event Storm in OBM earlier that day. The situation resolved itself rather quickly so the impact on the customer was not too severe.

    What is the technical background?

    Enterprise Alert will, for the protection of its own and of the 3rd party systems operations, only poll a certain amount of Events in a given interval for example 500 events or tickets every 30 seconds. If there are more than 500 events or tickets created, let’s say 750, within these 30 seconds Enterprise Alert will only poll the 500 oldest will be polled and the rest, in this theoretical case 250, will remain for the next cycle. As you can imagine this can cause quite a backlog to build up over time.
    Enterprise Alert will work through that backlog and catch up to the current data as soon as the 3rd party system generates fewer events or tickets than being polled from Enterprise Alert.

    What was the solution?

    In further discussion, Rok asked if there was a way to monitor the system for a delay. I pointed him to the ModuleServiceProperties table as most of our modern smart connectors store polling information there in order to have a starting timestamp upon service restart and to provide sync data for High Availability setups. Rok then went ahead and wrote a query to monitor his system for any desynchronization between Enterprise Alert and his OBM system. He kindly shared this query with me so everyone can benefit. Shoutout to Rok Ponikvar for this. Thanks a lot. 😊

    DECLARE @lastevent datetime
    DECLARE @obmsynctime datetime
    SELECT @obmsynctime= [Value]  FROM [<your_database_name>].[dbo].[ModuleServiceProperties]   WHERE [Name] = 'LastTimestamp' and [ModuleServiceID]= '<your_Service_ID>'
    SELECT TOP (1) @lastevent =  [Timestamp]  FROM [<your_database_name>].[dbo].[EAEvents]   WHERE [ModuleServiceID]= '<your_Service_ID>'  order by [Timestamp]  desc
    SELECT ABS(datediff(MINUTE, @lastevent , @obmsynctime )) as SyncDiff

    Please note you will have to replace <your_database_name> with your database name, default is either MMEA or EnterpriseAlert, and <your_Service_ID> with the ID of the service you want to monitor. You can get the ID from the ModuleServiceProperties as well as there will be one entry for the service type and one for the timestamp. If you have several connectors of the same type things get a little more complicated but that’s what support@de.derdack.com is for. 😉

     

    Tagged

    alert notificationsEnterpriseAlertIT AlertingIT Operationsmonitoring

    Share

    Related Posts

    Enterprise Alert 9.4.1 comes with fixes and the revised version of the sentinel connector app

    February 1, 2023

    Critical System Alerts via SIGNL4

    December 29, 2022

    Enterprise Alert 9.4 Update introduces Remote Actions for hybrid scenarios and proxy support for MS Teams

    October 25, 2022

    Upgrade your shopfloor alerting with Derdack

    September 8, 2022

    About

    DERDACK products combine automated alert notification workflows, 24/7 duty scheduling, ad-hoc collaboration and anywhere IT troubleshooting – reducing unexpected IT downtimes at large enterprises and organizations by 60%.

    Most popular

    • Derdack Company Take your ITIL incident management to the next level with Enterprise Alert
    • Mobile alert notifications for HP Service Manager (HPSM)
    • How to forward alerts to Microsoft Teams
    • Oncall Scheduling On-Call Schedule Management with Auto-Rotation
    • Even, Alert, Incident, Notification Definition of Event, Alert, Incident and Notification
    • checking-mobile Enhancing SCOM alert notifications
    • Announcing Enterprise Alert 2019
    • who-is-on-call-sharepoint Add a live “Who is On-Call” Dashboard into Sharepoint and other Tools

    Categories

    • Business (37)
    • Cloud Services (5)
    • Consultancy (1)
    • Customers (18)
    • Energy & Utilities (7)
    • Events (23)
    • Financial & Banking (4)
    • IT Ops (19)
    • Manufacturing (8)
    • News (48)
    • Schools (1)
    • Software (9)
    • Staffing (1)
    • Support (4)
    • Technical (141)
    • Transport & Logistics (5)

    Tags

    alert alert notifications Anywhere Resolution Anywhere Response Azure azure BMC customer reference Database derdack enterprise alert Enterprise Alert Enterprise Alert 2016 Enterprise Alert 2019 Gartner HPE HPE ITSM incident Incident Management Incident resolution incident response Industrie 4.0 Integration IT Alerting IT Operations Maintenance microsoft mobile Mobile App monitoring OMS on-call on-call schedule Operational Alerting rapid response release Remote Action REST API SCOM security SolarWinds NPM System Center update User Group voice

    Follow us

    • Twitter
    • Facebook
    • LinkedIn
    • XING
    • YouTube
    • Vimeo
    • Home
    • News & Blog
    • Customers
    • Tips & Tricks: Keeping Track of Event-Processing Delays

    CONTACT US:
    Intl: +49 331 29878-0

    US: +1 (804) 570-2005
    CH: +41 (31) 5391990

    CONTACT VIA EMAIL:
    info@derdack.com

    OFFICES:
    US & Europe

    NEWSLETTER:
    Sign up here

    CAREER:
    Latest job offers

    EVENTS

    • No Upcoming Events
    • Who we help
    • Products
    • How to Buy
    • About Derdack
    • News & Blog
    • Free Trial
    • Twitter
    • LinkedIn
    • YouTube
    • Vimeo

     © 2025 Derdack – Imprint, Privacy policy

    • Use Cases
      • Overview
      • Enterprise IT Alerting
      • IT Managed Services
      • Mobile Alerting in Manufacuring
      • Critical Operations Alerting in Banking & Financial
      • Field Service Dispatching in Energy & Utilities
      • Use Cases in other Industries
    • Products
      • Overview
      • Enterprise Alert®
        • Overview
        • Alert Notifications
        • On-call Duty Scheduling
        • Collaboration
        • Anywhere Remediation
        • Incident Mgmt. App
        • Integrations
        • Technical Support
        • Online Knowledge Base
        • Derdack FAQ
      • SIGNL4® Cloud
      • References & More
    • How to Buy
      • Overview
      • Pricing and Quotes
      • Azure Marketplace
    • About Derdack
      • About
      • Careers
      • Strategic Partners
      • Derdack Podcast
      • Contact Derdack
    • News & Blog
    • Request Demo
    Manage Cookie Consent
    We use cookies to optimize our website and our service.
    Functional Always active
    The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
    Preferences
    The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
    Statistics
    The technical storage or access that is used exclusively for statistical purposes. The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
    Marketing
    The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
    Manage options Manage services Manage vendors Read more about these purposes
    View preferences
    {title} {title} {title}