Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Get access
To use advanced hunting or other Microsoft Defender capabilities, you need an appropriate role in Microsoft Entra ID. Read about required roles and permissions for advanced hunting.
The AlertInfo table contains records from Microsoft Defender services. When Microsoft Sentinel is onboarded to the Defender portal, the table also contains Microsoft Sentinel alerts associated with incidents. Data availability depends on the services deployed and the Sentinel workspaces you can access. For more information, see Deploy supported services and Transition your Microsoft Sentinel environment to the Defender portal.
Also, your access to endpoint data is determined by role-based access control (RBAC) settings in Microsoft Defender for Endpoint. Read about managing access to Microsoft Defender.
AlertInfo
The AlertInfo table in the advanced hunting schema contains alert information from Microsoft Defender for Endpoint, Microsoft Defender for Office 365, Microsoft Defender for Cloud Apps, Microsoft Defender for Identity, and onboarded Microsoft Sentinel workspaces. Use this reference to construct queries that return information from this table. Join AlertInfo with AlertEvidence on the AlertId column to retrieve the entities and evidence associated with each alert.
For information on other tables in the advanced hunting schema, see the advanced hunting reference.
| Column name | Data type | Description |
|---|---|---|
Timestamp |
datetime |
Date and time when the record was generated |
AlertId |
string |
Unique identifier for the alert |
Title |
string |
Title of the alert |
Category |
string |
Type of threat indicator or breach activity identified by the alert |
Severity |
string |
Indicates the potential impact (high, medium, or low) of the threat indicator or breach activity identified by the alert |
ServiceSource |
string |
Product or service that provided the alert information |
DetectionSource |
string |
Detection technology or sensor that identified the notable component or activity |
AttackTechniques |
string |
MITRE ATT&CK techniques associated with the activity that triggered the alert |
Related topics
- Advanced hunting overview
- Learn the query language
- Use shared queries
- Hunt across devices, emails, apps, and identities
- Understand the schema
- Apply query best practices
Tip
Do you want to learn more? Engage with the Microsoft Security community in our Tech Community: Microsoft Defender XDR Tech Community.