MITRE ATT&CK coverage
| Tactic | Techniques |
|---|---|
| Credential Access |
Rule body
id: 6107cba5-2974-4c22-8222-2a6f7bbea664
name: CiscoISE - Certificate has expired
description: |
'Detects certificate expiration.'
severity: Medium
status: Available
requiredDataConnectors:
- connectorId: SyslogAma
datatypes:
- Syslog
queryFrequency: 1h
queryPeriod: 1h
triggerOperator: gt
triggerThreshold: 0
tactics:
- CredentialAccess
relevantTechniques:
- T1552
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
version: 1.0.3
kind: Scheduled
Stages and Predicates
Parameters
let lbtime = 1h;
Stage 1: source
CiscoISEEvent
Stage 2: where
| where TimeGenerated > ago(lbtime)
Stage 3: where
| where EventId == '60167'
Stage 4: project
| project SrcIpAddr, DvcIpAddr, DvcHostname, DstUserName
Stage 5: extend (3 consecutive steps)
| extend HostCustomEntity = DvcHostname
| extend IPCustomEntity = SrcIpAddr
| extend AccountCustomEntity = DstUserName
Indicators
These rows show field, operator, and value matches.
| Field | Kind | Values | Search |
|---|---|---|---|
EventId | eq |
| field:"EventId" kind:eq value:"60167" |
Output fields
These fields are emitted when the rule matches.
| Field | Source |
|---|---|
DstUserName | project |
DvcHostname | project |
DvcIpAddr | project |
SrcIpAddr | project |
HostCustomEntity | extend |
IPCustomEntity | extend |
AccountCustomEntity | extend |