CommonSecurityLog | where DeviceVendor == "Arista Networks" and DeviceProduct == "Awake Security"
| summarize StartTime=min(TimeGenerated), EndTime=max(TimeGenerated), Models=make_set(Activity), ASPMatchURLs=make_set(DeviceCustomString2), SourceIPs=make_set(SourceIP),
DestinationIPs=make_set(DestinationIP), ModelMatchCount=sum(EventCount), MaxSeverity=max(toint(LogSeverity)) by SourceHostName
| where array_length(DestinationIPs) > 1
name: Awake Security - Model With Multiple Destinations
kind: Scheduled
tactics: []
triggerThreshold: 0
triggerOperator: gt
version: 1.0.2
status: Available
alertDetailsOverride:
alertDisplayNameFormat: Awake Security - Model Matches With Multiple Destinations On Device {{SourceHostName}}
alertDescriptionFormat: |
Device {{SourceHostName}} communicated with multiple possibly malicious destinations. The destination IPs were:
{{DestinationIPs}}
The associated with Awake model(s) were:
{{Models}}
alertTacticsColumnName:
alertSeverityColumnName:
incidentConfiguration:
createIncident: true
groupingConfiguration:
reopenClosedIncident: true
enabled: true
matchingMethod: Selected
groupByAlertDetails: []
groupByEntities:
- Host
groupByCustomDetails:
- Device
lookbackDuration: 3d
queryFrequency: 1h
id: dfa3ec92-bdae-410f-b675-fe1814e4d43e
requiredDataConnectors:
- connectorId: CefAma
dataTypes:
- CommonSecurityLog
eventGroupingSettings:
aggregationKind: AlertPerResult
relevantTechniques: []
description: This query searches for devices with multiple possibly malicious destinations.
customDetails:
Matches_Max_Severity: MaxSeverity
Matches_ASP_URLs: ASPMatchURLs
Matched_Models: Models
Device: SourceHostName
Matches_Count: ModelMatchCount
Matches_Dest_IPs: DestinationIPs
entityMappings:
- entityType: Host
fieldMappings:
- columnName: SourceHostName
identifier: HostName
- entityType: IP
fieldMappings:
- columnName: SourceIPs
identifier: Address
OriginalUri: https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/AristaAwakeSecurity/Analytic Rules/ModelMatchesWithMultipleDestinationsByDevice.yaml
queryPeriod: 1h
severity: Medium
query: |
CommonSecurityLog | where DeviceVendor == "Arista Networks" and DeviceProduct == "Awake Security"
| summarize StartTime=min(TimeGenerated), EndTime=max(TimeGenerated), Models=make_set(Activity), ASPMatchURLs=make_set(DeviceCustomString2), SourceIPs=make_set(SourceIP),
DestinationIPs=make_set(DestinationIP), ModelMatchCount=sum(EventCount), MaxSeverity=max(toint(LogSeverity)) by SourceHostName
| where array_length(DestinationIPs) > 1