Skip to main content

vw_sql_server_databases

Creates, updates, deletes, gets or lists a vw_sql_server_databases resource.

Overview​

Namevw_sql_server_databases
TypeView
Idazure.azure_arc_data.vw_sql_server_databases

Fields​

See the SQL Definition (view DDL) for fields returned by this view.

SQL Definition​

SELECT
location as location,
tags as tags,
JSON_EXTRACT(properties, '$.collationName') as "collation_name",
JSON_EXTRACT(properties, '$.databaseCreationDate') as "database_creation_date",
JSON_EXTRACT(properties, '$.compatibilityLevel') as "compatibility_level",
JSON_EXTRACT(properties, '$.sizeMB') as "size_mb",
JSON_EXTRACT(properties, '$.spaceAvailableMB') as "space_available_mb",
JSON_EXTRACT(properties, '$.state') as "state",
JSON_EXTRACT(properties, '$.isReadOnly') as "is_read_only",
JSON_EXTRACT(properties, '$.recoveryMode') as "recovery_mode",
JSON_EXTRACT(properties, '$.databaseOptions') as "database_options",
JSON_EXTRACT(properties, '$.backupInformation') as "backup_information",
JSON_EXTRACT(properties, '$.backupPolicy') as "backup_policy",
JSON_EXTRACT(properties, '$.earliestRestoreDate') as "earliest_restore_date",
JSON_EXTRACT(properties, '$.createMode') as "create_mode",
JSON_EXTRACT(properties, '$.sourceDatabaseId') as "source_database_id",
JSON_EXTRACT(properties, '$.restorePointInTime') as "restore_point_in_time",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.lastDatabaseUploadTime') as "last_database_upload_time",
subscriptionId,
resourceGroupName,
sqlServerInstanceName,
databaseName
FROM azure.azure_arc_data.sql_server_databases
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND sqlServerInstanceName = 'replace-me';