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 automatically detect and map Azure Cosmos DB for PostgreSQL Cluster resources within their cloud environment. This process integrates discovered data into the Configuration Management Database (CMDB) and non-CMDB tables, supporting comprehensive visibility and management of Azure PostgreSQL clusters.
Show less
To ensure accurate discovery, customers must meet Microsoft Azure discovery prerequisites and enable the relevant discovery pattern, which is disabled by default. Activation of patterns is straightforward and does not count as customization, allowing seamless updates.
For Azure GovCloud environments, discovery requires configuring the Azure service account with the appropriate datacenter URL.
Key Features
- Pattern Activation: The Azure - Cosmos DB for PostgreSQL Cluster - Extended Inventory(LP) pattern must be enabled to discover and map resources.
- Data Population: Discovery populates data in both CMDB tables and non-CMDB Azure-specific tables, allowing detailed inventory and management.
- CMDB Tables: The Cloud DataBase Cluster [cmdbciclouddbcluster] table stores essential cluster details such as name, location, status, version, and vendor information.
- Non-CMDB Tables: Azure-specific tables capture extended inventory details, including unique identifiers, resource groups, subscription and tenant IDs, and provisioning state.
- CI Relationships: The pattern establishes relationships linking clusters to Azure resource groups and datacenters, supporting service mapping and impact analysis.
- Tag Discovery: Resource tags are collected and stored in the Key Value [cmdbkeyvalue] table, enabling enhanced filtering and categorization.
Practical Benefits
- Automates discovery of Azure Cosmos DB for PostgreSQL Clusters, reducing manual effort and increasing accuracy.
- Integrates cluster data into the CMDB, facilitating centralized configuration and operational management.
- Supports compliance and governance by reflecting accurate resource states and relationships.
- Enables customers to maintain up-to-date mappings for change management, incident response, and capacity planning.
- Facilitates discovery in Azure GovCloud environments with specific configuration guidance.
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 components 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. |