steampipe 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;

Schema for azure_mariadb_server

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
administrator_logintextThe administrator's login name of a server.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
auto_grow_enabledtextIndicates whether storage auto grow is enabled for server, or not.
backup_retention_daysbigintSpecifies the backup retention days for the server.
cloud_environmenttextThe Azure Cloud Environment.
earliest_restore_datetimestamp with time zoneSpecifies the earliest restore point creation time.
fully_qualified_domain_nametextThe fully qualified domain name of a server.
geo_redundant_backup_enabledtextIndicates whether geo-redundant backup is enabled for server backup, or not.
idtextA fully qualified resource ID for the resource.
master_service_idtextThe master server id of a replica server.
nametext=The name of the resource.
private_endpoint_connectionsjsonbA list of private endpoint connections on a server.
public_network_accesstextIndicates whether or not public network access is allowed for this server. Valid values are: 'Enabled', 'Disabled'.
regiontextThe Azure region/location in which the resource is located.
replica_capacitybigintThe maximum number of replicas that a master server can have.
replication_roletextThe replication role of the server.
resource_grouptext=The resource group which holds this resource.
sku_capacitybigintThe scale up/out capacity, representing server's compute units.
sku_familytextThe family of hardware.
sku_nametextThe name of the sku.
sku_sizetextThe size code, to be interpreted by resource as appropriate.
sku_tiertextThe tier of the particular SKU. Valid values are: 'Basic', 'GeneralPurpose', 'MemoryOptimized'.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
ssl_enforcementtextIndicates whether SSL enforcement is enabled, or not. Valid values are: 'Enabled', and 'Disabled'.
storage_mbbigintSpecifies the max storage allowed for a server.
subscription_idtext=, !=, ~~, ~~*, !~~, !~~*The Azure Subscription ID in which the resource is located.
tagsjsonbA map of tags for the resource.
titletextTitle of the resource.
typetextThe type of the resource.
user_visible_statetextA state of a server that is visible to user. Valid values are: 'Ready', 'Dropping', 'Disabled'.
versiontextSpecifies 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