Amazon Relational Database Service (Amazon RDS) discovery

  • Release version: Washingtondc
  • Updated February 1, 2024
  • 3 minutes to read

    • The ServiceNow® Discovery application uses the Amazon AWS Relational Database Service discovery pattern to find AWS RDS components.

    Amazon Relational Database Service (RDS) is a managed relational database service by Amazon Web Services (AWS). It enables users to easily create and manage relational database instances in the cloud.

    Discovery uses the discovery pattern to run horizontal discovery, events discovery, and tags discovery. The pattern uses a set of Amazon REST APIs to find the RDS components.

    The ServiceNow AI Platform supports Amazon Commercial Cloud Services (C2S) for discovery and cloud governance. C2S is the government program that brings AWS into the Intelligence Community.

    Visit the ServiceNow Store website to view all the available apps and for information about submitting requests to the store. For cumulative release notes information for all released apps, see the ServiceNow Store version history release notes.

    Prerequisites

    • Install the Discovery and Service Mapping Patterns application from the ServiceNow Store.
    • On the ServiceNow AI Platform, configure AWS credentials, using a secret key and an access key.
    • Create a service account. Set the Account ID to the Amazon account ID to which RDS belongs. Use the Account ID as it appears in the AWS Management Console.
    • Set read-only permissions for these REST APIs:
      • https://rds.<REGION>.amazonaws.com/?Action=DescribeDBInstances
      • https://rds.<REGION>.amazonaws.com/?Action=DescribeDBInstances&DBInstanceIdentifier=<input_object_id> for events discovery
      • https://tagging.<REGION>.amazonaws.com/ for tags discovery
    • Ensure to place the MID Server inside the Amazon cloud.
    • For Cloud Discovery, download the Discovery and Service Mapping pattern from the ServiceNow Store.
    • When installing the MID Server, ensure that the host machine meets or exceeds the MID Server system requirements published on the ServiceNow documentation site.

    Verify the REST API Permissions

    Download the Cloud Discovery patterns spreadsheet so you can grant user permissions required for running the Discovery patterns. In addition to permissions, the spreadsheet also includes useful information such as pattern names, types, CI Classes, and links to vendor documentation. New patterns are available quarterly, so check periodically to be sure you have the latest version of the spreadsheet.

    Note:
    You can test the AWS REST APIs using Postman API platform. For more information, see the How to test AWS REST API using POSTMAN [KB0782183] article in the Now Support Knowledge Base.

    Support for AWS services in the China region

    The latest version of Discovery and Service Mapping Patterns supports discovering AWS services in the China region. You can discover these services on the ServiceNow AI Platform, starting from Xanadu Patch 3 and Washington DC Patch 9 instances.

    Discovering AWS services in the China region requires using a datacenter URL when setting up an AWS service account. For example: https://organizations.cn-northwest-1.amazonaws.com.cn.

    • To learn more about AWS master account and sub-account support in the China region, see KB1704526.
    • To identify AWS patterns supported in the China region, refer to the Cloud Discovery patterns spreadsheet. The AWS China Region Support column has a Yes value for supported patterns.

    Data collected by Discovery during horizontal discovery

    The discovered data includes the following tables and fields.

    Table and field Description
    Cloud Database [cmdb_ci_cloud_database]
    Category [category] Class of the database. Includes templates for CPU and memory.
    Object ID [object_id] Unique resource ID that identifies each logical datacenter (LDC).
    Fully qualified domain name [fqdn] Address of the database endpoint. The DNS name.
    TCP Port [tcp_port] Port of the database endpoint.
    Name [name] Name of the database.
    Version [version] Version of the database.
    Type [type] Type of the database. Can be one of the following: Amazon Aurora, PostgreSQL, MySQL, MariaDB, Oracle Database, SQL Server.
    Operational Status [operational_status] Status of the database.
    IP Address [ip_address] IP address of the Fully Qualified Domain Name (FQDN).
    Vendor [vendor] The vendor, Amazon.
    IP Adress [cmdb_ci_ip_address]
    IP Address [ip_address] IP address of the database endpoint.
    Name [name] Name of the database endpoint.
    Fully qualified domain name [fqdn] Address of the database endpoint. The DNS name.
    Category [category] Class of the database. Includes templates for CPU and memory.
    Netmask [netmask] IP netmask.
    Operational Status [operational_status] Status of the IP address.