---
sourceDocument: Brazil IT Operations Management
sourceDocumentLink: https://www.servicenow.com/docs/r/it-operations-management

 Release :

    - brazil

ft:locale :

    - en-US

ft:publication_title :

    - Brazil IT Operations Management

ft:clusterId :

    - itom

bundleId :

    - itom

workflow :

    - Technology


---

# Azure SQL Server

# Azure SQL Server pattern-based discovery {#ariaid-title1}

Release version: Brazil  
Updated June 17, 2026  
![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read  
Discovery and Service Mapping Patterns finds Azure SQL Server virtual machines in your cloud environment. Discovering some of these resources might require updating to the latest version of the Discovery and Service Mapping Patterns application from the ServiceNow Store.

## Pattern-based discovery and mapping requirements {#azure-sql-server-pattern__section_rpj_fj2_bgc}

Verify the Microsoft Azure discovery prerequisites
:   For more information, see the prerequisites section in [Microsoft Azure Cloud discovery using patterns](https://www.servicenow.com/docs/s9SHZxzsnOR4TZKkvmJG9A "Discovery uses multiple patterns to discover components of the Microsoft Azure Cloud deployment during horizontal discovery. Discovering some of these resources might require updating to the latest version of the Discovery and Service Mapping Patterns application from the ServiceNow Store.").

Configure the Discovery schedule to support GovCloud
:   Discovering Azure GovCloud (US) accounts requires using a datacenter URL when setting up an Azure service account. For more information, see [Set up Azure service accounts](https://www.servicenow.com/docs/_5QfXcWcH8tWf~lcyLEaIg "Create and configure cloud service accounts at ServiceNow AI Platform for the corresponding Microsoft Azure accounts.").{#azure-sql-server-pattern__configure-govcloud-azure-dd}
{#azure-sql-server-pattern__configure-govcloud-azure-dd}

## Data collected by Discovery during horizontal discovery {#azure-sql-server-pattern__section_ggp_ql2_bgc}

Discovery populates the data in the CMDB when running the Azure - SQL Server (LP) pattern.  
{#azure-sql-server-pattern__table_mkf_2hc_dgc__entry__2}

| Field | Description |
|-|-|
| Object ID \[object_id\] | A unique identifier, allocated by Azure for this resource. |
[Table 1. Virtual Machine Instance \[cmdb_ci_vm_instance\]]

{#azure-sql-server-pattern__table_mkf_2hc_dgc}

## CI relationships and references {#azure-sql-server-pattern__section_dc4_ghc_dgc}

The Azure - SQL Server (LP) pattern creates the following relationships and references to support Azure SQL Server discovery. References link to records in other tables and don't appear in the CI Relationship \[cmdb_rel_ci\] table.  
{#azure-sql-server-pattern__table_bkg_jhc_dgc__entry__3}

| CI | Relationship | CI |
|-|-|-|
| Virtual Machine Instance \[cmdb_ci_vm_instance\] | Hosted on::Hosts | Azure Datacenter \[cmdb_ci_azure_datacenter\] |
[Table 2. CI relationships]

{#azure-sql-server-pattern__table_bkg_jhc_dgc}  
{#azure-sql-server-pattern__table_ci_references__entry__3}

| CI | Field | Referenced CI |
|-|-|-|
| Key Value \[cmdb_key_value\] | Configuration item \[configuration_item\] | Virtual Machine Instance \[cmdb_ci_vm_instance\] |
[Table 3. CI references]

{#azure-sql-server-pattern__table_ci_references}

## Azure License discovery {#azure-sql-server-pattern__section_lyw_zhc_dgc}

The pattern extension section discovers SQL Server license information and populates the license type in the Key Value \[cmdb_key_value\] table.  
{#azure-sql-server-pattern__table_ojy_vss_5hc__entry__2}

| Field | Description |
|-|-|
| Key \[key\] | SQL_Server_License_Type_automatic |
| Value \[value\] | The license model, which is one of the following: * Azure Hybrid Benefit: BYOL * Pay-as-you-go licensing: License Included {#azure-sql-server-pattern__ul_license_values} |
| Configuration item \[configuration_item\] | References the Virtual Machine Instance \[cmdb_ci_vm_instance\] table. |
[Table 4. Key Value \[cmdb_key_value\]]

{#azure-sql-server-pattern__table_ojy_vss_5hc}