CiscoWSAEvent
| where isnotempty(AmpFileName)
| where isempty(AmpThreatName)
| where ResponseBodyMimeType =~ 'application/octet-stream'
| where AmpFileName !endswith '.exe'
| extend IPCustomEntity = SrcIpAddr, AccountCustomEntity = SrcUserName
name: Cisco WSA - Unexpected file type
kind: Scheduled
tactics:
- InitialAccess
triggerThreshold: 0
triggerOperator: gt
version: 1.0.2
status: Available
queryFrequency: 1h
id: 8e9d1f70-d529-4598-9d3e-5dd5164d1d02
requiredDataConnectors:
- connectorId: SyslogAma
datatypes:
- Syslog
relevantTechniques:
- T1189
description: |
'Detects unexpected file type.'
entityMappings:
- entityType: IP
fieldMappings:
- columnName: IPCustomEntity
identifier: Address
- entityType: Account
fieldMappings:
- columnName: AccountCustomEntity
identifier: Name
OriginalUri: https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/CiscoWSA/Analytic Rules/CiscoWSAUnexpectedFileType.yaml
queryPeriod: 1h
severity: Medium
query: |
CiscoWSAEvent
| where isnotempty(AmpFileName)
| where isempty(AmpThreatName)
| where ResponseBodyMimeType =~ 'application/octet-stream'
| where AmpFileName !endswith '.exe'
| extend IPCustomEntity = SrcIpAddr, AccountCustomEntity = SrcUserName