Cisco WSA - Multiple errors to URL

Back


Id	1db49647-435c-41ad-bf8c-7130ba75429d
Rulename	Cisco WSA - Multiple errors to URL
Description	Detects multiple connection errors to URL.
Severity	Medium
Tactics	CommandAndControl
Techniques	T1102
Required data connectors	SyslogAma
Kind	Scheduled
Query frequency	1h
Query period	1h
Trigger threshold	0
Trigger operator	gt
Source Uri	https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/CiscoWSA/Analytic Rules/CiscoWSAMultipleErrorsToUrl.yaml
Version	1.0.2
Arm template	1db49647-435c-41ad-bf8c-7130ba75429d.json

KQL

let threshold = 5;
CiscoWSAEvent
| where DvcAction =~ 'NONE'
| summarize count() by SrcUserName, UrlOriginal, bin(TimeGenerated, 5m)
| where count_ >= threshold
| extend URLCustomEntity = UrlOriginal, AccountCustomEntity = SrcUserName

YAML

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

ARM