let threshold = 5;
CiscoWSAEvent
| where DvcAction =~ 'NONE'
| summarize count() by SrcUserName, UrlOriginal, bin(TimeGenerated, 5m)
| where count_ >= threshold
| extend URLCustomEntity = UrlOriginal, AccountCustomEntity = SrcUserName
query: |
let threshold = 5;
CiscoWSAEvent
| where DvcAction =~ 'NONE'
| summarize count() by SrcUserName, UrlOriginal, bin(TimeGenerated, 5m)
| where count_ >= threshold
| extend URLCustomEntity = UrlOriginal, AccountCustomEntity = SrcUserName
requiredDataConnectors:
- datatypes:
- Syslog
connectorId: SyslogAma
status: Available
name: Cisco WSA - Multiple errors to URL
entityMappings:
- fieldMappings:
- identifier: Url
columnName: URLCustomEntity
entityType: URL
- fieldMappings:
- identifier: Name
columnName: AccountCustomEntity
entityType: Account
kind: Scheduled
triggerThreshold: 0
queryPeriod: 1h
description: |
'Detects multiple connection errors to URL.'
triggerOperator: gt
OriginalUri: https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/CiscoWSA/Analytic Rules/CiscoWSAMultipleErrorsToUrl.yaml
version: 1.0.2
queryFrequency: 1h
severity: Medium
tactics:
- CommandAndControl
id: 1db49647-435c-41ad-bf8c-7130ba75429d
relevantTechniques:
- T1102