let f_cnt_upload_threshold = 5;
let f_upload_size_threshold = 5000000;
CiscoWSAEvent
| where HttpRequestMethod in~ ('POST', 'PUT')
| where isnotempty(AmpFileName)
| where UrlCategory in~ ('IW_fts', 'IW_osb')
| where DstBytes > f_upload_size_threshold
| summarize count() by AmpFileName, SrcUserName, bin(TimeGenerated, 10m)
| where count_ >= f_cnt_upload_threshold
| extend AccountCustomEntity = SrcUserName
severity: High
queryPeriod: 1h
name: Cisco WSA - Unexpected uploads
OriginalUri: https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/CiscoWSA/Analytic Rules/CiscoWSADataExfiltration.yaml
entityMappings:
- fieldMappings:
- columnName: AccountCustomEntity
identifier: Name
entityType: Account
version: 1.0.3
relevantTechniques:
- T1567
status: Available
id: 32c460ad-2d40-43e9-8ead-5cdd1d7a3163
queryFrequency: 1h
triggerThreshold: 0
triggerOperator: gt
query: |
let f_cnt_upload_threshold = 5;
let f_upload_size_threshold = 5000000;
CiscoWSAEvent
| where HttpRequestMethod in~ ('POST', 'PUT')
| where isnotempty(AmpFileName)
| where UrlCategory in~ ('IW_fts', 'IW_osb')
| where DstBytes > f_upload_size_threshold
| summarize count() by AmpFileName, SrcUserName, bin(TimeGenerated, 10m)
| where count_ >= f_cnt_upload_threshold
| extend AccountCustomEntity = SrcUserName
description: |
'Detects unexpected file uploads.'
requiredDataConnectors:
- connectorId: SyslogAma
datatypes:
- Syslog
tactics:
- Exfiltration
kind: Scheduled