| Info |
|---|
This article explains how to set up configure the Cloudaware ServiceNow application in ServiceNow. Cloudaware extends the Configuration Item table in ServiceNow with additional cloud inventory data. |
...
3. Сontact support@cloudaware.com to get credentials required for this integration (Service Account private key & password, the .p12 certificate file, Import Project Id, and Import Dataset Id).
4. Download the .xml file for application installation.
| Expand | ||||
|---|---|---|---|---|
| ||||
|
Configure Cloudaware application in ServiceNow
...
WHERE
Name: set up a meaningful name, e.g. Google JWT Key
Signing Key: insert the password provided by Cloudaware notasecret
Signing Keystore: click the magnifier icon (Lookup using list) to create a new signing keystore - see the point b) below
...
WHERE
Name: set up a meaningful name, e.g. Google JWT Certificate
Type: select 'Java Key Store' from the list
Key store password: insert the password provided by Cloudaware notasecret
Click the paper clip icon (Manage attachments):
...
WHERE
Name: set up a meaningful name, e.g. Google JWT
Client ID: set up as notneeded
Client secret: set up as notneeded
Default Grant type: select 'JWT Bearer' from the list
Token: click the lock icon to insert https://oauth2.googleapis.com/token → click the lock icon to save.
Refresh Token Lifespan: 10
Click Submit.
Click on the name of OAuth Entity Profile (in this example, Google JWT default_profile) to edit settings:
...
2. Open 'Flows'. Select the flow Initial Filling Of The Mapping Data Table Update Import Settings and Fields Mapping.
...
Click Test → Run test*:
...
*This should be done once only after the application is installed.
3. Go back to all flows. Set descending order in the column 'Updated' for quicker search. Select the flow Import All data CI Data from Cloudaware from the list.
...
4. Schedule In TRIGGER, click on the section to schedule a trigger. Select 'Scheduled' → Daily* → set the time:
...
*The recommended frequency is once a day.
Click Done.
5. In ACTIONS, click Set Flow Variables to select:
...
WHERE
...
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
Connection - select the JWT Provider configured in the section 'Set up Cloudaware application in ServiceNow' (point 1)
Cloudaware Import Fields Mapping Table - the value is auto-populated as this is a system table
Import Project Id - use the Import Project Id provided by Cloudaware
Import Dataset Id - use the Import Dataset Id provided by Cloudaware
...
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_gigwaca_cloudawa_2cmdb_aws_account |
AWS DynamoDB Backup | x_gigwaca_cloudawa_2cmdb_aws_dynamo_db_backup |
AWS DynamoDB Table | x_gigwaca_cloudawa_2cmdb_aws_dynamo_db_table |
AWS EBS Snapshot | x_gigwaca_cloudawacmdb_2_aws_snapshot |
AWS EBS Volume | x_gigwaca_cloudawacmdb_2_aws_volume |
AWS EC2 Image | x_gigwaca_cloudawa_2cmdb_aws_image |
AWS EC2 Instance | x_gigwaca_cloudawacmdb_2_aws_instance |
AWS EC2 Security Group | x_gigwaca_cloudawa_2cmdb_aws_security_group |
AWS ELB Load Balancer | x_gigwaca_cloudawacmdb_2_aws_load_balancer |
AWS ElastiCache Cluster | x_gigwaca_cloudawacmdb_2_aws_cache_cluster |
AWS ElastiCache Node | x_gigwaca_cloudawa_2cmdb_aws_cache_node |
AWS Lambda Function | x_gigwaca_cloudawa_2cmdb_aws_lambda_function |
AWS RDS Cluster | x_gigwaca_cloudawa_2cmdb_aws_db_cluster |
AWS RDS Instance | x_gigwaca_cloudawacmdb_2_aws_db_instance |
AWS Redshift Cluster | x_gigwaca_cloudawacmdb_2_aws_redshift_cluster |
AWS S3 Bucket | x_gigwaca_cloudawa_2cmdb_aws_bucket |
Imports for some application tables may be deactivated by the admin in the system table Cloudaware Import Settings (x_ca_cmdb_ci_class_import_settings). To deactivate the import, set the property 'Active' to False. The data for the table(s) with property 'Active' set to False will NOT be imported from Cloudaware.
Data upload status check
To check the data upload status, append /x_gigwaca_cloudawacmdb_2ci_listclass_of_imported_tables_listimport_settings.do to the current URL in your web browser.
The full URL should be in the format https://YOURINSTANCE.service-now.com/x_gigwaca_cloudawacmdb_2ci_listclass_of_imported_tables_listimport_settings.do, where 'YOURINSTANCE' is a placeholder for your ServiceNow instance ID.