AWS Serverless Database pattern-based discovery

  • Release version: Zurich
  • 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 automated identification and mapping of Amazon Aurora Serverless databases within your AWS cloud environment. This capability requires the latest Discovery and Service Mapping Patterns application and adherence to AWS discovery prerequisites to ensure accurate data collection and CMDB population.

    Show full answer Show less

    Data Collection and CMDB Population

    During discovery, the pattern gathers detailed information about serverless database clusters and instances, storing this data in specific CMDB tables:

    • Cloud DataBase Cluster [cmdbciclouddbcluster]: Captures details such as cluster ID, name, FQDN, database engine version, vendor (Amazon), automated backup status and retention, deletion protection status, IAM authentication status, storage encryption, and operational status.
    • Cloud DataBase [cmdbciclouddatabase]: Records the database instance or cluster ID, name, FQDN, engine version, and vendor.
    • Availability Zone [cmdbciavailabilityzone]: Stores availability zone identifiers and names.
    • IP Address [cmdbciipaddress]: Contains IP addresses and netmask information for database clusters.

    Configuration Item Relationships

    The pattern establishes vital relationships between discovered configuration items (CIs) to accurately represent AWS database infrastructure topology, including:

    • Clusters owning databases and IP addresses
    • Databases hosted on AWS datacenters
    • Availability zones containing clusters and databases
    • Hierarchical containment between datacenters, availability zones, clusters, and IP addresses

    AWS Tag Discovery

    The pattern also collects AWS tags associated with serverless databases and clusters, storing these key-value pairs in the Key Value [cmdbkeyvalue] table. Each tag entry references either a database or a cluster CI, enabling enhanced tagging and filtering capabilities within the CMDB.

    Practical Benefits for ServiceNow Customers

    By implementing this pattern-based discovery, ServiceNow customers can:

    • Gain comprehensive visibility into Amazon Aurora Serverless databases across their AWS environments
    • Maintain up-to-date CMDB records with detailed attributes and relationships for accurate service mapping
    • Leverage AWS tags within ServiceNow for improved resource classification and management
    • Support operational and security processes by tracking backup status, deletion protection, IAM authentication, and encryption settings

    Overall, this discovery pattern streamlines cloud database management by automating data capture and relationship mapping, enhancing the reliability and usefulness of CMDB data for cloud infrastructure governance.

    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 AWS 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.