CommonSecurityLog
| where DeviceVendor == "Palo Alto Networks"
| where DeviceProduct == "Cortex XDR"
| where DeviceAction == "Prevented (Blocked)"
| where LogSeverity =~ "6"
| summarize by TimeGenerated,DeviceProduct, DeviceEventClassID, LogSeverity, Activity, DeviceAction, Computer, DeviceVersion, FileHash, FileName, FilePath, RequestURL, SourceHostName, SourceUserName
| sort by TimeGenerated
query: |
CommonSecurityLog
| where DeviceVendor == "Palo Alto Networks"
| where DeviceProduct == "Cortex XDR"
| where DeviceAction == "Prevented (Blocked)"
| where LogSeverity =~ "6"
| summarize by TimeGenerated,DeviceProduct, DeviceEventClassID, LogSeverity, Activity, DeviceAction, Computer, DeviceVersion, FileHash, FileName, FilePath, RequestURL, SourceHostName, SourceUserName
| sort by TimeGenerated
description: |
'The query checks for all malicious events prevented events across all devices having LogSeverity of '6' and summarize the result.'
triggerOperator: gt
triggerThreshold: 0
queryPeriod: 1d
queryFrequency: 1d
entityMappings:
- entityType: Account
fieldMappings:
- columnName: SourceUserName
identifier: FullName
- entityType: Host
fieldMappings:
- columnName: SourceHostName
identifier: FullName
- entityType: File hash
fieldMappings:
- columnName: FileHash
identifier: Value
- entityType: File
fieldMappings:
- columnName: FileName
identifier: Name
- entityType: File
fieldMappings:
- columnName: FilePath
identifier: Name
- entityType: URL
fieldMappings:
- columnName: RequestURL
identifier: Url
name: Palo Alto Prevention alert
id: 5180e347-32fb-4a0a-9cfa-d6e0e10fc4eb
tactics:
- DefenseEvasion
kind: Scheduled
requiredDataConnectors:
- connectorId: PaloAltoNetworksCortex
dataTypes:
- PaloAltoNetworksCortex
OriginalUri: https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/Palo Alto - XDR (Cortex)/Detection Queries/Preventive Alerts.yaml
version: 1.0.0
severity: Medium
relevantTechniques:
- T1562
