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

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

ARM