steampipe plugin install azuresteampipe plugin install azure

Table: azure_mariadb_server - Query Azure MariaDB Servers using SQL

Azure MariaDB Server is a fully managed relational database service provided by Microsoft Azure. It is a scalable and flexible service that allows users to deploy highly available MariaDB databases in the cloud. Azure MariaDB Server provides automatic backups, patching, monitoring, and scaling of resources to ensure optimal performance and reliability.

Table Usage Guide

The azure_mariadb_server table offers insights into the configuration and status of Azure MariaDB Server instances. As a database administrator, you can utilize this table to monitor and manage your MariaDB instances, including their performance, security settings, and backup configurations. This table is also beneficial for auditing purposes, allowing you to track changes and maintain compliance with organizational policies and standards.

Examples

Basic info

Explore the overall status and location of your Azure MariaDB servers. This query is useful in gaining insights into the versions, pricing tiers, visibility, and geographical distribution of your databases, aiding in resource management and cost optimization.

select
  name,
  version,
  sku_name,
  user_visible_state,
  region,
  resource_group
from
  azure_mariadb_server;

select
  name,
  version,
  sku_name,
  user_visible_state,
  region,
  resource_group
from
  azure_mariadb_server;

List servers with Geo-redundant backup disabled

Discover the segments that have disabled geo-redundant backup, a feature essential for data protection and disaster recovery, on their servers. This assists in identifying potential vulnerabilities in the system and aids in enhancing data security.

select
  name,
  version,
  region,
  geo_redundant_backup_enabled
from
  azure_mariadb_server
where
  geo_redundant_backup_enabled = 'Disabled';

select
  name,
  version,
  region,
  geo_redundant_backup_enabled
from
  azure_mariadb_server
where
  geo_redundant_backup_enabled = 'Disabled';

List servers with SSL enabled

Identify instances where your Azure MariaDB servers have SSL enabled. This is useful for ensuring that your data transmissions are secure and encrypted.

select
  name,
  version,
  region,
  ssl_enforcement
from
  azure_mariadb_server
where
  ssl_enforcement = 'Enabled';

select
  name,
  version,
  region,
  ssl_enforcement
from
  azure_mariadb_server
where
  ssl_enforcement = 'Enabled';

List servers with backup retention days greater than 90 days

Determine the areas in which servers on Azure MariaDB are configured to retain backups for more than 90 days. This can be useful for identifying servers with potentially excessive storage use or for compliance purposes.

select
  name,
  version,
  region,
  backup_retention_days
from
  azure_mariadb_server
where
  backup_retention_days > 90;

select
  name,
  version,
  region,
  backup_retention_days
from
  azure_mariadb_server
where
  backup_retention_days > 90;

Control examples

Schema for azure_mariadb_server

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
administrator_login	text		The administrator's login name of a server.
akas	jsonb		Array of globally unique identifier strings (also known as) for the resource.
auto_grow_enabled	text		Indicates whether storage auto grow is enabled for server, or not.
backup_retention_days	bigint		Specifies the backup retention days for the server.
cloud_environment	text		The Azure Cloud Environment.
earliest_restore_date	timestamp with time zone		Specifies the earliest restore point creation time.
fully_qualified_domain_name	text		The fully qualified domain name of a server.
geo_redundant_backup_enabled	text		Indicates whether geo-redundant backup is enabled for server backup, or not.
id	text		A fully qualified resource ID for the resource.
master_service_id	text		The master server id of a replica server.
name	text	=	The name of the resource.
private_endpoint_connections	jsonb		A list of private endpoint connections on a server.
public_network_access	text		Indicates whether or not public network access is allowed for this server. Valid values are: 'Enabled', 'Disabled'.
region	text		The Azure region/location in which the resource is located.
replica_capacity	bigint		The maximum number of replicas that a master server can have.
replication_role	text		The replication role of the server.
resource_group	text	=	The resource group which holds this resource.
sku_capacity	bigint		The scale up/out capacity, representing server's compute units.
sku_family	text		The family of hardware.
sku_name	text		The name of the sku.
sku_size	text		The size code, to be interpreted by resource as appropriate.
sku_tier	text		The tier of the particular SKU. Valid values are: 'Basic', 'GeneralPurpose', 'MemoryOptimized'.
ssl_enforcement	text		Indicates whether SSL enforcement is enabled, or not. Valid values are: 'Enabled', and 'Disabled'.
storage_mb	bigint		Specifies the max storage allowed for a server.
subscription_id	text		The Azure Subscription ID in which the resource is located.
tags	jsonb		A map of tags for the resource.
title	text		Title of the resource.
type	text		The type of the resource.
user_visible_state	text		A state of a server that is visible to user. Valid values are: 'Ready', 'Dropping', 'Disabled'.
version	text		Specifies the server version.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- azure

You can pass the configuration to the command with the --config argument:

steampipe_export_azure --config '<your_config>' azure_mariadb_server