Cloudaware CMDB Application

The Cloudaware CMDB application for ServiceNow imports Cloudaware cloud inventory data into ServiceNow so ITSM teams can use Cloudaware-discovered configuration items in ServiceNow CMDB workflows, reporting, and automation.

The application can be installed from the ServiceNow Store or manually with an XML installation file. In both cases, ServiceNow connects to Cloudaware-provided Google BigQuery export data by using JWT-based authorization and a scheduled Workflow Studio flow.

info

• Audience: ServiceNow administrators, ITSM/CMDB administrators, and Cloudaware administrators
• Outcome: Cloudaware CMDB data is imported into ServiceNow application tables on a scheduled basis

When to Use This Application

Use the Cloudaware CMDB application when you want ServiceNow to maintain a copy of selected Cloudaware CMDB data in ServiceNow tables. This is useful for:

• Making cloud inventory available in ServiceNow CMDB processes
• Enriching ServiceNow workflows with Cloudaware asset context
• Reporting on cloud configuration items from ServiceNow
• Controlling which Cloudaware CI classes are imported into ServiceNow

Installation Options

Choose one of the following setup paths:

• Installation from ServiceNow Store — install the Cloudaware CMDB application directly from the ServiceNow Store, then configure the ServiceNow-to-Google connection and import workflow.
• Manual Installation — install the application with the XML update set provided by Cloudaware, then configure the same connection and workflow components manually.

Prerequisites

Before installing the application, make sure the following prerequisites are ready:

• ServiceNow instance with administrator permissions.
• ServiceNow IntegrationHub Enterprise Pack activated.
• ServiceNow Workflow Studio installed.
• Cloudaware-provided integration credentials:
  • Service account private key
  • .p12 certificate file
  • Project ID
  • Dataset ID
• Access to the Cloudaware CMDB application from the ServiceNow Store or the XML installation file provided by Cloudaware Support.

To request the Cloudaware-provided credentials or installation file, contact Cloudaware Support at support@cloudaware.com.

Configuration Overview

The setup process has three main parts:

1. Install the Cloudaware CMDB application in ServiceNow.
2. Configure ServiceNow-to-Google authorization:
   • Create a JWT key and certificate.
   • Configure a JWT provider with the service account claims.
   • Create an OAuth application registry record.
   • Add the BigQuery read-only OAuth scope.
   • Create OAuth credentials and a connection alias for bigquery.googleapis.com.
3. Configure the Workflow Studio import flow:
   • Run the import settings and fields mapping flow once after installation.
   • Schedule the CI import flow.
   • Set the connection alias, Cloudaware import tables, Project ID, and Dataset ID.
   • Save and activate the workflow.

The recommended import schedule is once per day unless Cloudaware Support provides different guidance for your environment.

Imported Tables

The application creates ServiceNow system tables used to control import settings and field mapping, as well as application tables for imported Cloudaware CI classes.

System tables include:

Label	Table name
Cloudaware CI	x_ca_cmdb_ci
Cloudaware CMDB Schema	x_ca_cmdb_schema
CI Class Import	x_ca_cmdb_ci_class_import
Cloudaware Import Settings	x_ca_cmdb_ci_class_import_settings
Cloudaware Import Fields Mapping	x_ca_cmdb_import_fields_mapping

Application tables include Cloudaware CI classes such as AWS accounts, EC2 instances, EBS volumes, RDS instances, S3 buckets, Lambda functions, load balancers, security groups, and related cloud resources.

note

Administrators can disable imports for specific application tables in Cloudaware Import Settings (x_ca_cmdb_ci_class_import_settings) by setting Active to False.

Verify Data Upload Status

After activating the workflow, allow time for ServiceNow to import data. To review import settings and upload status, open the Cloudaware Import Settings table directly in the ServiceNow instance:

https://YOURINSTANCE.service-now.com/x_ca_cmdb_ci_class_import_settings.do

Replace YOURINSTANCE with the ServiceNow instance ID.

Related

• Installation from ServiceNow Store
• Manual Installation