Query Logs in Azure Sentinel

By Ashwin Venugopal -

 



Query Logs in Logs Page

In Azure Sentinel, the logs page provides access to the query window while allowing you to run queries, save queries, run saved queries, create a new alert rule, and export.  If  you want to run a query, first of all enter a query text and then press the run button. The query results can be seen at the bottom section of the form.

Understand Azure Sentinel Table

Azure Sentinel consists of Analytic Rules that will generate alerts and incidents based on querying the tables within Log Analytics while simultaneously providing tables to be a repository of indicators and watchlists. Some of the Sentinel Data Connectors are capable of ingesting alerts directly. The table below is the Azure Sentinel feature related tables:

Table

Description

SecurityAlert

Contains alerts generated from Sentinel Analytical Rules. Also, it includes alerts created directly from Sentinel Data Connector.

SecurityIncident

Alerts can generate incidents. Incidents are related to alert(s).

ThreatIntelligenceIndicator

Contains user-created or data connector ingested indicators such as File Hashes, IP Addresses, Domain.

Watchlist

An Azure Sentinel watchlist contains imported data.

 Understand Common Tables

When Sentinel ingests data from the Data Connectors, the following table lists the most commonly used tables:

Table

Description

AzureActivity

Entries from the Azure Activity log that provides insights into any subscription-level or management group level events that have occurred in Azure.

AzureDiagnostics

Stores resource logs for Azure Services that use Azure Diagnostics mode. Resource logs describes the internal operation of Azure resources.

AuditLogs

Audit Logs for Azure Active Directory includes system activity information about user and group management managed applications as well as directory activities.

CommonSecurityLog

Syslog messages using the Common Event Format (CEF).

McasShadowltReporting

Microsoft Cloud App Security logs.

OfficeActivity

Audit logs for Office 365 tenants collected by Azure Sentinel. Including Exchange, SharePoint, and Teams Logs.

SecurityEvent

Security events collected from Windows machines by Azure Security Center or Azure Sentinel.

SigninLogs

Azure Active Directory Sign in logs.

Syslog

Syslog events on Linux computers using the Log Analytics agent.

Event

Sysmon Events collected from a Windows host.

WindowsFirewall

Windows Firewall Events.

 Understand Microsoft 365 Defender Tables

The Microsoft 365 Defender Sentinel Data Connector can populate tables with raw data collected from the Microsoft 365 Defender solutions. Microsoft Defender for Endpoint tables:

Table

Description

DeviceEvents

The miscellaneous device events table contains information about various event types including, events triggered by security controls, such as Microsoft Defender Antivirus and exploit protection.

DeviceFileEvents

This table contains information about file creation, modification, and other file system events.

DeviceImageLoadEvents

This table contains information about DLL loading events.

DeviceInfo

This table contains information about devices in the organization, including their OS version, active users, and computer name.

DeviceLogonEvents

This table contains information about user logons and other authentication events.

DeviceNetworkInfo

This table contains information about networking configuration of devices, including network adapters, IP and MAC addresses, and connected networks or domains.

DeviceProcessEvents

This table contains information about process creation and related events.

DeviceRegistryEvents

This table contains information about the creation and modification of registry entries.

DeviceNetworkEvents

This table contains information about network connection and related events.

 









Comments

Post a Comment

Popular posts from this blog

Deployment (Part 3)

By Ashwin Venugopal -
Image
  To read part 1, please click  here To read part 2, please click  here Microsoft Monitoring Agent (MMA) MMA is used across multiple Microsoft solutions and has undergone a few name changes as its features and functionality have evolved. If it is being considered to be used, then following areas should be covered during a Microsoft Sentinel deployment project: Consider the timelines and the strategy for a migration to AMA (Azure Monitor Agent) before the MMA end-of-life.  Consider the central deployment and management methodology for MMA. Determine which endpoints are in scope for deployment as these affect the log ingestion volume significantly.  Azure Monitor Agent (AMA) Organizations with MMA as the main Microsoft Sentinel agent should start planning the migration to AMA as soon as possible to avoid a rushed migration. One of the main advantages of AMA is the ability to control the log collection policy centrally and apply different policies against different groups of computers, re
Read more

Project Resourcing (Part 2)

By Ashwin Venugopal -
Image
  To read part 1, please click  here Engineering - SIEM The SIEM engineers configures Microsoft Sentinel, including Log Analytics, Logic Apps, workbooks, and playbooks. They are also responsible for the following high-level tasks: Initial configuration of Azure tenant, including provisioning required resources, assigning access roles, and configuring workspace parameters like log retention, resource tagging, and blueprints.  Deployment and configuration of syslog/CEF log collection agents in appropriate locations to collect logs from on-premises devices. Generally, it will be joint effort of both system engineer and SIEM engineer, involving configuration and potential troubleshooting.  Working with system owners to enable log forwarding and configuring any required parsing of log data in Log Analytics.  Working with security operations to create and deploy KQL analytic rules to offer detections for SOC/Computer Security Incident Response Team (CSRIT) use. Tuning of alert rule parameter
Read more

Design Planning (Part 3)

By Ashwin Venugopal -
Image
  To read part 1, please click  here To read part 2, please click  here Complex Organizational Structures SIEM can be an expensive security control, hence, it is common multiple businesses to contribute to the overall expense. Various organizational units may require a level of access to specific dashboards or sets of data. Microsoft Sentinel offers the ability to assign table-level permissions and limit the level of access to the minimum required to perform requisite job functions.  Role-based Access Control (RBAC) Requirements Microsoft Sentinel offers an extensive list of Azure built-in roles that can be used to provide granular access according to the job requirements and permitted level of access. Some of them are various Microsoft Sentinel dedicated roles: Microsoft Sentinel Contributor- Can perform all engineering-related configuration, such as creating alert rules, configuring data connectors, and additional similar tasks.  Microsoft Sentinel Reader- Can query the log data stor
Read more