Awake Security - High Match Counts By Device

Back


Id	90b7ac11-dd6c-4ba1-a99b-737061873859
Rulename	Awake Security - High Match Counts By Device
Description	This query searches for devices with unexpectedly large number of activity match.
Severity	Medium
Required data connectors	CefAma
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/AristaAwakeSecurity/Analytic Rules/HighMatchCountsByDevice.yaml
Version	1.0.2
Arm template	90b7ac11-dd6c-4ba1-a99b-737061873859.json

KQL

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 ModelMatchCount > 1000 and MaxSeverity > 2
| extend SeverityName=iff(MaxSeverity == 0, "Informational", iff(MaxSeverity < 5, "Low", iff(MaxSeverity < 8, "Medium", "High")))

YAML

relevantTechniques: []
entityMappings:
- entityType: Host
  fieldMappings:
  - columnName: SourceHostName
    identifier: HostName
- entityType: IP
  fieldMappings:
  - columnName: SourceIPs
    identifier: Address
eventGroupingSettings:
  aggregationKind: AlertPerResult
version: 1.0.2
id: 90b7ac11-dd6c-4ba1-a99b-737061873859
severity: Medium
kind: Scheduled
queryFrequency: 1h
description: This query searches for devices with unexpectedly large number of activity match.
requiredDataConnectors:
- connectorId: CefAma
  dataTypes:
  - CommonSecurityLog
triggerOperator: gt
name: Awake Security - High Match Counts By Device
tactics: []
alertDetailsOverride:
  alertDescriptionFormat: |-
    The following Awake model(s):

    {{Models}}

    matched {{ModelMatchCount}} activities, an unexpectedly large number. The destination IPs associated with these matches were:

    {{DestinationIPs}}    
  alertTacticsColumnName: 
  alertSeverityColumnName: SeverityName
  alertDisplayNameFormat: Awake Security - High Model Match Counts On Device {{SourceHostName}}
OriginalUri: https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/AristaAwakeSecurity/Analytic Rules/HighMatchCountsByDevice.yaml
triggerThreshold: 0
queryPeriod: 1h
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 ModelMatchCount > 1000 and MaxSeverity > 2
  | extend SeverityName=iff(MaxSeverity == 0, "Informational", iff(MaxSeverity < 5, "Low", iff(MaxSeverity < 8, "Medium", "High")))  
status: Available
customDetails:
  Matches_Count: ModelMatchCount
  Matches_Max_Severity: MaxSeverity
  Matches_ASP_URLs: ASPMatchURLs
  Matches_Dest_IPs: DestinationIPs
  Matched_Models: Models
  Device: SourceHostName
incidentConfiguration:
  createIncident: true
  groupingConfiguration:
    matchingMethod: Selected
    groupByEntities:
    - Host
    groupByCustomDetails:
    - Device
    groupByAlertDetails: []
    reopenClosedIncident: true
    enabled: true
    lookbackDuration: 3d

ARM