let lbtime = 1h;
CiscoISEEvent
| where TimeGenerated > ago(lbtime)
| where EventId == '60167'
| project SrcIpAddr, DvcIpAddr, DvcHostname, DstUserName
| extend HostCustomEntity = DvcHostname
| extend IPCustomEntity = SrcIpAddr
| extend AccountCustomEntity = DstUserName
status: Available
OriginalUri: https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/Cisco ISE/Analytic Rules/CiscoISECertExpired.yaml
query: |
let lbtime = 1h;
CiscoISEEvent
| where TimeGenerated > ago(lbtime)
| where EventId == '60167'
| project SrcIpAddr, DvcIpAddr, DvcHostname, DstUserName
| extend HostCustomEntity = DvcHostname
| extend IPCustomEntity = SrcIpAddr
| extend AccountCustomEntity = DstUserName
requiredDataConnectors:
- datatypes:
- Syslog
connectorId: SyslogAma
tactics:
- CredentialAccess
name: CiscoISE - Certificate has expired
relevantTechniques:
- T1552
severity: Medium
entityMappings:
- fieldMappings:
- identifier: FullName
columnName: AccountCustomEntity
entityType: Account
- fieldMappings:
- identifier: Address
columnName: IPCustomEntity
entityType: IP
- fieldMappings:
- identifier: FullName
columnName: HostCustomEntity
entityType: Host
kind: Scheduled
queryFrequency: 1h
description: |
'Detects certificate expiration.'
triggerThreshold: 0
triggerOperator: gt
version: 1.0.3
queryPeriod: 1h
id: 6107cba5-2974-4c22-8222-2a6f7bbea664