Components installed with Cloud Cost Management

Several types of components are installed with activation of the Cloud Cost Management application, including tables, user roles, and scheduled jobs.

Scheduled jobs installed

Scheduled job	Description
Price Sheet Table Cleaner	Cleans up AWS price sheet records.
Resource Group Table Cleaner	Cleans up Azure resource group records that are no longer required.
CCM CleanUp Inactive Aggregated Spend Records	Cleans up inactive aggregated spend records.
Cloud Insights Historical Data Collection	Collects GCP spend data.
Cloud Insights Saving Daily Data Collection	Collects potential savings and realized savings for spend.
Cloud Insights Spend Saving Data Collection	Collects cloud spend potential saving percentage.
Execute Tasks	Executes tasks associated with AWS billing download.
Flow Launcher and Hierarchical Flow Launcher Keep Alive	Cancels stale flow jobs.
GCP Price Sheet Table Cleaner	Cleans up GCP Price sheet table
Tag Categories Based Recommendation	Generates Tag Category based recommendations.
Important: The following scheduled jobs are used only when the Cloud Cost Management Infra Stack application is installed in addition to Cloud Cost Management version 8.1.
Cumulus- Cancel stuck job	Monitors scheduled billing jobs and cancels the jobs that are stuck. This enables billing jobs in the queue to be processed.
Unsupported CI Type Placement	Places the CI types that aren’t used for daily recommendations.
CCM - Daily job	Performs daily maintenance activities such as cleanup of left-out attachments of AWS billing job (with assume role authentication).

Tables installed

Table	Description
CI Placement Extension Progress Calculation [sn_cld_intg_aws_ci_placement_extension_progress_calculation]	Configuration Items placement progress for AWS. Contains number of records to be processed by the AWS extension.
CI Placement Stats [sn_cld_intg_aws_ci_placement_stats]	Status of bookmarks created during the Configuration Items placement for AWS.
AWS CI Placement Type Information [sn_cld_intg_aws_ci_placement_type]	All types of Configuration Items deployed byCloud Cost Management for AWS.
AWS Cost And Usage Bill Data [sn_cld_intg_aws_cost_usage]	Cost and billing data for AWS.
Cost Usage Bookmarks [sn_cld_intg_aws_cost_usage_bookmarks]	Time stamp bookmarks created for the ingested Cloud Cost Management placement records.
CloudWatch Metric Association [sn_cld_intg_aws_cw_metric_association]	Custom metrics created by user.
AWS CloudWatch Metric Definition [sn_cld_intg_aws_cw_metric_definition]	Definitions for various AWS cloud watch metrics.
CloudWatch Metric Definition to Account [sn_cld_intg_aws_cw_metric_definition_account_m2m]	Metric to service account mapping information.
AWS Baseline Performance for EC2 Burstable Instances [sn_cld_intg_aws_ec2_burstable_baseline_perf]	Baseline performance percentage for AWS EC2 burstable instances.
AWS Gov Accounts Mapping [sn_cld_intg_aws_gov_account_mapping]	AWS Gov accounts and linked accounts details.
AWS Instance details [sn_cld_intg_aws_instance_detail]	Details for various AWS instances present.
AWS Instance Price details [sn_cld_intg_aws_instance_price_detail]	Pricing and rate details for AWS instances.
AWS Offer Term [sn_cld_intg_aws_offer_term]	Offer term details based on configurations of AWS products.
AWS Price Discount [sn_cld_intg_aws_price_discount]	Price discounts for AWS service accounts.
AWS Price Sheet Information [sn_cld_intg_aws_price_sheet_info]	Price sheet details for AWS.
AWS Product Details Base [sn_cld_intg_aws_product_details]	All product details or specifications for AWS.
AWS Product Details EC2 [sn_cld_intg_aws_product_details_ec2]	EC2 product details or specifications for AWS.
AWS Product Details RDS [sn_cld_intg_aws_product_details_rds]	RDS product details or specifications for AWS.
AWS Resource Hourly Usage Last Downloaded [sn_cld_intg_aws_resource_hourly_usage_last_downloaded]	Hourly usage download status for AWS resources.
AWS Resource Rate [sn_cld_intg_aws_resource_rate]	Resource rates for AWS product SKUs.
AWS Billing Download Job [sn_cld_intg_aws_schedule]	Billing download jobs and their status for AWS.
AWS Storage Price Details [sn_cld_intg_aws_storage_price_detail]	Storage price sheet information for AWS.
Azure CI Placement Type Information [sn_cld_intg_azure_ci_placement_type]	Defines all types of Configuration Items deployed by Cloud Cost Management for Azure.
Azure Cost And Usage Bill Data [sn_cld_intg_azure_cost_usage]	Cost and billing data for Azure.
Azure Database Price Sheet [sn_cld_intg_azure_db_price_sheet]	Price sheet details for Azure database.
Azure Database retail price detail [sn_cld_intg_azure_db_retail_price]	Retail price information for Azure database.
Azure Enrollment To Service Account Mapping [sn_cld_intg_azure_ea_sa_mapping]	Mapping information for enrollment account to the service accounts used by Cloud Cost Management.
Azure Instance Details [sn_cld_intg_azure_instance_detail]	Details of various Azure instances present.
Azure Instance Price Details [sn_cld_intg_azure_instance_price_detail]	Pricing and rate details for Azure instances.
Azure Instance Series To Family Mapping [sn_cld_intg_azure_instance_series_family_mapping]	Instance family to instance series mapping information for Azure.
Azure Instance Size Details [sn_cld_intg_azure_instance_size_detail]	Details about various Azure instances sizes & their functionalities.
Azure Normalized Region [sn_cld_intg_azure_normalized_region]	Resource location to a generic normalized location mapping information.
Azure Price Sheet Version [sn_cld_intg_azure_price_sheet_version]	Price sheet status and version for Azure.
Azure Product Details [sn_cld_intg_azure_product_details]	All product details or specifications for Azure.
Azure Product Details VM [sn_cld_intg_azure_product_details_vm]	Virtual Machine product details or specifications for Azure.
Azure Product Offering VM [sn_cld_intg_azure_product_offering_vm]	Offer term details for Azure Virtual Machine service.
Azure Product Details Instance Type Map [sn_cld_intg_azure_prod_dtls_inst_type_map]	Product details for various instance types for Azure.
Azure Advisor Subscription Queue [sn_cld_intg_azure_recommendation_subscription_queue]	Stores the states of generate, get generate status and list recommendations flow launcher jobs, for provider based recommendations of Azure.
Azure resource hourly usage last downloaded [sn_cld_intg_azure_resource_hourly_usage_last_downloaded]	Hourly usage download status for Azure resources.
Azure Resource Rate [sn_cld_intg_azure_resource_rate]	Resource rates for Azure meter IDs.
Azure Billing Download Job [sn_cld_intg_azure_schedule]	Billing download jobs and their status for Azure.
Azure Software Cost Details [n_cld_intg_azure_software_cost_detail]	Hourly cost details for Azure software.
Azure Storage Price Details [sn_cld_intg_azure_storage_price_detail]	Storage price sheet information for Azure.
Azure Storage Size Details [sn_cld_intg_azure_storage_size_detail]	Various Azure storage sizes & their functionalities.
Cloud Action Execution [sn_cld_intg_core_action_exec]	Execution details for various cloud actions.
Cloud Alias [sn_cld_intg_core_alias]	List of defined aliases.
Cloud Alias Mapping [sn_cld_intg_core_alias_mapping]	Alias mapping to the script or action flow.
Cloud API Request [sn_cld_intg_core_api_request]	API request & parameters sent to the provider.
Cloud API Request Error [sn_cld_intg_core_api_request_error]	Error responses for failed request items.
Cloud API Request Item [sn_cld_intg_core_api_request_item]	API request item details sent to the provider.
Cloud API Response [sn_cld_intg_core_api_response]	API responses for the API calls made to providers.
Cloud Availability Zones [sn_cld_intg_core_availability_zone]	Availability zones for various providers.
Billing Report Information [sn_cld_intg_core_billing_report_info]	Billing summary reports for billing download jobs.
Billing Import Progress [sn_cld_intg_core_bill_imp_progress]	Import information for various extensions under billing download job.
CI Placement Stats [sn_cld_intg_core_ci_placement_stats]	Status of bookmarks created during Configuration Items placement.
CI Placement Status [sn_cld_intg_core_ci_placement_status]	Configuration Items placement status for extensions executed.
CI Placement Type Information [sn_cld_intg_core_ci_placement_type]	All types of Configuration Items deployed by our product for all providers.
Cost Tags [sn_cld_intg_core_cost_tags]	Mapping information of tag category to cost hash.
Execution [sn_cld_intg_core_execution]	Execution details for all types of running IH flows.
Execution Batch [sn_cld_intg_core_execution_batch]	Execution batches for running the flows.
Execution To Batch Map [sn_cld_intg_core_execution_batch_map]	Mapping information of execution jobs to the respective batches.
Execution Log [sn_cld_intg_core_execution_log]	Log messages for all the executions.
Execution Metric [sn_cld_intg_core_execution_metric]	Metrics for executions.
Execution Monitor [sn_cld_intg_core_execution_monitor]	Live status of the ongoing execution.
Extension [sn_cld_intg_core_ext]	All the available extensions and their details.
Extension Type [sn_cld_intg_core_ext_type]	Types of extensions defined.
Flow Launcher Execution [sn_cld_intg_core_flow_launcher_execution]	Flow launcher job execution details.
Flow Launcher Job [sn_cld_intg_core_flow_launcher_job]	List of flow launcher jobs and their status.
Flow Launcher Job Configuration [sn_cld_intg_core_flow_launcher_job_config]	Configurations for flow launcher jobs.
Flow Launcher Workload [sn_cld_intg_core_flow_launcher_workload]	Workload information for flow launcher executions.
Flow Map [sn_cld_intg_core_flow_map]	Mapping information of input parameters to the flow workloads.
Flow Reflection [sn_cld_intg_core_flow_reflection]	Flow reflection link in flow designer for given context.
Hierarchical Flow Launcher Execution [sn_cld_intg_core_hierarchical_flow_launcher_execution]	Hierarchical flow launcher job execution details.
Imported Date Range [sn_cld_intg_core_imported_date_range]	Imported date range of data during billing download execution.
Instance Family [sn_cld_intg_core_instance_family]	Instance families available for various providers.
Cloud Instance Types [sn_cld_intg_core_instance_type]	Instance types & details for various providers.
Cloud Instance Type Family [sn_cld_intg_core_instance_type_family]	Instance family types available for various providers.
Billing Line Item Types [ sn_cld_intg_core_line_item_type]	Types of billing charges for various providers.
Associated Flow Execution [sn_cld_intg_core_m2m_ext_exec_flow_exec]	Mapping information of extension execution to flow execution.
M2m Profile Exec Metrics Profile Table Metrics [sn_cld_intg_core_m2m_profile_exec_metrics_profile_table_metrics]	Mapping information of profile execution to profile table metrics.
Pipeline Stage Extension Type Map [sn_cld_intg_core_map_pp_stage_ext_type]	Mapping information of extension types to their respective stages.
Cloud Operating Systems [sn_cld_intg_core_os_type]	Operating system details for various providers.
Pipeline Execution [sn_cld_intg_core_pp_exec]	Contains all the pipeline executions for billing download.
Execution Stage [sn_cld_intg_core_pp_exec_stage]	Contains all the pipeline executions for each billing download stage.
Extension Execution [sn_cld_intg_core_pp_exec_stage_ext_log]	Pipeline execution logs.
Execution Stage Log [sn_cld_intg_core_pp_exec_stage_log]	Pipeline execution logs for each stage.
Import Stage [sn_cld_intg_core_pp_import_stage]	Executions details for the import state of billing download.
Cloud Price Sheet Version [sn_cld_intg_core_price_sheet_version]	Price sheet status and version for providers.
sn_cld_intg_azure_storage_ps	Store azure storage price sheet details.
Cloud Product Regions [sn_cld_intg_core_product_region]	List of product regions for various providers.
Profile Execution Metrics [sn_cld_intg_core_profile_execution_metrics]	Execution metrics for performance profiling.
Profile Flow Launcher Job Metrics [sn_cld_intg_core_profile_flow_launcher_job_metrics]	Flow launcher execution metrics for performance profiling.
Profile Flow Metrics [sn_cld_intg_core_profile_flow_metrics]	Flow metrics for performance profiling.
Profile Table Metrics [sn_cld_intg_core_profile_table_metrics]	Table metrics for performance profiling.
Cloud Provider Service [sn_cld_intg_core_provider_service]	List of services provided by various cloud providers & their end points.
Cloud Provider Service Action [sn_cld_intg_core_provider_service_action]	Script include actions for the cloud services provided.
Price Sheet Execution [sn_cld_intg_core_ps_download_request]	Price sheet job status and summary.
Execution Item [n_cld_intg_core_ps_download_request_items]	List of items fetched for every price sheet execution.
Price Sheet Download Execution [sn_cld_intg_core_ps_execution]	Price sheet execution and download information for all scheduled job.
Price Sheet Download Job [sn_cld_intg_core_ps_schedule]	List of the price sheet download jobs created.
Cloud Purchase Options [n_cld_intg_core_purchase_option]	Various purchase options available for providers.
Cloud Regions [sn_cld_intg_core_region]	List of cloud regions available for various providers
Resource Group [sn_cld_intg_core_resource_group]	List of resource groups.
RS Metrics Configuration [sn_cld_intg_core_rs_metrics_configuration]	Metric configurations for rightsizing.
Cloud Billing Schedule [sn_cld_intg_core_schedule]	List of billing download jobs created.
Billing Download Execution [sn_cld_intg_core_scheduled_exec]	Billing download execution and download information for all scheduled jobs.
Cloud Integration Action Schedule Job [sn_cld_intg_core_schedule_job]	Scheduled jobs for invoking cloud actions.
Cloud Integration Action Schedule Trigger [sn_cld_intg_core_schedule_trigger]	Triggers for invoking clod actions scheduled jobs
Storage Details Base [sn_cld_intg_core_storage_detail]	Available storage details for providers.
Storage Option [sn_cld_intg_core_storage_option]	Available storage options for providers
Tag Category [sn_cld_intg_core_tag_category]	List of tag categories having various tags under them.
Tag Name [sn_cld_intg_core_tag_name]	Tag names from the billing data or user generated names.
Tag Name-Category [sn_cld_intg_core_tag_name_category]	Mapping of tag name to category.
Tag Name-Value [sn_cld_intg_core_tag_name_value]	Mapping of tag name to value.
Tag Resource [sn_cld_intg_core_tag_resource]	Tag value pairs associated with a resource.
Tag Value [sn_cld_intg_core_tag_value]	Tag values from the billing data or user generated values.
Test Connection Execution [sn_cld_intg_core_test_connection_execution]	Test connection execution details
Variable [sn_cld_intg_core_variable]	Local variables for integrations core.
GCP CI Placement Type Information [sn_cld_intg_gcp_ci_placement_type]	All types of Configuration Items deployed by Cloud Cost Management for Google Cloud Platform (GCP).
GCP Cost And Usage Bill Data [sn_cld_intg_gcp_cost_usage]	Cost and billing data for GCP.
GCP Product Details [sn_cld_intg_gcp_product_details]	All product details or specifications for GCP.
Google Billing Download Job [sn_cld_intg_gcp_schedule]	Billing download jobs and their status for GCP.
GCP Services [sn_cld_intg_gcp_services]	List of services provided by GCP.
AWS Spend Report Finalization Information [sn_cld_spend_aws_report_finalization_info]	Spend reports finalization status for AWS.
Spend Report Daily Aggregated Cost [sn_cld_spend_core_daily_aggregated_cost]	Spend report on daily basis aggregated on resources.
Spend Report Daily Cost [sn_cld_spend_core_daily_cost]	Spend report for resource usage on daily basis.
Spend Report Forecast Cost [n_cld_spend_core_forecast_cost]	Forecasted spend information.
Spend Report Monthly Cost [sn_cld_spend_core_monthly_cost]	Monthly spend report for resource usage. Important: From Cloud Cost Management version 8.1 onward, if you have installed the Cloud Cost Management Infra Stack application, this table won't be populated.
Spend Report Execution Info [sn_cld_spend_core_report_info]	Spend report execution details.
AWS Rightsizing Analytics Report [sn_clin_aws_rs_analytics_report]	Rightsizing report for AWS.
AWS Rightsizing Skipped Instance Families [sn_clin_aws_rs_skipped_instance_family]	AWS instance families that are not considered in rightsizing recommendations.
Azure Rightsizing Analytics Report [sn_clin_azure_rs_analytics_report]	Rightsizing report for Azure.
Cloud Insights Aggregated Cost Saving Snapshot [sn_clin_core_aggregated_cost_saving_snapshot]	Snapshot of aggregated cost for different service accounts.
Cloud Insights Aggregated Potential Saving Snapshot [sn_clin_core_aggregated_potential_saving_snapshot]	Snapshot of aggregated potential savings from various recommendations.
Cloud Insights Aggregated Realized Saving Snapshot [sn_clin_core_aggregated_realized_saving_snapshot]	Snapshot of the actual realised aggregated savings.
Business Hours Cost [sn_clin_core_bh_cost]	Business hours vs non business hours cost for a resource.
Business Hours Policy [sn_clin_core_bh_policy]	List of policies configured for business hours.
Business Hours Policy Execution [sn_clin_core_bh_policy_execution]	Business hours policy execution information.
Business Hours Policy Match [sn_clin_core_bh_policy_match ]	Policy matches for various resources in the Business hours cost table.
Business Hours Policy Summary [sn_clin_core_bh_policy_summary]	Information summary for the business hour policies.
Cloud Insights Business Hour Recommendations [n_clin_core_bh_recommendation]	Recommendations for business hours.
Business Hours Settings [sn_clin_core_bh_settings]	Settings record for Business hours module.
Budget [sn_clin_core_budget_policy]	List of budget policies & details.
Budget Report Forecast Cost [sn_clin_core_budget_report_forecast_cost]	Spend calculation for the budget.
Budgets Policy Summary [sn_clin_core_budget_summary]	Summaries of budget policies with stats.
Cloud Insights realized saving snapshot [sn_clin_core_daily_realized_saving_snapshot]	Snapshot of the actual realised daily savings.
Excluded Resources Report Mapping [sn_clin_core_exclusion_mapping]	Excluded resource mapping to the type report or recommendation it belongs to.
Excluded Resources [sn_clin_core_excl_res]	List of excluded resources from the Cloud Cost Management modules for different service accounts and providers.
Insights Alias [sn_clin_core_insights_alias]	List of defined aliases for Cloud Cost Management scope.
Insights Alias Mapping [sn_clin_core_insights_alias_mapping]	Alias mapping to the script or action flow for Cloud Cost Management scope.
Insights Execution [sn_clin_core_insights_execution]	Execution details for all Cloud Cost Management executions.
Insights Type [sn_clin_core_insights_type]	List of insights types available for Cloud Cost Management.
M2m Insights Exec Profile Flow Metrics [sn_clin_core_m2m_insights_exec_profile_flow_metrics]	Insights execution to profile flow metrics.
Cloud Insights Policy Action [sn_clin_core_policy_action]	Actions and flows to be executed for a policy.
Policy Change Request Templates [sn_clin_core_policy_change_request_template]	Change request templates for business hours and unassigned recommendations.
Cloud Insights Policy Match [sn_clin_core_policy_match]	Policy matches for various resources and modules.
Policy Summary [sn_clin_core_policy_summary]	Summary of all the policies available
Policy [sn_clin_core_pol_policy]	Policies to be applied on various modules.
Cloud Insights potential saving snapshot [sn_clin_core_potential_saving_snapshot]	Snapshot of the actual realised savings.
Cloud Insights Recommendations [sn_clin_core_recommendation]	Recommendations for Cloud Cost Management modules.
Recommendation Action Job Execution [sn_clin_core_recommendation_action_job_execution]	Job execution status for recommendations.
Reserved Instance Settings [sn_clin_core_reserved_instance_settings]	Settings record for Reserved Instance module.
Reserved Instance Recommendation [sn_clin_core_ri_recommendation]	Recommendations for reserved instances modules.
Rightsizing Analytics Report [sn_clin_core_rs_analytics_report_base]	Potential resources for rightsizing recommendations.
Cloud Insights Job [sn_clin_core_rs_job]	List of jobs for rightsizing or unused machines module.
Cloud Insights Rightsizing Recommendation Automatic [sn_clin_core_rs_recommendation_automatic]	Rightsizing recommendations.
Cloud Insights Rightsizing Recommendation [sn_clin_core_rs_recommendation_base]	Parent table for rightsizing or unused recommendations.
Rightsizing Settings [sn_clin_core_rs_settings]	Settings record for Rightsizing module.
Cloud Insights Unused Recommendation [sn_clin_core_rs_unused_recommendation]	Unused resources recommendations.
Service Account Owner Update Policy [sn_clin_core_sa_owner_policy]	Policies to update the service account owners.
Insights Settings[sn_clin_core_settings]	Settings for various Cloud Cost Management modules.
Tag key [sn_clin_core_tag_key]	Tag keys derived from billing data as well as user generated keys.
Unassigned Resources Count [sn_clin_core_unassigned_count]	Count of unassigned resources for various service accounts.
Cloud Insights Unassigned Policies [sn_clin_core_unassigned_policy]	Policies available for unassigned resources.
Policy CI View [sn_clin_core_unassigned_policy_ci_view_list]	Used for generating unassigned resources count. Contains information about the table to be queried and the encoded query and the columns to be queried in the specified table. The records in this table are manually hardcoded.
Unassigned Policy Summary [sn_clin_core_unassigned_policy_summary]	Policy summaries available for unassigned resources.
Unassigned Recommendations [sn_clin_core_unassigned_recommendation]	Unassigned recommendations with assignment group, generated based on matched policies.
Unassigned Report [sn_clin_core_unassigned_report]	Reports or policy match for various unassigned resources.
Unassigned Resources [sn_clin_core_unassigned_resource]	List of unassigned resources on which policies can be applied.
Unassigned Resource Settings [sn_clin_core_unassigned_settings]	Settings record for Unassigned resources module.
Unused Machine Settings [sn_clin_core_unused_settings]	Settings record for Unused machines module.
Spend Report Monthly Aggregated Costs [sn_cld_spend_core_monthly_aggregated_cost]	Stores spend for all resources over a time range or a cost type.
Multi currency setups [sn_cld_spend_core_multi_currency_setup]	Stores currency options for the Multi-currency setup.
Important: The following tables are used only when the Cloud Cost Management Infra Stack application is installed in addition to Cloud Cost Management version 8.1.
Resource Average Costs [sn_cld_intg_core_resource_avg_cost_list]	Average daily cost of the resource. This average daily cost is used to calculate savings for unused recommendations.
Google Policy Usage Last Downloaded [sn_cld_intg_gcp_resource_usage_last_downloaded]	Usage last downloaded timestamp of the resources. This helps in downloading only the delta usage for Business hours.
AWS billing job files [sn_cld_intg_aws_billing_files]	Reference and status of the attachments of billing CSV files downloaded for a corresponding billing job of AWS assume role setup.
Azure billing Job chunk blob detail [sn_cld_intg_azure_job_chunk_blob_detail]	Tracking and download URLs of Azure billing CSV data for a given date range corresponding to a billing job. Blobs are generated on Glide and download URLs are passed to the backend.
Resource Latest Usage sn_cld_intg_core_resource_latest_usage	Latest usage date and corresponding pivot key of the supported resources like VM, DB, storage, and snapshots for a specific provider. Resources used on the previous day are used for license calculation.
Spend Report Monthly Provider Agg Cost sn_cld_spend_core_monthly_provider_agg_cost	Cloud Cost Management Workspace loads data from these tables when a user logs in with the insights_admin role. These tables contain monthly aggregated spend data based on various categories such as Provider and Region.
Spend Report Monthly Master Account Agg Cost sn_cld_spend_core_monthly_master_account_agg_cost
Spend Report Monthly Service Account Agg Cost sn_cld_spend_core_monthly_service_account_agg_cost
Spend Report Monthly Purchase Option Agg Cost sn_cld_spend_core_monthly_purchase_option_agg_cost
Spend Report Monthly Region Agg Cost sn_cld_spend_core_monthly_region_agg_cost
Spend Report Monthly Cloud Category Agg Cost sn_cld_spend_core_monthly_cloud_category_agg_cost
Spend Report Monthly Service Category Agg Cost sn_cld_spend_core_monthly_service_category_agg_cost
Spend Report Monthly Resource Group Agg Cost sn_cld_spend_core_monthly_resource_group_agg_cost
Spend Report Monthly Tag Agg Cost sn_cld_spend_core_monthly_tag_agg_cost