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

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

ARM