Bilješka
Pristup ovoj stranici zahtijeva provjeru vjerodostojnosti. Možete pokušati da se prijavite ili promijenite direktorije.
Pristup ovoj stranici zahtijeva provjeru vjerodostojnosti. Možete pokušati promijeniti direktorije.
The DataSecurityEvents table in the advanced hunting schema contains information about user activities that violate user-defined or default policies in the Microsoft Purview suite of solutions. Each log represents a single user activity enriched with proprietary Microsoft detections (like sensitive info types) and user-defined enrichment labels like domain categories, sensitivity labels, and others.
This advanced hunting table is populated by records from Microsoft Purview Insider Risk Management. If your organization hasn't opted in to share insider risk alerts with Microsoft Defender, queries that use the table aren't going to work or return any results. For more information, read Investigate insider risk threats.
Use this reference to construct queries that return information from this table. For information on other tables in the advanced hunting schema, see the advanced hunting reference.
| Column name | Data type | Description |
|---|---|---|
ApplicationNames |
string |
List of application names used or related to the event |
DeviceId |
string |
Unique identifier for the device in Microsoft Defender for Endpoint |
DeviceName |
string |
Fully qualified domain name (FQDN) of the device |
AadDeviceId |
guid |
Unique identifier for the device in Microsoft Entra ID |
IsManagedDevice |
bool |
Indicates if the device is managed by the organization (True) or not (False) |
DlpPolicyMatchInfo |
string |
Information around the list of data loss prevention (DLP) policies matching this event |
DlpPolicyEnforcementMode |
int |
Indicates the Data Loss Prevention policy that was enforced; value can be: 0 (None), 1 (Audit), 2 (Warn), 3 (Warn and bypass), 4 (Block), 5 (Allow) |
DlpPolicyRuleMatchInfo |
dynamic |
Details of the data loss prevention (DLP) rules that matched with this event; in JSON array format |
FileRenameInfo |
string |
Details of the file (file name and extension) before this event |
PhysicalAccessPointInfo |
object |
Information about the physical access in the event, including the physical access point's unique identifier, name, status, and the tag assigned to the asset |
PhysicalAccessPointId |
string |
Unique identifier for the physical access point |
PhysicalAccessPointName |
string |
Name of the physical access point |
PhysicalAccessStatus |
string |
Status of physical access, whether it succeeded or failed |
PhysicalAssetTag |
string |
Tag assigned to the asset as configured in Microsoft Insider Risk Management global settings |
RemovableMediaInfo |
object |
List of any removable media involved in the behavior, including the serial number of the removable media device, the manufacturer of the removable media device, and the model of the removable device |
RemovableMediaManufacturer |
string |
Manufacturer name of the removable device |
RemovableMediaModel |
string |
Model name of the removable device |
RemovableMediaSerialNumber |
string |
Serial number of the removable device |
TeamsChannelName |
string |
Name of the Teams channel |
TeamsChannelType |
string |
Type of the Teams channel |
TeamsTeamName |
string |
Name of the Teams team |
UserAlternateEmails |
string |
Alternate emails or aliases of the user |
AccountUpn |
string |
User principal name (UPN) of the account |
AccountObjectId |
string |
Unique identifier for the account in Microsoft Entra ID |
Department |
string |
Name of the department that the account user belongs to |
SourceCodeInfo |
string |
Details of the source code repository involved in the event |
CcPolicyMatchInfo |
dynamic |
Details of the Communications Compliance policy matches for this event; in JSON array format |
IPAddress |
string |
IP addresses of the clients on which the activity was performed; can contain multiple IPs if related to Microsoft Defender for Cloud Apps alerts |
Timestamp |
datetime |
Date and time when the event was recorded |
DeviceSourceLocationType |
int |
Indicates the type of location where the endpoint signals originated from; values can be: 0 (Unknown), 1 (Local), 2 (Remote), 3 (Removable), 4 (Cloud), 5 (File share) |
DeviceDestinationLocationType |
int |
Indicates the type of location where the endpoint signals connected to; values can be: 0 (Unknown), 1 (Local), 2 (Remote), 3 (Removable), 4 (Cloud), 5 (File share) |
IrmPolicyMatchInfo |
dynamic |
Details of Insider Risk Management policy matches for the content involved in the event; in JSON array format |
ExternalUrlDomains |
string |
Websites or service URLs involved in this event that is classified as External in Insider Risk Management global settings |
InternetMessageId |
string |
Public-facing identifier for the email or Teams message that is set by the sending email system |
NetworkMessageId |
guid |
Unique identifier for the email, generated by Microsoft 365 |
EmailSubject |
string |
Subject of the email |
ObjectId |
string |
Unique identifier of the object that the recorded action was applied to, in case of files, it includes the extension |
ObjectName |
string |
Name of the object that the recorded action was applied to, in case of files, it includes the extension |
ObjectType |
string |
Type of object, such as a file or a folder, that the recorded action was applied to |
ObjectSize |
int |
Size of the object in bytes |
IsHidden |
bool |
Indicates whether the user has marked the content as hidden (True) or not (False) |
ActivityId |
guid |
Unique identifier of the activity log |
ActionType |
string |
Type of activity that triggered the event |
SensitiveInfoTypeInfo |
dynamic |
Details of Data Loss Prevention sensitive info types detected in the impacted asset |
SensitivityLabelId |
string |
The current Microsoft Information Protection sensitivity label ID associated with the item |
SharepointSiteSensitivityLabelIds |
string |
The current Microsoft Information Protection sensitivity label ID assigned to the parent site of the item related to SharePoint activities |
PreviousSensitivityLabelId |
string |
The previous Microsoft Information Protection sensitivity label ID associated with the item in case of activities where the sensitivity label was changed |
Operation |
string |
Name of the admin activity |
RecipientEmailAddress |
string |
Email address of the recipient, or email address of the recipient after distribution list expansion |
SiteUrl |
string |
The URL of the site where the file or folder accessed by the user is located |
SourceRelativeUrl |
string |
The URL of the folder that contains the file accessed by the user |
PrinterName |
string |
List of printers involved in the behavior |
IrmActionCategory |
enum |
A unique enumeration value indicating the activity category in Microsoft Purview Insider Risk Management |
RiskyAIUsageAccessedResourceInfo |
object |
Details of the resources accessed or referenced by the application involved in the risky AI usage event |
RiskyAIUsageAppCategory |
string |
Details of the category of the application involved in the risky AI usage event |
RiskyAIUsageSensitivityLabelsInfo |
object |
Information regarding the sensitivity labels of entities involved in the risky AI usage event |
SequenceCorrelationId |
string |
Details of the sequence activity |
Related articles
- Advanced hunting overview
- Learn the query language
- Use shared queries
- 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.