let ioc_lookBack = 1d;
_Im_Dns
| where isnotempty(DnsQuery)
| extend lowerDomain=tolower(DnsQuery)
| join kind=inner (
ThreatIntelIndicators
| where ObservableKey == 'domain-name:value'
| where isnotempty(ObservableValue)
| where SourceSystem == "Google Threat Intelligence"
| where TimeGenerated >= ago(ioc_lookBack)
| summarize LatestIndicatorTime = arg_max(TimeGenerated, *) by Id
| where IsActive == true and (isnull(ValidUntil) or ValidUntil > now())
| extend lowerDomain=tolower(ObservableValue)
) on lowerDomain
| project Domain=ObservableValue, Description=Data.description, Type, TimeGenerated
name: Google Threat Intelligence - Threat Hunting Domain
relevantTechniques:
- T1071
id: d9e1646c-dc17-4150-ac85-581f5c9cb41f
OriginalUri: https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/Google Threat Intelligence/Analytic Rules/ThreatHunting/ThreatHuntDomain.yaml
requiredDataConnectors:
- dataTypes:
- ThreatIntelIndicators
connectorId: ThreatIntelligence
eventGroupingSettings:
aggregationKind: AlertPerResult
version: 1.0.0
severity: Medium
triggerThreshold: 0
queryPeriod: 1d
entityMappings:
- fieldMappings:
- identifier: DomainName
columnName: Domain
entityType: DNS
incidentConfiguration:
groupingConfiguration:
reopenClosedIncident: false
matchingMethod: AllEntities
lookbackDuration: 1h
enabled: true
createIncident: true
queryFrequency: 30m
alertDetailsOverride:
alertDisplayNameFormat: Google Threat Intelligence Match
alertDescriptionFormat: Correlation found from the {{Type}} table.
query: |
let ioc_lookBack = 1d;
_Im_Dns
| where isnotempty(DnsQuery)
| extend lowerDomain=tolower(DnsQuery)
| join kind=inner (
ThreatIntelIndicators
| where ObservableKey == 'domain-name:value'
| where isnotempty(ObservableValue)
| where SourceSystem == "Google Threat Intelligence"
| where TimeGenerated >= ago(ioc_lookBack)
| summarize LatestIndicatorTime = arg_max(TimeGenerated, *) by Id
| where IsActive == true and (isnull(ValidUntil) or ValidUntil > now())
| extend lowerDomain=tolower(ObservableValue)
) on lowerDomain
| project Domain=ObservableValue, Description=Data.description, Type, TimeGenerated
tactics:
- CommandAndControl
kind: Scheduled
description: |
'Google Threat Intelligence domain correlation.'
triggerOperator: gt