let ioc_lookBack = 1d;
_Im_NetworkSession
| where isnotempty(DstIpAddr)
| join kind=inner (
ThreatIntelIndicators
| where ObservableKey == 'ipv4-addr: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())
) on $left.DstIpAddr == $right.ObservableValue
| project NetworkIP=ObservableValue, Description=Data.description, Type, TimeGenerated
incidentConfiguration:
groupingConfiguration:
lookbackDuration: 1h
reopenClosedIncident: false
matchingMethod: AllEntities
enabled: true
createIncident: true
query: |
let ioc_lookBack = 1d;
_Im_NetworkSession
| where isnotempty(DstIpAddr)
| join kind=inner (
ThreatIntelIndicators
| where ObservableKey == 'ipv4-addr: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())
) on $left.DstIpAddr == $right.ObservableValue
| project NetworkIP=ObservableValue, Description=Data.description, Type, TimeGenerated
name: Google Threat Intelligence - Threat Hunting IP
relevantTechniques:
- T1071
requiredDataConnectors:
- connectorId: ThreatIntelligence
dataTypes:
- ThreatIntelIndicators
entityMappings:
- entityType: IP
fieldMappings:
- columnName: NetworkIP
identifier: Address
queryFrequency: 30m
eventGroupingSettings:
aggregationKind: AlertPerResult
alertDetailsOverride:
alertDescriptionFormat: Correlation found from the {{Type}} table.
alertDisplayNameFormat: Google Threat Intelligence Match
kind: Scheduled
version: 1.0.0
triggerOperator: gt
description: |
'Google Threat Intelligence IP correlation.'
tactics:
- CommandAndControl
queryPeriod: 1d
triggerThreshold: 0
OriginalUri: https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/Google Threat Intelligence/Analytic Rules/ThreatHunting/ThreatHuntIp.yaml
severity: Medium
id: 7edb2abb-7ef7-4685-92eb-a628703ccf9f