Querying OMS for Events


On the previous article of the series, we queried the OMS workspace for performance statistics and created graphs to present the data. On this article we are going to query for events on the windows logs.

The below query will return all the servers that were shut down unexpectedly during the last day:


The "project" function allows us to pick the columns on the result.

Role fail over in failover clusters is another thing I usually monitor:


Since the events are written in the Microsoft-Windows-FailoverClustering/Operational log, we need to add it to the windows event logs that OMS is collecting first.

You can also monitor trends in application events:


As show in the above chart, there number of error events in the application log of one of my Exchange servers increased significantly a few days ago.

Data can also be rendered in multiple dimensions. The below graph shows the number of the Error, Warning, Information and Success events for the last day, per server.


On the next article of the series, we are going to set up alerts based on events and performance metrics.

Related articles
    Introduction to Azure Advanced Analytics
    Configuring Log and Performance Counter collection on the OMS Workspace
    Install and Configure the OMS Windows Agent
    Verify the Agent Connectivity to OMS Workspace
    Deploying the OMS Windows Agent using DSC
    Querying OMS for Performance Data
    Querying OMS for Events
    Collecting IIS Log Files
    Install and Configure the OMS Linux Agent
    Syslog Message Collection for OMS from sources that do not support the agent
    Generating Alerts on OMS
    Update Management using OMS
    Monitoring Active Directory Health using OMS
    Assessing Security using OMS
    Monitoring Microsoft SQL using OMS
    Monitoring Azure Activity Log using OMS

Popular posts from this blog

Domain Controller Machine Password Reset

Managing Active Directory User Certificates using PowerShell

Configuring a Certificate on Exchange Receive Connector