OracleDBAudit - Shutdown Server

Back


Id	27cc2cdc-ba67-4906-a6ef-ecbc9c284f4e
Rulename	OracleDBAudit - Shutdown Server
Description	Detects when “SHUTDOWN” command was sent to server.
Severity	Medium
Tactics	Impact
Techniques	T1529
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/OracleDatabaseAudit/Analytic Rules/OracleDBAuditShutdownServer.yaml
Version	1.0.2
Arm template	27cc2cdc-ba67-4906-a6ef-ecbc9c284f4e.json

KQL

OracleDatabaseAuditEvent
| where isnotempty(SrcIpAddr)
| where DbAction =~ 'SHUTDOWN'
| project SrcIpAddr, DstUserName
| extend AccountCustomEntity = DstUserName
| extend IPCustomEntity = SrcIpAddr

YAML

version: 1.0.2
status: Available
queryPeriod: 1h
OriginalUri: https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/OracleDatabaseAudit/Analytic Rules/OracleDBAuditShutdownServer.yaml
relevantTechniques:
- T1529
description: |
    'Detects when "SHUTDOWN" command was sent to server.'
kind: Scheduled
name: OracleDBAudit - Shutdown Server
queryFrequency: 1h
id: 27cc2cdc-ba67-4906-a6ef-ecbc9c284f4e
requiredDataConnectors:
- connectorId: SyslogAma
  datatypes:
  - Syslog
tactics:
- Impact
triggerThreshold: 0
severity: Medium
query: |
  OracleDatabaseAuditEvent
  | where isnotempty(SrcIpAddr)
  | where DbAction =~ 'SHUTDOWN'
  | project SrcIpAddr, DstUserName
  | extend AccountCustomEntity = DstUserName
  | extend IPCustomEntity = SrcIpAddr  
entityMappings:
- entityType: Account
  fieldMappings:
  - columnName: AccountCustomEntity
    identifier: FullName
- entityType: IP
  fieldMappings:
  - columnName: IPCustomEntity
    identifier: Address
triggerOperator: gt

ARM