What are the core tables involved in Cloud Cost Management where I can find cost related data ?
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
4 weeks ago
What are the tables related to cloud cost management ? In which tables can I find data related to cloud expenses, budget, savings, etc ?
2 REPLIES 2
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
4 weeks ago
Hi @ankurc2 ,
In Cloud Cost Management (CCM), data is spread across several specialized tables. Here are the core ones to look at:
Billing Data: sn_cld_spend_bill_line_item (Raw/processed line items) and sn_cld_spend_tag_values (Mapped tags).
Budgets: sn_cld_spend_budget and sn_cld_spend_budget_threshold.
Savings/Optimization: sn_cld_spend_optimization_recommendation and sn_cld_spend_reclamation_candidate.
Aggregated Spend: sn_cld_spend_account_monthly_spend.
Note: If you're on an older version, look for the sn_cloud_insights_ prefix instead. You can find the full list by filtering Tables for names containing sn_cld_spend.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
4 weeks ago
Here is table name with Servicenow documentation link:
| Name | Label | Application |
| sn_cld_intg_core_action_exec | Cloud Action Execution | Cloud Integrations Core |
| sn_cld_intg_core_alias | Cloud Alias | Cloud Integrations Core |
| sn_cld_intg_core_alias_mapping | Cloud Alias Mapping | Cloud Integrations Core |
| sn_cld_intg_core_api_request | Cloud API Request | Cloud Integrations Core |
| sn_cld_intg_core_api_request_error | Cloud API Request Error | Cloud Integrations Core |
| sn_cld_intg_core_api_request_item | Cloud API Request Item | Cloud Integrations Core |
| sn_cld_intg_core_api_response | Cloud API Response | Cloud Integrations Core |
| sn_cld_intg_core_availability_zone | Cloud Availability Zones | Cloud Integrations Core |
| sn_cld_intg_core_billing_report_info | Billing Report Information | Cloud Integrations Core |
| sn_cld_intg_core_bill_imp_progress | Billing Import Progress | Cloud Integrations Core |
| sn_cld_intg_core_ci_placement_stats | CI Placement Stats | Cloud Integrations Core |
| sn_cld_intg_core_ci_placement_status | CI Placement Status | Cloud Integrations Core |
| sn_cld_intg_core_ci_placement_type | CI Placement Type Information | Cloud Integrations Core |
| sn_cld_intg_core_cost_tags | Cost Tags | Cloud Integrations Core |
| sn_cld_intg_core_execution | Execution | Cloud Integrations Core |
| sn_cld_intg_core_execution_batch | Execution Batch | Cloud Integrations Core |
| sn_cld_intg_core_execution_batch_map | Execution To Batch Map | Cloud Integrations Core |
| sn_cld_intg_core_execution_log | Execution Log | Cloud Integrations Core |
| sn_cld_intg_core_execution_metric | Execution Metric | Cloud Integrations Core |
| sn_cld_intg_core_execution_monitor | Execution Monitor | Cloud Integrations Core |
| sn_cld_intg_core_ext | Extension | Cloud Integrations Core |
| sn_cld_intg_core_ext_type | Extension Type | Cloud Integrations Core |
| sn_cld_intg_core_flow_launcher_execution | Flow Launcher Execution | Cloud Integrations Core |
| sn_cld_intg_core_flow_launcher_job | Flow Launcher Job | Cloud Integrations Core |
| sn_cld_intg_core_flow_launcher_job_config | Flow Launcher Job Configuration | Cloud Integrations Core |
| sn_cld_intg_core_flow_launcher_workload | Flow Launcher Workload | Cloud Integrations Core |
| sn_cld_intg_core_flow_map | Flow Map | Cloud Integrations Core |
| sn_cld_intg_core_flow_reflection | Flow Reflection | Cloud Integrations Core |
| sn_cld_intg_core_hierarchical_flow_launcher_execution | Hierarchical Flow Launcher Execution | Cloud Integrations Core |
| sn_cld_intg_core_importbill | ImportBill | Cloud Integrations Core |
| sn_cld_intg_core_imported_date_range | Imported Date Range | Cloud Integrations Core |
| sn_cld_intg_core_import_aws_combined | Import aws combined | Cloud Integrations Core |
| sn_cld_intg_core_import_combined_azure | Import combined azure | Cloud Integrations Core |
| sn_cld_intg_core_import_combined_google | Import combined google | Cloud Integrations Core |
| sn_cld_intg_core_import_vendor_bills | Import Vendor Bills | Cloud Integrations Core |
| sn_cld_intg_core_instance_family | Instance Family | Cloud Integrations Core |
| sn_cld_intg_core_instance_type | Cloud Instance Types | Cloud Integrations Core |
| sn_cld_intg_core_instance_type_family | Cloud Instance Type Family | Cloud Integrations Core |
| sn_cld_intg_core_line_item_type | Billing Line Item Types | Cloud Integrations Core |
| sn_cld_intg_core_m2m_ext_exec_flow_exec | Associated Flow Execution | Cloud Integrations Core |
| sn_cld_intg_core_m2m_profile_exec_metrics_profile_table_metrics | M2m Profile Exec Metrics Profile Table Metrics | Cloud Integrations Core |
| sn_cld_intg_core_map_pp_stage_ext_type | Pipleline Stage Extension Type Map | Cloud Integrations Core |
| sn_cld_intg_core_os_type | Cloud Operating Systems | Cloud Integrations Core |
| sn_cld_intg_core_pp_exec | Pipeline Execution | Cloud Integrations Core |
| sn_cld_intg_core_pp_exec_stage | Execution Stage | Cloud Integrations Core |
| sn_cld_intg_core_pp_exec_stage_ext_log | Extension Execution | Cloud Integrations Core |
| sn_cld_intg_core_pp_exec_stage_log | Execution Stage Log | Cloud Integrations Core |
| sn_cld_intg_core_pp_import_stage | Import Stage | Cloud Integrations Core |
| sn_cld_intg_core_price_sheet_version | Cloud Price Sheet Version | Cloud Integrations Core |
| sn_cld_intg_core_product_region | Cloud Product Regions | Cloud Integrations Core |
| sn_cld_intg_core_profile_execution_metrics | Profile Execution Metrics | Cloud Integrations Core |
| sn_cld_intg_core_profile_flow_launcher_job_metrics | Profile Flow Launcher Job Metrics | Cloud Integrations Core |
| sn_cld_intg_core_profile_flow_metrics | Profile Flow Metrics | Cloud Integrations Core |
| sn_cld_intg_core_profile_table_metrics | Profile Table Metrics | Cloud Integrations Core |
| sn_cld_intg_core_provider_service | Cloud Provider Service | Cloud Integrations Core |
| sn_cld_intg_core_provider_service_action | Cloud Provider Service Action | Cloud Integrations Core |
| sn_cld_intg_core_ps_download_request | Price Sheet Execution | Cloud Integrations Core |
| sn_cld_intg_core_ps_download_request_items | Execution Item | Cloud Integrations Core |
| sn_cld_intg_core_ps_execution | Price Sheet Download Execution | Cloud Integrations Core |
| sn_cld_intg_core_ps_schedule | Price Sheet Download Job | Cloud Integrations Core |
| sn_cld_intg_core_purchase_option | Cloud Purchase Options | Cloud Integrations Core |
| sn_cld_intg_core_region | Cloud Regions | Cloud Integrations Core |
| sn_cld_intg_core_resource_avg_cost | Resource Average Cost | Cloud Integrations Core |
| sn_cld_intg_core_resource_group | Resource Group | Cloud Integrations Core |
| sn_cld_intg_core_resource_latest_usage | Resource Latest Usage | Cloud Integrations Core |
| sn_cld_intg_core_rs_metrics_configuration | Rightsizing Metrics Configuration | Cloud Integrations Core |
| sn_cld_intg_core_schedule | Cloud Billing Schedule | Cloud Integrations Core |
| sn_cld_intg_core_scheduled_exec | Billing Download Execution | Cloud Integrations Core |
| sn_cld_intg_core_schedule_job | Cloud Integration Action Schedule Job | Cloud Integrations Core |
| sn_cld_intg_core_schedule_trigger | Cloud Integration Action Schedule Trigger | Cloud Integrations Core |
| sn_cld_intg_core_storage_detail | Storage Details Base | Cloud Integrations Core |
| sn_cld_intg_core_storage_option | Storage Option | Cloud Integrations Core |
| sn_cld_intg_core_synchronization_mutex | Synchronization mutex | Cloud Integrations Core |
| sn_cld_intg_core_tag_category | Tag Category | Cloud Integrations Core |
| sn_cld_intg_core_tag_name | Tag Name | Cloud Integrations Core |
| sn_cld_intg_core_tag_name_category | Tag Name-Category | Cloud Integrations Core |
| sn_cld_intg_core_tag_name_value | Tag Name-Value | Cloud Integrations Core |
| sn_cld_intg_core_tag_resource | Tag Resource | Cloud Integrations Core |
| sn_cld_intg_core_tag_value | Tag Value | Cloud Integrations Core |
| sn_cld_intg_core_test_connection_execution | Test Connection Execution | Cloud Integrations Core |
| sn_cld_intg_core_variable | Variable | Cloud Integrations Core |
| sn_cld_spend_core_daily_aggregated_cost | Spend Report Daily Aggregated Cost | Cloud Spend Reports Core |
| sn_cld_spend_core_daily_cost | Spend Report Daily Cost | Cloud Spend Reports Core |
| sn_cld_spend_core_forecast_cost | Spend Report Forecast Cost | Cloud Spend Reports Core |
| sn_cld_spend_core_monthly_aggregated_cost | Spend Report Monthly Aggregated Cost | Cloud Spend Reports Core |
| sn_cld_spend_core_monthly_cloud_category_agg_cost | Spend Report Monthly Cloud Category Agg Cost | Cloud Spend Reports Core |
| sn_cld_spend_core_monthly_cost | Spend Report Monthly Cost | Cloud Spend Reports Core |
| sn_cld_spend_core_monthly_master_account_agg_cost | Spend Report Monthly Master Account Agg Cost | Cloud Spend Reports Core |
| sn_cld_spend_core_monthly_provider_agg_cost | Spend Report Monthly Provider Agg Cost | Cloud Spend Reports Core |
| sn_cld_spend_core_monthly_purchase_option_agg_cost | Spend Report Monthly Purchase Option Agg Cost | Cloud Spend Reports Core |
| sn_cld_spend_core_monthly_region_agg_cost | Spend Report Monthly Region Agg Cost | Cloud Spend Reports Core |
| sn_cld_spend_core_monthly_resource_group_agg_cost | Spend Report Monthly Resource Group Agg Cost | Cloud Spend Reports Core |
| sn_cld_spend_core_monthly_service_account_agg_cost | Spend Report Monthly Service Account Agg Cost | Cloud Spend Reports Core |
| sn_cld_spend_core_monthly_service_category_agg_cost | Spend Report Monthly Service Category Agg Cost | Cloud Spend Reports Core |
| sn_cld_spend_core_monthly_shared_cost | Spend Report Monthly Shared Cost | Cloud Spend Reports Core |
| sn_cld_spend_core_monthly_tag_agg_cost | Spend Report Monthly Tag Agg Cost | Cloud Spend Reports Core |
| sn_cld_spend_core_multi_currency_setup | Multi currency setup | Cloud Spend Reports Core |
| sn_cld_spend_core_report_info | Spend Report Execution Info | Cloud Spend Reports Core |
| sn_cld_spend_core_sc_policy | Shared Cost Policy | Cloud Spend Reports Core |
| sn_cld_spend_core_sc_policy_execution | Shared Cost Policy Execution | Cloud Spend Reports Core |
| sn_cld_spend_core_sc_policy_target | Shared Cost Policy Target | Cloud Spend Reports Core |
| sn_cld_spend_core_trend | Spend Report Trend (Deprecated) | Cloud Spend Reports Core |
