CiscoSyslogUTD
| where isnotempty(Malware) and Malware != "None"
| distinct Malware, SourceIP
| join kind=inner (CiscoSDWANNetflow
| where isnotempty(NetflowUsername)
| summarize arg_max(TimeStamp, NetflowUsername) by NetflowFwSrcAddrIpv4
| distinct
["Username"] = NetflowUsername,
["SourceIP"] = NetflowFwSrcAddrIpv4) on SourceIP
| project Malware, SourceIP, Username
description: |
'This analytic rule will monitor Malware Events in Syslog and Netflow Data'
queryPeriod: 3h
severity: High
triggerThreshold: 0
queryFrequency: 3h
tactics:
- ResourceDevelopment
version: 1.0.1
OriginalUri: https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/Cisco SD-WAN/Analytic Rules/CiscoSDWANSentinelMalwareEvents.yaml
query: |
CiscoSyslogUTD
| where isnotempty(Malware) and Malware != "None"
| distinct Malware, SourceIP
| join kind=inner (CiscoSDWANNetflow
| where isnotempty(NetflowUsername)
| summarize arg_max(TimeStamp, NetflowUsername) by NetflowFwSrcAddrIpv4
| distinct
["Username"] = NetflowUsername,
["SourceIP"] = NetflowFwSrcAddrIpv4) on SourceIP
| project Malware, SourceIP, Username
entityMappings:
- entityType: IP
fieldMappings:
- identifier: Address
columnName: SourceIP
- entityType: Malware
fieldMappings:
- identifier: Name
columnName: Malware
- entityType: Account
fieldMappings:
- identifier: Name
columnName: Username
triggerOperator: gt
name: Cisco SDWAN - Maleware Events
requiredDataConnectors:
- connectorId: CiscoSDWAN
dataTypes:
- CiscoSyslogUTD
- connectorId: CiscoSDWAN
dataTypes:
- CiscoSDWANNetflow
relevantTechniques:
- T1587.001
customDetails:
mal_username: Username
mal_src_ip: SourceIP
mal_malware: Malware
eventGroupingSettings:
aggregationKind: AlertPerResult
kind: Scheduled
incidentConfiguration:
createIncident: true
status: Available
id: cb14defd-3415-4420-a2e4-2dd0f3e07a86
