Azure Cosmos DB for PostgreSQL Cluster pattern-based discovery
Summarize
Summary of Azure Cosmos DB for PostgreSQL Cluster pattern-based discovery
The Azure Cosmos DB for PostgreSQL Cluster pattern-based discovery enables ServiceNow customers to identify and map Azure Cosmos DB for PostgreSQL clusters within their cloud environments. This capability is part of the Discovery and Service Mapping Patterns application, which requires the latest version for optimal results. The discovery process populates both CMDB and non-CMDB tables, providing detailed information about the clusters and their associated Azure resources.
Show less
Key Features
- Pattern Activation: The Azure Cosmos DB for PostgreSQL Cluster discovery pattern is disabled by default and must be enabled. Starting with Visibility Content version 6.28.0, activating or deactivating patterns will not be treated as customizations, ensuring updates apply smoothly.
- Azure GovCloud Support: When discovering Azure GovCloud (US) accounts, configuration requires specifying a datacenter URL in the Azure service account setup.
- Data Population: The discovery pattern populates data in:
- Non-CMDB Table: Stores detailed resource attributes such as object ID, SKU, location, resource group, subscription and tenant IDs, and provisioning state in the cmdbazurecosmosdbforpostgresqlclustercluster table.
- CMDB Tables: Information about the cloud database clusters is stored in the cmdbciclouddbcluster table, including cluster name, location, ID, status, version, and vendor details.
- Tag Discovery: Azure resource tags are collected and stored in the cmdbkeyvalue table, facilitating enhanced classification and filtering.
- CI Relationships: The discovery creates relationships linking cloud database clusters to resource groups and Azure datacenters, supporting comprehensive dependency mapping and impact analysis.
Practical Implications for ServiceNow Customers
By enabling this pattern, customers can gain automated visibility into their Azure Cosmos DB for PostgreSQL clusters, ensuring accurate and current configuration data within the CMDB. This supports improved cloud resource management, operational monitoring, and impact analysis. Customers should verify Azure discovery prerequisites and configure discovery schedules appropriately, especially when working with Azure GovCloud. The segregation of discovered data into CMDB and non-CMDB tables allows detailed inventory and flexible usage in ServiceNow workflows.
Discovery and Service Mapping Patterns finds Azure services on your cloud environment. Discovering some of these resources may require updating to the latest version of the Discovery and Service Mapping Patterns application from the ServiceNow Store.
Pattern-based discovery and mapping requirements
- Verify the Microsoft Azure discovery prerequisites
- For more information, see the prerequisites section in Microsoft Azure Cloud discovery using patterns.
- Enable the relevant pattern
- The pattern for this service is disabled by default. Starting with Visibility Content version 6.28.0, activating or deactivating a pattern won't be considered a customization, and it will continue to receive updates. Patterns that were previously activated or deactivated will reset to the latest predefined version after upgrading while retaining the last active field value. For more information on enabling patterns, see Activate a disabled pattern.
- 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.
Discovery and Service Mapping Patterns application populates data in both CMDB and non-CMDB tables.
Data stored in non-CMDB tables
Discovery and Service Mapping Patterns application populates data in the non-CMDB table when running the Azure - Cosmos DB for PostgreSQL Cluster - Extended Inventory(LP) pattern.
You can review the non-CMDB Azure tables by navigating to . You can also search the navigation filter for the specific pattern name.
| Field | Description |
|---|---|
| Object Id [object_id] | The unique identifier of the resource. |
| Kind [kind] | The specific kind or stock-keeping unit (SKU) of the resource. |
| DC Location [location] | The Azure region where the resource is deployed. |
| Resource Group [resource_group] | The name of the Azure resource group containing the resource. |
| Subscription Id [subscription_id] | The unique identifier for the Azure subscription. |
| Tenant Id [tenant_id] | The universally unique identifier (UUID) of the Azure Active Directory tenant associated with the resource. |
| Provisioning State [provisioning_state] | The current state of the provisioning process for the resource. |
| Configuration Item [configuration_item] | References the Cloud DataBase Cluster [cmdb_ci_cloud_db_cluster] table. |
Data stored in CMDB tables
Discovery and Service Mapping Patterns application populates data in the CMDB when running the Azure - Cosmos DB for PostgreSQL Cluster - Extended Inventory(LP) pattern.
| Field | Description |
|---|---|
| Name [name] | The name assigned to the resource. |
| Location [location] | The Azure region where the resource is deployed. |
| Cluster ID [cluster_id] | The unique identifier of the resource. |
| Cluster Status [cluster_status] | The current operational status of the cluster. |
| Cluster Version [cluster_version] | The version number of the cluster software. |
| Install Status [install_status] | Install status of the resource. Default value is Installed. |
| Operational status [operational_status] | Operational status of the resource. Default value is Operational. |
| Description [short_description] | Type of resource. The value is set to microsoft.dbforpostgresql/servergroupsv2. |
| Vendor [vendor] | Name of vendor: Microsoft. |
CI relationships
The Azure - Cosmos DB for PostgreSQL Cluster - Extended Inventory(LP) pattern creates these relationships to support Azure Cosmos DB for PostgreSQL Cluster discovery.
| CI | Relationship | CI |
|---|---|---|
| Resource Group [cmdb_ci_resource_group] | Contains::Contained by | Cloud DataBase Cluster [cmdb_ci_cloud_db_cluster] |
| Cloud DataBase Cluster [cmdb_ci_cloud_db_cluster] | Hosted on::Hosts | Azure Datacenter [cmdb_ci_azure_datacenter] |
| Azure Cosmos DB for PostgreSQL Cluster [cmdb_azure_cosmos_db_for_postgresql_cluster_cluster] | References | Cloud DataBase Cluster [cmdb_ci_cloud_db_cluster] |
Azure tag discovery
| Field | Description |
|---|---|
| Key [key] | Tag name. |
| Value [value] | Tag value. |