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