Resource Type: Azure > MySQL > Flexible Server

Resource Context

Flexible Server is a part of the MySQL service.

Each Flexible Server lives under a Resource Group.

Controls

The primary controls for Azure > MySQL > Flexible Server are:

• Active
• Approved
• CMDB
• Discovery
• Encryption in Transit
• Minimum TLS Version
• ServiceNow
• Tags

It is also targeted by these controls:

• Azure > CIS v2.0 > 04 - Database Services > 4.04 - MySQL Database > 4.04.01 - Ensure 'Enforce SSL connection' is set to 'Enabled' for Standard MySQL Database Server
• Azure > CIS v2.0 > 04 - Database Services > 4.04 - MySQL Database > 4.04.02 - Ensure 'TLS Version' is set to 'TLSV1.2' for MySQL flexible Database Server
• Azure > CIS v2.0 > 04 - Database Services > 4.04 - MySQL Database > 4.04.03 - Ensure server parameter 'audit_log_enabled' is set to 'ON' for MySQL Database Server
• Azure > CIS v2.0 > 04 - Database Services > 4.04 - MySQL Database > 4.04.04 - Ensure server parameter 'audit_log_events' has 'CONNECTION' set for MySQL Database Server

Category

• Database

In Your Workspace

• Controls by Resource Type report
• Policy Settings by Resource Type report
• Resources by Resource Type report

Developers

Resource Type URI

tmod:@turbot/azure-mysql#/resource/types/flexibleServer

Category URI

tmod:@turbot/turbot#/resource/categories/database

GraphQL

query resource(id: "tmod:@turbot/azure-mysql#/resource/types/flexibleServer") { … }

query resourceActivities(filter: "resourceId:'tmod:@turbot/azure-mysql#/resource/types/flexibleServer'") { … }

mutation createResource(input: { … })

mutation updateResource(input: { … })

CLI

Get Resource

turbot graphql resource --id "tmod:@turbot/azure-mysql#/resource/types/flexibleServer"

Steampipe Query

Get Resource

select * from guardrails_resource where resource_type_uri = 'tmod:@turbot/azure-mysql#/resource/types/flexibleServer';

Get Policy Settings (By Resource ID)

select * from guardrails_policy_setting where filter = 'resourceTypeId:"tmod:@turbot/azure-mysql#/resource/types/flexibleServer"';

Get Resource Notification

select * from guardrails_notification where resource_type_uri = 'tmod:@turbot/azure-mysql#/resource/types/flexibleServer' and notification_type in ('resource_updated', 'resource_created');