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

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

ARM