turbot/alicloud_compliance

Control: 2.15 Ensure log monitoring and alerts are set up for RDS instance configuration changes

Description

It is recommended that a metric filter and alarm be established for RDS Instance configuration changes.

Remediation

Perform the following to ensure the log monitoring and alerts are set up for RDS instance configuration changes:

From Console

  1. Logon to SLS Console.
  2. Click Log Service Audit Service in the navigation pane.
  3. Go to Access to Cloud Products > Global Configuration page.
    • Select a location of project for logs.
    • Check the Action Trail and configure a proper days.
    • Click Save to save the changes.
  4. Go to Access to Cloud Products > Global Configurations click Central Project.
  5. Select Log Management > Actiontrail Log.
  6. In the search/analytics console, input below query
"event.serviceName": rds and ("event.eventName": ModifyHASwitchConfig or "event.eventName": ModifyDBInstanceHAConfig or "event.eventName": SwitchDBInstanceHA or "event.eventName": ModifyDBInstanceSpec or "event.eventName": MigrateSecurityIPMode or "event.eventName": ModifySecurityIps or "event.eventName": ModifyDBInstanceSSL or "event.eventName": MigrateToOtherZone or "event.eventName": UpgradeDBInstanceKernelVersion or "event.eventName": UpgradeDBInstanceEngineVersion or "event.eventName": ModifyDBInstanceMaintainTime or "event.eventName": ModifyDBInstanceAutoUpgradeMinorVersion or "event.eventName": AllocateInstancePublicConnection or "event.eventName": ModifyDBInstanceConnectionString or "event.eventName": ModifyDBInstanceNetworkExpireTime or "event.eventName": ReleaseInstancePublicConnection or "event.eventName": SwitchDBInstanceNetType or "event.eventName": ModifyDBInstanceNetworkType or "event.eventName": ModifyDBInstanceSSL or "event.eventName": ModifyDTCSecurityIpHostsForSQLServer or "event.eventName": ModifySecurityGroupConfiguration or "event.eventName": CreateBackup or "event.eventName": ModifyBackupPolicy or "event.eventName": DeleteBackup or "event.eventName": CreateDdrInstance or "event.eventName":ModifyInstanceCrossBackupPolicy) | select count(1) as cnt
  1. Create a dashboard and set alert for the query result.

Usage

Run the control in your terminal:

powerpipe control run alicloud_compliance.control.cis_v100_2_15

Snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe control run alicloud_compliance.control.cis_v100_2_15 --share

SQL

This control uses a named query:

manual_control

Tags