Skip to main content

databases_inaccessible_by_servers

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

Overview

Namedatabases_inaccessible_by_servers
TypeResource
Idazure.sql.databases_inaccessible_by_servers

Fields

NameDatatypeDescription
identityobjectAzure Active Directory identity configuration for a resource.
kindstringKind of database. This is metadata used for the Azure portal experience.
locationstringResource location.
managedBystringResource that manages the database.
propertiesobjectThe database's properties.
skuobjectAn ARM Resource SKU.
tagsobjectResource tags.

Methods

NameAccessible byRequired ParamsDescription
listSELECTresourceGroupName, serverName, subscriptionIdGets a list of inaccessible databases in a logical server

SELECT examples

Gets a list of inaccessible databases in a logical server

SELECT
identity,
kind,
location,
managedBy,
properties,
sku,
tags
FROM azure.sql.databases_inaccessible_by_servers
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';