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
entityMappings:
- entityType: URL
fieldMappings:
- columnName: URLCustomEntity
identifier: Url
- entityType: Account
fieldMappings:
- columnName: AccountCustomEntity
identifier: Name
triggerThreshold: 0
name: Cisco WSA - Multiple errors to URL
severity: Medium
relevantTechniques:
- T1102
queryPeriod: 1h
tactics:
- CommandAndControl
requiredDataConnectors:
- connectorId: SyslogAma
datatypes:
- Syslog
queryFrequency: 1h
version: 1.0.2
OriginalUri: https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/CiscoWSA/Analytic Rules/CiscoWSAMultipleErrorsToUrl.yaml
id: 1db49647-435c-41ad-bf8c-7130ba75429d
kind: Scheduled
description: |
'Detects multiple connection errors to URL.'
status: Available
triggerOperator: gt