Tables installed with Amazon Web Services Amazon AWS Cloud adds or modifies these tables. Tables Table 1. Amazon AWS Cloud tables Name Description AWS Tags[aws_tag] Defines the tags used for tagging Amazon resources. AWS Tag Rules [aws_tag_rule] Defines the rules for automatically attaching values to tags. AWS CI Tag Value [aws_ci_tag_value] Maps a CMDCI to a tag name and tag value. AWS Custom Tag Value [aws_custom_tag_value] Maps a tag to a static string value. AWS Resource Tag History [aws_rsrc_tag_history] Maps an Amazon resource ID to an Amazon tag. AWS Resource Tag History Mapping [aws_rsrc_tag_history_mapping] Maps an an aws_rsrc_tag_history reference to a tag name and tag value. AWS Job Configuration [aws_job_config] Represents an AWS bill download. AWS Billing Report Type [aws_billing_report_type] Defines how to parse a downloaded Amazon billing .csv file. AWS Report Download Log [aws_report_download_log] Represents a log item created during an AWS billing download. AWS Billing Rollup Aggregate [aws_billing_rollup_aggregate] Defines which field to sum from on the hourly and daily billing tables. AWS Billing Rollup Pivot Point [aws_billing_rollup_pivot] Defines which field to roll up on the hour and daily billing tables. AWS Billing Report Filter Point [aws_billing_report_filter] Inserts all unique resource IDs that are used in Amazon cost reports. AWS Billing Hourly with Tags [aws_billing_hourly_with_tags] Contains records corresponding to an Amazon line item with hourly data and tag mapping relationship. Keeps data less than 30 days old. AWS Billing Chart Definition [aws_billing_chart_definition] Contains cost and usage report selections. AWS Billing Rollup Daily [aws_billing_rollup_daily] Created from aws_billing_hourly_with_tags records table, for a 1 day duration. Only keeps data less than 180 days old. AWS Billing Rollup Monthly [aws_billing_rollup_monthly] Created from the aws_billing_hourly_with_tags table, for a 1 month duration. Keeps only data less than one year old. AWS Optimization Rule EBS [aws_opt_rule_ebs] Contains rules for Amazon Elastic Block Store resources. This table is a child of the opt_rule_attached_storage table. AWS Optimization Rule EC2 [aws_opt_rule_ec2] Contains rules for Amazon EC2 resources. This table is a child of the opt_rule_attached_storage table. AWS Optimization Rule ELB [aws_opt_rule_elb] Contains rules for Amazon Elastic Load Balancing. This table is a child of the opt_rule_attached_storage table. CloudFormation Provisioning Rules [aws_cldfrm_provisioning_rules] Contains rules for Amazon Elastic Load Balancing. This table is a child of the opt_rule_attached_storage table. AWS CloudFormation Stack Change Definition [aws_cldfrm_stack_change_definition] Contains an editable draft of stack changes. The records are created when modifying a stack. AWS CloudFormation Stack Change Parameters [aws_cldfrm_stack_change_params] Contains an editable draft of stack parameters. The records are created when modifying a stack. AWS CloudFormation Stack Resource [aws_cldfrm_stack_change_definition] Contains a list of stack resources. AWS CloudFormation Script Mapping [aws_cloudformation_script_mapping] Contains a script mapping table used to resolve scripts dynamically. AWS CloudFormation Stack Output [aws_cloudformation_stack_output] Contains a list of stack outputs. AWS CloudFormation Stack Parameter [aws_cloudformation_stack_parameter] Contains a list of stack parameters. AWS Console Access Request [aws_console_access_request] Contains either a URL or link to generate tokens for Amazon console access. CloudFormation Parameters Reference Table Exclusions List [cldfrm_param_ref_table_excl] Contains a list tables that are not applicable for CloudFormation Parameters Reference Table lookup. CloudFormation Template Parameters [cloudformation_template_parameter] Contains a list of CloudFormation template parameters. The records are created when a template is saved. CloudFormation Variable Set for Template Parameters [cloudformation_template_to_variableset] Contains mapping for CloudFormation template and variable sets. AWS CloudFormation Stack [cmdb_ci_cloudformation_stack] Contains a list of CloudFormation stacks from all Amazon regions. CloudFormation Template [cmdb_ci_cloudformation_template] Contains a list of CloudFormation templates. AWS Security Token Catalog Item [sc_aws_security_token_cat_item] Contains the catalog item for AWS security tokens. CloudFormation Catalog Item [sc_cloudformation_cat_item ] Contains a catalog item for a CloudFormation stack. AWS Auto Scaling Group Launch Config [aws_asgrp_launch_cfg] Contains a list of launch configurations from all regions. AWS Policy [aws_policy] Contains a list of policies that can be applied to security tokens for federated access. AWS Security Token [aws_token] Contains security tokens for federated access. AWS Security Token for User [aws_user_token] Contains the mapping for a user and a security token. AWS Auto Scaling Group [cmdb_ci_aws_asgrp ] Contains a list of autoscaling groups from all regions. Amazon Web Service [amazon_web_service] Contains algorithms, api version, and other meta data needed to make API call for different Amazon Web Services. AWS Datasource Type Mapping [aws_datasource_type_mapping] Contains mappings between discovered attributes and a variable in a normalized object created on the fly. Normalized Object to DB Mapping [normalizedobject_db_mapping] Contains mapping between variables in normalized object to field in tables. AWS Region Endpoint [aws_region_endpoint] Contains a list of endpoints for all regions for different amazon web services. AWS Region [aws_region] Contains a list of all amazon regions. AWS Resource Type [aws_resource_type] Contains a list of amazon resource type. AWS Service Endpoint [aws_service_endpoint] Contains metadata to calculate a service endpoint. AWS Resource [cmdb_ci_aws_resource] Contains a reference to the specific resource record. AWS Account [aws_account_admin] Contains account details for Amazon accounts such as username and ID. AWS Actions [aws_action] Contains actions for Amazon Web Services API calls. AWS Availability Zone [aws_availability_zone] Contains a list of availability zone from all regions. AWS Credentials [aws_credentials] Contains access credentials for amazon account like security key and access key. AWS Elastic Block Store Snapshot [aws_ebs_snapshot] Contains a list of snapshot from all regions. AWS Elastic Load Balancer Backend Server Description) [aws_elb_backend_server] Contains a list of back-end servers. AWS Elastic Load Balancer Policy [aws_elb_policy] Contains a list of load balancer policies from all regions. AWS Noun [aws_noun] Contains nouns to create probe actions such as image and instances. AWS Verb [aws_verb] Contains verbs to create probe actions such as get and describe. AWS Resource to Availability Zone Mapping [aws_resource_to_availzone] Contains a mapping between a generic AWS resource and an availability zone. AWS EBS Volume [cmdb_ci_aws_ebs_volume] Contains a list of volumes from all regions. AWS Elastic Load Balancer Listener [cmdb_ci_aws_elb_listener] Contains a list of ELB listners from all regions. AWS Subnet [cmdb_ci_aws_subnet] Contains a list of subnets from all regions. AWS VPCs [cmdb_ci_aws_vpc] Contains a list of VPCs from all regions. EC2 Virtual Machine Instance [cmdb_ci_ec2_instance] Contains a list of virtual machine instances from all regions. Subnet [cmdb_ci_subnet] Contains a list of ELBs from all regions. Virtual Private Cloud [cmdb_ci_vpc] Parent table for cmdb_ci_aws_vpc. AWS Probe [discovery_aws_probe] Contains a list of AWS probes. Probe Parameter Override [dscy_probe_parameter_override] Contains overrides for request parameter of probes. AWS VPC Security Group Rule [aws_vpc_security_group_rule] Contains a list of security group rules. AWS VPC Security Group [aws_vpc_security_group] Contains a list of security groups. AWS VPC Security Group Rule Traffic Type [aws_vpc_sg_rule_traffic_type] Contains a list of security group rule traffic types (name, protocol number, from_port, and to_port). EC2 Approved Image [ec2_approved_images] Contains images approved by a cloud_administrator for provisioning user requests. EC2 Image Attribute [ec2_image_attribute] Contains list of attributes specifying properties of images for spinning up VMs. EC2 Image Criteria [ec2_image_critera] Contains a list of filter names used to filter VM types and sizes. EC2 Criteria Attribute [ec2_criteria_attribute_m2m] Contains list of mapping between criteria and image attribute used for filtering VMs types and sizes. EC2 Image [ec2_image] Contains a list of all EC2 images from all regions. EC2 Keypairs [ec2_keypairs] Contains the keypairs for all the regions for the account. EC2 Provision Rules [ec2_provision_rules] Contains rules to auto-select provisioning variables such as account, vpc, and subnet. EC2 Region Size Exclude [ec2_region_size_exclude_m2m] Contains a list of mappings between region and sizes that are not supported in that given region. EC2 Shared Image Account [ec2_shared_image_account] Contains the names and numbers of the accounts that provide shared EC2 images. EC2 Size Criteria [ec2_size_criteria_m2m] Contains a list of mappings between image criteria and EC2 sizes used for filtering VMs types and sizes. EC2 Size [ec2_size] Contains list of supported EC2 sizes from all regions. Internet Protocol [internet_protocol] A list of standard internet protocol numbers and names. ICMP Message [ip_icmp_message] A list of ICMP control messages IP Message Mapping [ip_message_mapping] Contains mappings between an IP protocol number and a translator script include. EC2 Catalog Item [sc_ec2_cat_item] Contains catalog items for VMs. Catalog EC2 Element Price [sc_ec2_element_price] Contains mappings between an EC2 element and the catalog price. EC2 Key Pair Catalog Item [sc_ec2_key_pair_cat_item] Contains catalog item for Amazon keypair. EC2 Catalog Offering [sc_ec2_os_selection] Contains the OS types that appear in the service catalog, as defined by the cloud administrator.