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

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

ARM