AWS Service Graph Connector Scheduled Import Jobs

Anne Marie Duff
ServiceNow Employee
ServiceNow Employee

‎07-09-2024 09:04 AM - edited ‎07-11-2024 06:52 AM

AWS Service Graph Connector Scheduled Import Jobs

 

The Scheduled Data Import Table below shows the 31 Out of the Box Scheduled Data Imports that are installed on a ServiceNow instance that is enabled for Software Asset Management. They are shown in the Order that they run in.

 

#

 Scheduled Data Import Required(Y\N)
 Comment
1 SG-AWS-Organization Y

Parent Job that all of the other Child Jobs in this table run after. (Needs to be turned on, Active=true in the Set up Scheduled data imports step in Guided Setup). 

Creates a Cloud Organizations[cmdb_ci_cloud_org] CI to represent the Parent Organization in AWS
2 SG-AWS-Org-Units N

Creates an AWS Organizational Unit [cmdb_ci_aws_org_unit] CI for every Organizational Unit in the Parent Organization in AWS

 

If the Parent Organization in AWS does not contain Organizational Units then no CI's are created
3 SG-AWS-Service-Account Y

Creates a Cloud Service Account[cmdb_ci_cloud_service_account] CI
for the Account you specified in the Update configuration properties for instance Step in Guided Setup.
 
It acts as a Container for all the Logical Data Centers\Regions (AWS Data Center[cmdb_ci_aws_datacenter] CI's) associated with the Account 
4 SG-AWS-Service-Account-Tags N

Creates Key Value Records in the Key Values[cmdb_key_value] Table for Tags associated with the Cloud Service Account[cmdb_ci_cloud_service_account] CI's that were created by the above AWS-Service-Account Scheduled Import Job.
5 SG-AWS-Org-Unit-Accounts N

Creates a Cloud Service Account[cmdb_ci_cloud_service_account] CI for every Account associated with an AWS Organizational Unit in the AWS Organization.
 
If the Organization in AWS has no Organizational Units then no Cloud Service Account[cmdb_ci_cloud_service_account] CI's are created.
6 SG-AWS-Datacenters Y Creates an AWS Data Center[cmdb_ci_aws_datacenter] CI for every AWS Region in the Account you specified in the Update configuration properties for instance Step in Guided Setup.
7 SG-AWS-VPC Y

Creates a Cloud Network [cmdb_ci_network] CI for every AWS VPC (VPC in each AWS Region) in the Account you specified in the Update configuration properties for instance Step in Guided Setup.


Please refer to this AWS Virtual private clouds for your EC2 instances Documentation Page for more details on AWS VPC's.
8 SG-AWS-Subnets Y

Creates the CI's below:

 

  • Availability Zone [cmdb_ci_availability_zone] CI's for every AWS Availability Zone (Availability Zones in each AWS Region) associated with the Account you specified in the Update configuration properties for instance Step in Guided Setup.

Please refer to this AWS Availability Zones  Documentation Page for more details on AWS Availability Zones.

 

  • Cloud Subnet [cmdb_ci_cloud_subnet] CI's for every AWS Cloud Subnet (AWS Subnet in each AWS VPC) associated with the Account you specified in the Update configuration properties for instance Step in Guided Setup.

Please refer to this AWS Subnets for your VPC  Documentation Page for more details on AWS Availability Zones.
9 SG-AWS-Network-Interface Y if running the 13. SG-AWS-EC2 Job that creates Virtual Machine Instance CI's Creates Cloud Mgmt Network Interface [cmdb_ci_nic] CI's for every Amazon Elastic Network Interface (Network Interfaces associated with your EC2 Instances) associated with the Account you specified in the above Update configuration properties for instance Step in Guided Setup.
10 SG-AWS-Security-Group Y if running the 13. SG-AWS-EC2 Job that creates Virtual Machine Instance CI's Creates Compute Security Group [cmdb_ci_compute_security_group] CI's for every Amazon EC2 Security Group (Security Groups associated with your EC2 Instances) associated with the Account you specified in the Update configuration properties for instance Step in Guided Setup.
11 SG-AWS-Storage-Volume Y if running the 13. SG-AWS-EC2 Job that creates Virtual Machine Instance CI's Creates Storage Volume [cmdb_ci_storage_volume] CI's for every Amazon EBS volume  (Storage Volumes associated with your EC2 Instances) associated with the Account you specified in the Update configuration properties for instance Step in Guided Setup.
12 SG-AWS-Image-Private Y if running the 13. SG-AWS-EC2 Job that creates Virtual Machine Instance CI's

Creates Image [cmdb_ci_os_template] CI's for every Amazon Machine Image (AMI) (Images associated with your EC2 Instances) associated with the Account you specified in the Update configuration properties for instance Step in Guided Setup.
13 SG-AWS-EC2 N

Creates a Virtual Machine Instance[cmdb_ci_vm_instance] CI for every EC2 Instance associated with the Account you specified in the Update configuration properties for instance Step in Guided Setup.

 

Also creates the below CI's for storing data associated with the EC2 Instances.

 

  • *cmdb_ci_server\cmdb_ci_linux_server\cmdb_ci_win_server
  • cmdb_ci_endpoint_vnic
  • cmdb_ci_storage_mapping
  • cmdb_ci_endpoint_block
  • cmdb_ci_ip_address
  • cmdb_ci_network_adapter

 

* If using the Deep Discovery Feature (SSM System Manager enabled) then Linux Server[cmdb_ci_linux_server] CI's created for Linux Type EC2 Instances and Windows Server[cmdb_ci_win_server] CI's created for Windows Type EC2 Instances. 

 

If not using the  Deep Discovery Feature (SSM System Manager enabled) then Server[cmdb_ci_server] CI's created.
14 SG-AWS-Image-Id

Y if running the 13.  SG-AWS-EC2 Job that creates Virtual Machine Instance CI's

 Populates fields in already existing Image [cmdb_ci_os_template] CI's
15 SG-AWS-Hardware-Type Y if running the 13.  SG-AWS-EC2 Job that creates Virtual Machine Instance CI's Creates Hardware Type [cmdb_ci_compute_template] CI's for every Amazon EC2 Instance Type (Hardware Type associated with your EC2 Instances) associated with the Account you specified in the Update configuration properties for instance Step in Guided Setup.
16 SG-AWS-VM-Hw-Consolidation N

Populates the below fields in these CI's:

 

  • VM Instance[cmdb_ci_vm_instance] - RAM, Disk Size (GB) and CPU fields.
  • Server (cmdb_ci_server\cmdb_ci_linux\cmdb_ci_win_server) - RAM & CPU Count fields.
17 SG-AWS-ELB-V1 N

Creates Cloud Load Balancer [cmdb_ci_cloud_load_balancer] CI's for every Classic AWS Classic Load Balancer associated with the Account you specified in the Update configuration properties for instance Step in Guided Setup.
18 SG-AWS-ELB-V2 N Creates Cloud Load Balancer [cmdb_ci_cloud_load_balancer] CI's for every AWS Application Load Balancer, Network Load Balancer, or Gateway Load balancer associated with the Account you specified in the  Update configuration properties for instance Step in Guided Setup.
19 SG-AWS-RDS N Creates Cloud DataBase [cmdb_ci_cloud_database] CI's for every AWS RDS DB Instance associated with the Account you specified in the Update configuration properties for instance Step in Guided Setup.
20 SG-AWS-S3 Y if using the Deep Discovery feature of AWS Service Graph Connector Creates Cloud Object Storage [cmdb_ci_cloud_object_storage] CI's for every AWS S3 Bucket associated with the Account you specified in the Update configuration properties for instance Step in Guided Setup.
21 SG-AWS-DynamoDb N

Creates DynamoDB Table [cmdb_ci_dynamodb_table] CI's for every AWS DynamoDB Table associated with the Account you specified in the Update configuration properties for instance Step in Guided Setup.
22 SG-AWS-API-Gateway N

Creates Cloud Gateway [cmdb_ci_cloud_gateway] CI's for every AWS API Gateway (with WebSocket or HTTP APIs) associated with the Account you specified in the Update configuration properties for instance Step in Guided Setup.
23 SG-AWS-Lambda N

Creates Cloud Function [cmdb_ci_cloud_function] CI's for every AWS Lambda Function associated with the Account you specified in the Update configuration properties for instance Step in Guided Setup.
24 SG-AWS-Software-Inventory N 

Software Asset Management(SAM) enabled

 

Populates the Software Installations[cmdb_sam_sw_install] Table with Software Install Records associated with the Computer CI (Server\Linux Server\Windows Server) CI Record that gets Created\Updated by the Service Graph Connector.

 

Software Asset Management(SAM) not enabled

 

The Software Instances[cmdb_software_instance] Table is populated with Software Install Records associated with the Computer CI (Server\Linux Server\Windows Server) Records instead of the Software Installations[cmdb_sam_sw_install] Table. The Software Packages[cmdb_ci_spkg] Table is also populated with Software Package Records with associated Install Counts and License Counts.
25 SG-AWS-Software-Remove N

Software Asset Management(SAM) enabled

 

Removes Software Install Records, associated with the Computer CI Record that gets Created\Updated by the Service Graph Connector, from the Software Installations[cmdb_sam_sw_install] Table

 

Software Asset Management(SAM) not enabled

 

The Software Install Records are removed from the Software Instances[cmdb_software_instance] Table instead of from the Software Installations[cmdb_sam_sw_install] Table. The Software Package Records are also removed from the Software Packages[cmdb_ci_spkg] Table.
26 SG-AWS-SSM-SendCommand Y if using the Deep Discovery feature of AWS Service Graph Connector
  1.  Creates cmdb_running_process and cmdb_tcp Records for the Server CI's that get Created\Updated by the Service Graph Connector
  2.  Populates the Serial Number, CPU, Manufacturer, Model ID fields in the Server CI's that get Created\Updated by the Service Graph Connector
27 SG-AWS-Tags N Creates Key Value Records in the Key Values[cmdb_key_value] Table for Tags associated with AWS Load Balancers, DynamoDBs and Lambda Functions in AWS.
28 SG-AWS-EKS-Cluster N

Creates Kubernetes Cluster [cmdb_ci_kubernetes_cluster] CI's for every Kubernetes Cluster associated with the Account you specified in the Update configuration properties for instance Step in Guided Setup.

 

 
29 SG-AWS-EKS-Cluster-2 Y if using the EKS Cluster Discovery feature of AWS Service Graph Connector

Pulls Cluster Names for all Kubernetes Clusters associated with the Account you specified in the Update configuration properties for instance Step in Guided Setup using the SSM Document created by the SG-AWS-RunKubeCtlEKSNamesShellScript Cloud Formation Template listed at the top of this Article.

 

It stores these Names in a temporary location that is later used by the below SG-AWS-EKS-FULL Scheduled Import Job.
30 SG-AWS-EKS-FULL Y if using the EKS Cluster Discovery feature of AWS Service Graph Connector

1. Finds all Kubernetes Cluster Names from the Temporary Names location populated by the above SG-AWS-EKS-Cluster-2 job.

2. Creates the following CIs using the SSM Document created by the SG-AWS-RunKubeCtlShellScript Cloud Formation Template listed at the top of this Article.

 

  • cmdb_ci_kubernetes_cluster
  • cmdb_ci_server
  • cmdb_ci_kubernetes_volume
  • cmdb_ci_kubernetes_service
  • cmdb_ci_kubernetes_pod
  • cmdb_ci_kubernetes_node
  • cmdb_ci_kubernetes_namespace
  • cmdb_ci_kubernetes_deployment
  • cmdb_ci_kubernetes_daemonset
  • cmdb_ci_kubernetes_cluster
  • cmdb_ci_kubernetes_component
  • cmdb_ci_kubernetes_workload
  • cmdb_ci_docker_image
  • cmdb_ci_docker_container
31 SG-AWS-Generic-Resources  

 

Creates Cloud Resource [cmdb_ci_cmp_resource] CI's for every Generic Resource Type present in Service Graph Resource Inclusion Whitelists[sn_cmdb_int_util_service_graph_resource_inclusion_whitelist] Table.

 

 

Please refer to the ServiceNow Service Graph Connector for AWS (2.6.1) Documentation Page for more details on the above Import Schedules.

  • 1,634 Views
Comments
KrushnakumaT
Tera Guru
‎05-08-2025 12:59 AM

Hi  Anne Marie Duff,
Thank you for the article.
Could you please help me to overcome below error while using SGC - AWS

KrushnakumaT_0-1746691145165.png

KrushnakumaT_0-1746691184334.png

 

KrushnakumaT_1-1746691149490.png

 

 

 

0 Helpfuls
Version history
Last update:
‎07-11-2024 06:52 AM
Updated by:
ServiceNow Employee