AWS Serverless Database pattern-based discovery

  • Release version: Yokohama
  • Updated January 2, 2025
  • 2 minutes to read
    • Summarize
    Summarized using AI
    This content was generated using new OpenAI-powered functionality. Results are provided on an as is basis and are not guaranteed to be accurate or complete.

    Summary of AWS Serverless Database pattern-based discovery

    The AWS Serverless Database pattern-based discovery in ServiceNow enables customers to automatically discover and map Amazon Aurora Serverless databases within their AWS cloud environments. This discovery populates critical configuration data into the CMDB (Configuration Management Database), helping organizations maintain accurate, up-to-date visibility of their serverless database resources. To use this pattern effectively, customers should ensure they meet AWS discovery prerequisites and have the latest version of the Discovery and Service Mapping Patterns application installed from the ServiceNow Store.

    Show full answer Show less

    Key Features

    • Discovery of Aurora Serverless Clusters and Databases: Collects detailed information about database clusters and instances, including identifiers, names, FQDNs, engine versions, and vendor details.
    • CMDB Population: Discovers and stores data in several CMDB tables such as Cloud DataBase Cluster, Cloud DataBase, Availability Zone, IP Address, and Key Value tables for tags.
    • Detailed Attributes Captured: For clusters, attributes include automated backups status and retention, deletion protection, IAM authentication status, storage encryption, and operational status.
    • Relationship Mapping: Automatically creates relationships between discovered resources, such as clusters hosting databases, hosting on AWS datacenters and availability zones, and ownership of IP addresses.
    • AWS Tag Discovery: Captures AWS tags associated with databases and clusters, storing them in the Key Value table linked to the relevant configuration items.

    Practical Benefits for ServiceNow Customers

    • Enables comprehensive visibility into AWS Aurora Serverless database deployments through automated discovery, reducing manual data entry and errors.
    • Improves asset and configuration management by capturing operational and security-related attributes such as deletion protection and IAM authentication.
    • Supports accurate impact analysis and service mapping through detailed CI relationships.
    • Facilitates governance and compliance by capturing AWS tags, which can be used for reporting and cost allocation.
    • Allows customers to maintain an up-to-date CMDB that reflects dynamic serverless database environments for better operational decision-making.

    Discovery and Service Mapping Patterns finds Amazon Aurora Serverless databases 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 AWS discovery prerequisites section in Amazon AWS Cloud components discovery using patterns.

    Data collected by Discovery during horizontal discovery

    Discovery populates the data in the CMDB when running the Amazon AWS Serverless Database pattern.

    Table 1. Cloud DataBase Cluster [cmdb_ci_cloud_db_cluster]
    Field Description
    Cluster ID [cluster_id] User-supplied identifier for the DB cluster.
    Name [name] Name of the database cluster. If a database cluster name isn't provided, the value is the same as the Cluster ID.
    Fully qualified domain name [fqdn] Fully qualified domain name (FQDN) for the DB cluster.
    Cluster Version [cluster_version] Database engine version number.
    Vendor [vendor] Database vendor. Value is set to Amazon.
    Automated Backups [automated_backup] Indicates whether automated backups are enabled and the retention period.

    Possible values are either Disabled or Enabled (X Days), where X represents the backup retention period in days.
    Deletion Protection Enabled [deletion_protection_enabled] Indicates whether deletion protection is enabled for the DB cluster. Possible values are true or false.
    • true: Deletion protection is enabled and the database cannot be deleted
    • false: Deletion protection is disabled
    IAM Authentication Enabled [iam_authentication_enabled] Indicates whether AWS Identity and Access Management (IAM) database authentication is enabled. Possible values are true or false.
    • true: IAM authentication is enabled and you can use IAM credentials to authenticate to the database
    • false: IAM authentication is disabled
    Storage Encrypted [storage_encrypted] Indicates whether the DB cluster storage is encrypted.
    Operational status [operational_status] Operational status of the cluster. Default value is Operational.
    Table 2. Cloud DataBase [cmdb_ci_cloud_database]
    Field Description
    Object ID [object_id] Database instance identifier or Aurora Serverless cluster identifier.
    Name [name] Name of the database instance or Aurora Serverless cluster.
    Fully qualified domain name [fqdn] Fully qualified domain name (FQDN) for the DB cluster.
    Version [version] Database engine version number.
    Vendor [vendor] Database vendor. Value is set to Amazon.
    Table 3. Availability Zone [cmdb_ci_availability_zone]
    Field Description
    Object ID [object_id] Availability zone name.
    Name [name] Availability zone name.
    Table 4. IP Address [cmdb_ci_ip_address]
    Field Description
    Netmask [netmask] Netmask for the IP address. Value is set to 0.0.0.0.
    Name [name] IP address of the database cluster.

    CI relationships

    The Amazon AWS Serverless Database pattern creates these relationships to support AWS database discovery.

    CI Relationship CI
    Cloud DataBase Cluster [cmdb_ci_cloud_db_cluster] Cluster of::Cluster Cloud DataBase [cmdb_ci_cloud_database]
    Cloud DataBase [cmdb_ci_cloud_database] Hosted on::Hosts AWS Datacenter [cmdb_ci_aws_datacenter]
    Cloud DataBase Cluster [cmdb_ci_cloud_db_cluster] Hosted on::Hosts AWS Datacenter [cmdb_ci_aws_datacenter]
    Availability Zone [cmdb_ci_availability_zone] Contains::Contained by Cloud DataBase Cluster [cmdb_ci_cloud_db_cluster]
    Availability Zone [cmdb_ci_availability_zone] Contains::Contained by Cloud DataBase [cmdb_ci_cloud_database]
    AWS Datacenter [cmdb_ci_aws_datacenter] Contains::Contained by Availability Zone [cmdb_ci_availability_zone]
    Cloud DataBase Cluster [cmdb_ci_cloud_db_cluster] Owns::Owned by IP Address [cmdb_ci_ip_address]
    Cloud DataBase [cmdb_ci_cloud_database] Owns::Owned by IP Address [cmdb_ci_ip_address]
    Key Value [cmdb_key_value] References Cloud DataBase Cluster [cmdb_ci_cloud_db_cluster]
    Key Value [cmdb_key_value] References Cloud DataBase [cmdb_ci_cloud_database]

    AWS Tag discovery

    The Amazon AWS Serverless Database pattern collects tags and populates them in two entries in the Key Value [cmdb_key_value] table. One entry references the Cloud DataBase table, the other entry references the Cloud DataBase Cluster table.

    Table 5. Key Value [cmdb_key_value]
    Field Description
    Key [key] Tag name.
    Value [value] Tag value.
    Configuration item [configuration_item] References the Cloud DataBase [cmdb_ci_cloud_database] table.
    Configuration item [configuration_item] References the Cloud DataBase Cluster [cmdb_ci_cloud_db_cluster] table.