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

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

ARM