SQL Configuration Logging

Log in to the Google Cloud Platform Console.

Scroll down the left navigation panel and select the “Logging” option under the “STACKDRIVER.”

On the “Stack driver Logging” page, click on the “Logs-based metrics” option./br>

On the “Logs-based metric” page, search the “System metrics” and “User-defined metrics” and check whether any metrics is there for “SQL Configuration Logging.” If no such metrics is present then the logging and log alerts does not exist for SQL configuration changes.

Repeat steps number 2 - 4 to check other GCP accounts.

Navigate to the “Logging” option under the “STACKDRIVER”, choose the “Logbased metrics” and click on the “CREATE METRIC” button at the top.

On the “Metric editor” tab, enter the “Name” and “Description” accordingly and enter the field name under the “Label” as per the requirements and click on the “Done” button to save the “Label.”

Click on the “Create metric” button at the bottom to make the changes.

On the “Logs-based metrics”, under the “User-defined metrics” click on the 3 dots next to the newly created “SQL Configuration Logging” metric and click on the “create alert from metric.”

On the “Create alert” page, select the “Aggregator” as per the requirement and select the “Configuration” from the dropdown menu accordingly.

Enter the “Condition, Threshold and Minute” of the above “Configuration” accordingly and click on the “Save” button to make the changes.

Once the settings are “Saved”, enter the name of the alarm and select “Policy triggers” condition from the dropdown menu.

Click on the “Save” button at the bottom to make the chanes.

Repeat steps number 6 - 14 to ensure that log alerts exist for SQL configuration changes.