Skip to main content
Skip table of contents

Installing From The ServiceNow Store

This guide explains how to configure the Cloudaware CMDB application when installed from the ServiceNow Store. Cloudaware creates custom tables in ServiceNow and populates them with CMDB data. Check the ServiceNow instance compatibility here.

Summary

  1. Get credentials for ServiceNow-to-Google from Cloudaware at support@cloudaware.com.

  2. Install the Cloudaware app from the ServiceNow Store.

  3. Configure the application in ServiceNow:

    • Set up ServiceNow-to-Google integration

    • Configure the workflow in Workflow Studio

For detailed setup instructions, refer to the in-depth guidelines below.

Install Cloudaware CMDB application

  1. Log in to the ServiceNow instance.

  2. Navigate to System Applications → select 'Available to Obtain From Store'.

  3. Find the application Cloudaware CMDB. Click View detailsGet.

Configure Cloudaware CMDB application in ServiceNow

Cloudaware provides credentials for setting up ServiceNow-to-Google integration. This integration is required for JWT-based authorization. The configured JWT Provider will be used as the Connection when creating the data update workflow.

Set up ServiceNow-to-Google integration

  1. Configure JWT Key and Certificate.

    a. Create a JWT Key:

    • Navigate to All → System OAuth → JWT Keys.

      Cloudaware CMDB App for ServiceNow - SNow-to-Google - JWT keys.png

    • Click New and fill out the form:

      Cloudaware CMDB App for ServiceNow - SNow-to-Google - JWT key details.png

      WHERE
      Name: a meaningful name, e.g. Google JWT Key
      Signing Key: notasecret
      Signing Keystore: click the magnifier icon to create a new keystore (see step b below)

    b. Create a JWT Certificate that will serve as a signing keystore:

    • In the pop-up window, click New.

    • Fill out the form:

      Cloudaware CMDB App for ServiceNow - SNow-to-Google - JWT certificate details.png

      WHERE
      Name: a meaningful name, e.g. Google JWT Certificate
      Type: Java Key Store
      Key store password: notasecret

    • Click the paperclip icon, then Choose file to attach the .p12 certificate provided by Cloudaware.

      Cloudaware CMDB App for ServiceNow - SNow-to-Google - JWT certificate - attach file.png

      Click Submit.

    c. Return to the JWT Key form. Under Signing Keystore, select the created certificate (Google JWT Certificate).

    Cloudaware CMDB App for ServiceNow - SNow-to-Google - select Google JWT certificate.png

    Click Submit.

  2. Configure JWT Provider.

    Navigate to All → System OAuth → JWT Providers:

    Cloudaware CMDB App for ServiceNow - SNow-to-Google - JWT providers.png


    Click New and fill out the form:

    Cloudaware CMDB App for ServiceNow - SNow-to-Google - JWT provider details.png

    WHERE
    Name: a meaningful name, e.g. Google JWT Certificate
    Signing Configuration: click the magnifier icon (Lookup using list) and select the configured Google JWT Key from the list

    Cloudaware CMDB App for ServiceNow - SNow-to-Google - select Google JWT key.png


    Open the JWT provider record (in this example, Google JWT Provider) to edit settings. Select the tab 'Standard Claims'. Add the following claims:
    iss - string - Service Account email address provided by Cloudaware
    sub - string - Service Account email address provided by Cloudaware
    aud - string - https://oauth2.googleapis.com/token

    Cloudaware CMDB App for ServiceNow - SNow-to-Google - JWT provider - standard claims.png

    Click Update.

  3. Configure Application Registry.

    Navigate to All → System OAuth → Application Registry.

    Cloudaware CMDB App for ServiceNow - SNow-to-Google - application registry.png


    Click New → select 'Connect to a third party OAuth Provider' from the list. Fill out the form:

    Cloudaware CMDB App for ServiceNow - SNow-to-Google - application registry details.png

    WHERE
    Name: a meaningful name, e.g. Google JWT
    Client ID: notneeded
    Client secret: notneeded
    Default grant type: JWT Bearer
    Token: https://oauth2.googleapis.com/token
    Refresh Token Lifespan: 10

    Click Submit.

    Click on the name of OAuth Entity Profile (in this example, Google JWT default_profile) to edit settings:

    Cloudaware CMDB App for ServiceNow - SNow-to-Google - application registry - oauth entity profile.png


    Next to the JWT Provider, click the magnifier icon (Lookup using list) and select the Google JWT Provider from the list.

    Click Update.

  4. Go back to JWT Providers. Select the configured Google JWT Provider from the list.

    Select the tab 'Custom Claims'. Add a new claim: scope - string - https://www.googleapis.com/auth/bigquery.readonly

    Cloudaware CMDB App for ServiceNow - SNow-to-Google - JWT provider - custom claims.png

    Click Update.

  5. Configure Credentials.

    Navigate to All → Connections & Credentials → Credentials.

    Cloudaware CMDB App for ServiceNow - SNow-to-Google - connections - credentials.png


    Click New → select 'Auth 2.0 Credentials' from the list. Fill out the form:

    Cloudaware CMDB App for ServiceNow - SNow-to-Google - connections - credentials details.png

    WHERE
    Name: a meaningful name, e.g. Google JWT Credentials
    OAuth Entity Profile: select the configured OAuth Entity Profile (in this example, Google JWT default_profile)

    Click Update. Click Get OAuth Token to test the connection.

    Navigate to All → Connections & Credentials Aliases. Click New.

    Set the alias as Google JWT and save it by right-clicking on the upper grey menu.

    Cloudaware CMDB App for ServiceNow - SNow-to-Google - connections - save aliases.png


    In the section that appears, click New to create a HTTP(s) Connection.

    Cloudaware CMDB App for ServiceNow - SNow-to-Google - connections - https connection.png


    Fill out the form:

    Cloudaware CMDB App for ServiceNow - SNow-to-Google - connections - https connection details.png

    WHERE
    Name: meaningful name, e.g. Google JWT Connection
    Credential: select Google JWT Credentials
    URL builder: check this box
    Host: bigquery.googleapis.com

    Click Submit.

Configure the workflow

  1. Navigate to All → Workflow Studio:

    Cloudaware CMDB App for ServiceNow - configure the workflow - workflow studio.png

  2. Open 'Flows'. Select the Update Import Settings and Fields Mapping flow.

    Cloudaware CMDB App for ServiceNow - configure the workflow - update import settings and fields mapping (flow).png


    Click TestRun test (required once after installation):

    Cloudaware CMDB App for ServiceNow - configure the workflow - test run.png

  3. Go back to all flows. Set the Updated column to descending order. Select the Import All CI Data from Cloudaware flow from the list.

    Cloudaware CMDB App for ServiceNow - configure the workflow - import all CI data (flow).png


  4. In TRIGGER, click on the section to schedule a trigger. Select 'Scheduled' → Daily* → set the time:

    Cloudaware CMDB App for ServiceNow - configure the workflow - schedule a trigger 1.png

    Cloudaware CMDB App for ServiceNow - configure the workflow - schedule a trigger 2.png

    Click Done.

*The recommended frequency is once per day.

  1. In ACTIONS, click Set Flow Variables to select:

    Cloudaware CMDB App for ServiceNow - configure the workflow - set flow variables.png

    WHERE
    Connection Alias – select the Connections & Credentials Aliases configured in the section ‘Set up ServiceNow-to-Google integration’ (in this example, Google JWT)
    Cloudaware Import Settings Table – the value is auto-populated as this is a system table
    Cloudaware Import Fields Mapping Table – the value is auto-populated as this is a system table
    Project Id – the Import Project Id provided by Cloudaware
    Dataset Id – the Import Dataset Id provided by Cloudaware

    Click Done.

  2. Save and activate the workflow.

Allow some time for data to load. Verify by checking upload status.

Tables

As a result, the following tables will be created in ServiceNow:

System tables

Label

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

Label

Name

AWS Account

x_ca_cmdb_aws_account

AWS DynamoDB Backup

x_ca_cmdb_aws_dynamo_db_backup

AWS DynamoDB Table

x_ca_cmdb_aws_dynamo_db_table

AWS EBS Snapshot

x_ca_cmdb_aws_snapshot

AWS EBS Volume

x_ca_cmdb_aws_volume

AWS EC2 Image

x_ca_cmdb_aws_image

AWS EC2 Instance

x_ca_cmdb_aws_instance

AWS EC2 Security Group

x_ca_cmdb_aws_security_group

AWS ELB Load Balancer

x_ca_cmdb_aws_load_balancer

AWS ElastiCache Cluster

x_ca_cmdb_aws_cache_cluster

AWS ElastiCache Node

x_ca_cmdb_aws_cache_node

AWS Lambda Function

x_ca_cmdb_aws_lambda_function

AWS RDS Cluster

x_ca_cmdb_aws_db_cluster

AWS RDS Instance

x_ca_cmdb_aws_db_instance

AWS Redshift Cluster

x_ca_cmdb_aws_redshift_cluster

AWS S3 Bucket

x_ca_cmdb_aws_bucket

Imports for some application tables can be disabled by the admin in the system table Cloudaware Import Settings (x_ca_cmdb_ci_class_import_settings). To disable the import, set the property 'Active' to False. Data for inactive tables will not be imported from Cloudaware.

Verify data upload status

Append /x_ca_cmdb_ci_class_import_settings.do to the ServiceNow instance URL in the web browser:

https://YOURINSTANCE.service-now.com/x_ca_cmdb_ci_class_import_settings.do where YOURINSTANCE is a placeholder for your ServiceNow instance ID.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.