CommonSecurityLog
| where DeviceVendor == "Arista Networks" and DeviceProduct == "Awake Security" and toint(LogSeverity) > 6
| 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(todecimal (LogSeverity)) by SourceHostName
OriginalUri: https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/AristaAwakeSecurity/Analytic Rules/HighSeverityMatchesByDevice.yaml
query: |
CommonSecurityLog
| where DeviceVendor == "Arista Networks" and DeviceProduct == "Awake Security" and toint(LogSeverity) > 6
| 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(todecimal (LogSeverity)) by SourceHostName
version: 1.0.2
incidentConfiguration:
createIncident: true
groupingConfiguration:
groupByCustomDetails:
- Device
matchingMethod: Selected
groupByEntities:
- Host
groupByAlertDetails: []
reopenClosedIncident: true
enabled: true
lookbackDuration: 3d
tactics: []
triggerThreshold: 0
kind: Scheduled
relevantTechniques: []
customDetails:
Matched_Models: Models
Matches_ASP_URLs: ASPMatchURLs
Matches_Dest_IPs: DestinationIPs
Device: SourceHostName
Matches_Count: ModelMatchCount
Matches_Max_Severity: MaxSeverity
entityMappings:
- entityType: Host
fieldMappings:
- columnName: SourceHostName
identifier: HostName
- entityType: IP
fieldMappings:
- columnName: SourceIPs
identifier: Address
eventGroupingSettings:
aggregationKind: AlertPerResult
queryFrequency: 1h
name: Awake Security - High Severity Matches By Device
description: This query searches for devices with high severity event(s).
alertDetailsOverride:
alertTacticsColumnName:
alertSeverityColumnName: MaxSeverity
alertDescriptionFormat: |
Device {{SourceHostName}} matched the following high-severity Awake model(s):
{{Models}}
The destination IPs associated with these matches were:
{{DestinationIPs}}
alertDisplayNameFormat: Awake Security - High Severity Matches On Device {{SourceHostName}}
queryPeriod: 1h
triggerOperator: gt
id: d5e012c2-29ba-4a02-a813-37b928aafe2d
status: Available
severity: Medium
requiredDataConnectors:
- dataTypes:
- CommonSecurityLog
connectorId: CefAma