CiscoISE - Certificate has expired

Back


Id	6107cba5-2974-4c22-8222-2a6f7bbea664
Rulename	CiscoISE - Certificate has expired
Description	Detects certificate expiration.
Severity	Medium
Tactics	CredentialAccess
Techniques	T1552
Required data connectors	SyslogAma
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/Cisco ISE/Analytic Rules/CiscoISECertExpired.yaml
Version	1.0.3
Arm template	6107cba5-2974-4c22-8222-2a6f7bbea664.json

KQL

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

YAML

name: CiscoISE - Certificate has expired
id: 6107cba5-2974-4c22-8222-2a6f7bbea664
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  
entityMappings:
- entityType: Account
  fieldMappings:
  - identifier: FullName
    columnName: AccountCustomEntity
- entityType: IP
  fieldMappings:
  - identifier: Address
    columnName: IPCustomEntity
- entityType: Host
  fieldMappings:
  - identifier: FullName
    columnName: HostCustomEntity
relevantTechniques:
- T1552
description: |
    'Detects certificate expiration.'
queryPeriod: 1h
status: Available
OriginalUri: https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/Cisco ISE/Analytic Rules/CiscoISECertExpired.yaml
kind: Scheduled
triggerOperator: gt
severity: Medium
version: 1.0.3
queryFrequency: 1h
tactics:
- CredentialAccess
triggerThreshold: 0
requiredDataConnectors:
- connectorId: SyslogAma
  datatypes:
  - Syslog

ARM