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