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
    • Find a local Partner
    • Azure Marketplace
  • About Derdack
    • About
    • Careers
    • Partner Program
    • Strategic Partners
    • Derdack Podcast
    • Contact Derdack
  • News & Blog
  • Request Demo
    • de de
  • News & Blog

    • Home
    • News & Blog
    • Technical
    • Enhanced Enterprise Alert Reporting with Power BI

    Enhanced Enterprise Alert Reporting with Power BI

    • December 22, 2021
    • Technical
    Enhanced Enterprise Alert Reporting with Power BI

    The benefits of using the correct reporting, analytics and information delivery capabilities can transform an organization.  Having access to timely data, reporting, and analytic capabilities helps to ensure the ability to get the right data to the right users at the right time.  Having the ability to pull any information that your business needs at any given time allows for the flexibility to get the information for your business when and where it is needed.

     

    Let’s look at some PowerBI created reports:

    Enterprise Alert saves all alerting information into a local Database that can be used to create reports inside of PowerBI.  Inside of PowerBI there is an option to create reports directly from a SQL database.

    Selecting that option will bring up a connection box to allow PowerBI to connect to your Database.

    Once this connection is established you can create any report you wish to see using the Enterprise Alert Database.

     

    To get you started we have documented how to create a number of, below are the reports and the Database tables used to create them.

     

    1. Alert Counts

    Our first report is actually 3 reports, these reports show the number of alerts that have been raised in a certain time frame.  This report allows you to see spikes in alerting numbers over a set period of days.

    1. Alert Count by Teams

    Our second report is a count of all alerts sent to each team inside of Enterprise Alert.  This report allows you to see if one team is taking a larger than normal load for alerts while another team is not receiving any.

    1. Alert Count by Users

    The third report we created is the Alert Count by Users report.  This report will allow you to see which of your users are receiving alerts and to know if one user us not pulling his weight while another shoulders all of the burden.

    1. Alert Destination by User

    Our Fourth report is the Alert Destination by User report.  This report allows you to quickly look at what notification channels are being used by your users, which can enable to you make a decision on if you have one user that is being notified in one way vs the rest of a team being notified in another.  Using this in conjunction with the above report will allow you to make decisions on how best to notify users.

    1. Count of Alerts sent via All Notification Channels

    The fifth report we created is the Count of Alerts sent via All Notification Channels.   This report allows you to show count of all alerts being sent by each notification channel, which will in turn enable you to make informed decisions on which channels need to be upgraded and which ones can be disable from not being used.

    1. Count of Alerts by Source

    The next report we created is a count of all alerts created by each event source in your system.  This allows you to know which event source inside of Enterprise Alert is sending more and more alerts into the system, this can allow you to focus on where issues are arising and help stop them before they start.

    1. Count of Alert Policies Triggered by Events

    The final report we created is a count showing how often each alert Policy is being activated by incoming events.  This report will allow you to see if one Policy is generating to many alerts and is maybe its filters are to general, or if another is not sending out any alerts and is maybe to specialized.

    SUMMARY

    Using PowerBI in conjunction with your Enterprise Alert Databases allows you to create reports to quickly show data and find patterns of incoming events so you can quickly react to spikes in events and help solve issues even faster.  In addition the ability to show how your alerts are being sent to users will allow you to prioritize upgrades to the affected notification channels to stay ahead of load issues, or even eliminate cost by having users switch from one notification channel to another.

     

    For a video detailing our use of PowerBI reports and how to create the above reports go here: https://youtu.be/wXCeH6SwkOE

     

    Schedule your personal demo today to see how Callouts can increase the speed and efficiency of your emergency notifications.  https://www.derdack.com/request-a-demo/

    Tagged

    BIderdackEnhancedEnterprise AlertPowerPowerBIReporting

    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
    • checking-mobile Enhancing SCOM alert notifications
    • Announcing Enterprise Alert 2019
    • Even, Alert, Incident, Notification Definition of Event, Alert, Incident and Notification
    • 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
    • Technical
    • Enhanced Enterprise Alert Reporting with Power BI

    CONTACT US:
    Intl: +49 331 29878-0

    US: +1 (202) 470-0885
    UK: +44 (20) 88167095
    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
    • XING
    • YouTube
    • Vimeo

     © 2022 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
      • Find a local Partner
      • Azure Marketplace
    • About Derdack
      • About
      • Careers
      • Partner Program
      • 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}