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

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

ARM