Control: Azure > SQL > Database > Discovery

Discover all Azure SQL database resources and add them to the CMDB.

The Discovery control is responsible for finding resources of a specific type. It periodically searches for new resources and saves them to the CMDB. Once discovered, resources are then responsible for tracking changes to themselves through the CMDB control.

Note: Discovery and CMDB controls also use the Regions policy associated with the resource. If the region is not in Azure > SQL > Database > Regions policy, the CMDB control will delete the resource from the CMDB.

Resource Types

This control targets the following resource types:

Azure > SQL > Server

Policies

The following policies can be used to configure this control:

Azure > SQL > Database > CMDB

This control type relies on these other policies when running actions:

Azure > SQL > Database > Regions

Permissions

Cloud permissions used by this control and its actions:

microsoft.sql/servers/databases/read

In Your Workspace

Developers

Control Type URI

tmod:@turbot/azure-sql#/control/types/databaseDiscovery

Category URI

tmod:@turbot/turbot#/control/categories/cmdbDiscovery

GraphQL

query controlType(id: "tmod:@turbot/azure-sql#/control/types/databaseDiscovery") { … }

query controls(filter: "controlTypeId:'tmod:@turbot/azure-sql#/control/types/databaseDiscovery'") { … }

CLI

Get Controls

turbot graphql controls --filter "controlTypeId:tmod:@turbot/azure-sql#/control/types/databaseDiscovery"