{"revision":"c10276e953456835cdbb1f3a60d58ae1980be353","document":{"id":24807,"path":"it-asset-management/cloud-cost-management/installed-with-ci.md","title":"Components installed with Cloud Cost Management","bundle":null,"doc_type":null,"release":"australia","body":"\n# Components installed with Cloud Cost Management\n\nSeveral types of components are installed with activation of the Cloud Cost Management application, including tables, user roles, and scheduled jobs.\n\n## Scheduled jobs installed\n\n\n
\n\nScheduled job\n\n\n\nDescription\n\n
\n\nPrice Sheet Table Cleaner\n\n\n\nCleans up AWS price sheet records.\n\n
\n\nResource Group Table Cleaner\n\n\n\nCleans up Azure resource group records that are no longer required.\n\n
\n\nCCM CleanUp Inactive Aggregated Spend Records\n\n\n\nCleans up inactive aggregated spend records.\n\n
\n\nCloud Insights Historical Data Collection\n\n\n\nCollects GCP spend data.\n\n
\n\nCloud Insights Saving Daily Data Collection\n\n\n\nCollects potential savings and realized savings for spend.\n\n
\n\nCloud Insights Spend Saving Data Collection\n\n\n\nCollects cloud spend potential saving percentage.\n\n
\n\nExecute Tasks\n\n\n\nExecutes tasks associated with AWS billing download.\n\n
\n\nFlow Launcher and Hierarchical Flow Launcher Keep Alive\n\n\n\nCancels stale flow jobs.\n\n
\n\nGCP Price Sheet Table Cleaner\n\n\n\nCleans up GCP Price sheet table\n\n
\n\nTag Categories Based Recommendation\n\n\n\nGenerates Tag Category based recommendations.\n\n
\n\n**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.\n\n
\n\nCumulus- Cancel stuck job\n\n\n\nMonitors scheduled billing jobs and cancels the jobs that are stuck. This enables billing jobs in the queue to be processed.\n\n
\n\nUnsupported CI Type Placement\n\n\n\nPlaces the CI types that aren’t used for daily recommendations.\n\n
\n\nCCM - Daily job\n\n\n\nPerforms daily maintenance activities such as cleanup of left-out attachments of AWS billing job \\(with assume role authentication\\).\n\n
## Tables installed\n\n\n
\n\nTable\n\n\n\nDescription\n\n
\n\nCI Placement Extension Progress Calculation \\[sn\\_cld\\_intg\\_aws\\_ci\\_placement\\_extension\\_progress\\_calculation\\]\n\n\n\nConfiguration Items placement progress for AWS. Contains number of records to be processed by the AWS extension.\n\n
\n\nCI Placement Stats \\[sn\\_cld\\_intg\\_aws\\_ci\\_placement\\_stats\\]\n\n\n\nStatus of bookmarks created during the Configuration Items placement for AWS.\n\n
\n\nAWS CI Placement Type Information \\[sn\\_cld\\_intg\\_aws\\_ci\\_placement\\_type\\]\n\n\n\nAll types of Configuration Items deployed byCloud Cost Management for AWS.\n\n
\n\nAWS Cost And Usage Bill Data \\[sn\\_cld\\_intg\\_aws\\_cost\\_usage\\]\n\n\n\nCost and billing data for AWS.\n\n
\n\nCost Usage Bookmarks \\[sn\\_cld\\_intg\\_aws\\_cost\\_usage\\_bookmarks\\]\n\n\n\nTime stamp bookmarks created for the ingested Cloud Cost Management placement records.\n\n
\n\nCloudWatch Metric Association \\[sn\\_cld\\_intg\\_aws\\_cw\\_metric\\_association\\]\n\n\n\nCustom metrics created by user.\n\n
\n\nAWS CloudWatch Metric Definition \\[sn\\_cld\\_intg\\_aws\\_cw\\_metric\\_definition\\]\n\n\n\nDefinitions for various AWS cloud watch metrics.\n\n
\n\nCloudWatch Metric Definition to Account \\[sn\\_cld\\_intg\\_aws\\_cw\\_metric\\_definition\\_account\\_m2m\\]\n\n\n\nMetric to service account mapping information.\n\n
\n\nAWS Baseline Performance for EC2 Burstable Instances \\[sn\\_cld\\_intg\\_aws\\_ec2\\_burstable\\_baseline\\_perf\\]\n\n\n\nBaseline performance percentage for AWS EC2 burstable instances.\n\n
\n\nAWS Gov Accounts Mapping \\[sn\\_cld\\_intg\\_aws\\_gov\\_account\\_mapping\\]\n\n\n\nAWS Gov accounts and linked accounts details.\n\n
\n\nAWS Instance details \\[sn\\_cld\\_intg\\_aws\\_instance\\_detail\\]\n\n\n\nDetails for various AWS instances present.\n\n
\n\nAWS Instance Price details \\[sn\\_cld\\_intg\\_aws\\_instance\\_price\\_detail\\]\n\n\n\nPricing and rate details for AWS instances.\n\n
\n\nAWS Offer Term \\[sn\\_cld\\_intg\\_aws\\_offer\\_term\\]\n\n\n\nOffer term details based on configurations of AWS products.\n\n
\n\nAWS Price Discount \\[sn\\_cld\\_intg\\_aws\\_price\\_discount\\]\n\n\n\nPrice discounts for AWS service accounts.\n\n
\n\nAWS Price Sheet Information \\[sn\\_cld\\_intg\\_aws\\_price\\_sheet\\_info\\]\n\n\n\nPrice sheet details for AWS.\n\n
\n\nAWS Product Details Base \\[sn\\_cld\\_intg\\_aws\\_product\\_details\\]\n\n\n\nAll product details or specifications for AWS.\n\n
\n\nAWS Product Details EC2 \\[sn\\_cld\\_intg\\_aws\\_product\\_details\\_ec2\\]\n\n\n\nEC2 product details or specifications for AWS.\n\n
\n\nAWS Product Details RDS \\[sn\\_cld\\_intg\\_aws\\_product\\_details\\_rds\\]\n\n\n\nRDS product details or specifications for AWS.\n\n
\n\nAWS Resource Hourly Usage Last Downloaded \\[sn\\_cld\\_intg\\_aws\\_resource\\_hourly\\_usage\\_last\\_downloaded\\]\n\n\n\nHourly usage download status for AWS resources.\n\n
\n\nAWS Resource Rate \\[sn\\_cld\\_intg\\_aws\\_resource\\_rate\\]\n\n\n\nResource rates for AWS product SKUs.\n\n
\n\nAWS Billing Download Job \\[sn\\_cld\\_intg\\_aws\\_schedule\\]\n\n\n\nBilling download jobs and their status for AWS.\n\n
\n\nAWS Storage Price Details \\[sn\\_cld\\_intg\\_aws\\_storage\\_price\\_detail\\]\n\n\n\nStorage price sheet information for AWS.\n\n
\n\nAzure CI Placement Type Information \\[sn\\_cld\\_intg\\_azure\\_ci\\_placement\\_type\\]\n\n\n\nDefines all types of Configuration Items deployed by Cloud Cost Management for Azure.\n\n
\n\nAzure Cost And Usage Bill Data \\[sn\\_cld\\_intg\\_azure\\_cost\\_usage\\]\n\n\n\nCost and billing data for Azure.\n\n
\n\nAzure Database Price Sheet \\[sn\\_cld\\_intg\\_azure\\_db\\_price\\_sheet\\]\n\n\n\nPrice sheet details for Azure database.\n\n
\n\nAzure Database retail price detail \\[sn\\_cld\\_intg\\_azure\\_db\\_retail\\_price\\]\n\n\n\nRetail price information for Azure database.\n\n
\n\nAzure Enrollment To Service Account Mapping \\[sn\\_cld\\_intg\\_azure\\_ea\\_sa\\_mapping\\]\n\n\n\nMapping information for enrollment account to the service accounts used by Cloud Cost Management.\n\n
\n\nAzure Instance Details \\[sn\\_cld\\_intg\\_azure\\_instance\\_detail\\]\n\n\n\nDetails of various Azure instances present.\n\n
\n\nAzure Instance Price Details \\[sn\\_cld\\_intg\\_azure\\_instance\\_price\\_detail\\]\n\n\n\nPricing and rate details for Azure instances.\n\n
\n\nAzure Instance Series To Family Mapping \\[sn\\_cld\\_intg\\_azure\\_instance\\_series\\_family\\_mapping\\]\n\n\n\nInstance family to instance series mapping information for Azure.\n\n
\n\nAzure Instance Size Details \\[sn\\_cld\\_intg\\_azure\\_instance\\_size\\_detail\\]\n\n\n\nDetails about various Azure instances sizes & their functionalities.\n\n
\n\nAzure Normalized Region \\[sn\\_cld\\_intg\\_azure\\_normalized\\_region\\]\n\n\n\nResource location to a generic normalized location mapping information.\n\n
\n\nAzure Price Sheet Version \\[sn\\_cld\\_intg\\_azure\\_price\\_sheet\\_version\\]\n\n\n\nPrice sheet status and version for Azure.\n\n
\n\nAzure Product Details \\[sn\\_cld\\_intg\\_azure\\_product\\_details\\]\n\n\n\nAll product details or specifications for Azure.\n\n
\n\nAzure Product Details VM \\[sn\\_cld\\_intg\\_azure\\_product\\_details\\_vm\\]\n\n\n\nVirtual Machine product details or specifications for Azure.\n\n
\n\nAzure Product Offering VM \\[sn\\_cld\\_intg\\_azure\\_product\\_offering\\_vm\\]\n\n\n\nOffer term details for Azure Virtual Machine service.\n\n
\n\nAzure Product Details Instance Type Map \\[sn\\_cld\\_intg\\_azure\\_prod\\_dtls\\_inst\\_type\\_map\\]\n\n\n\nProduct details for various instance types for Azure.\n\n
\n\nAzure Advisor Subscription Queue \\[sn\\_cld\\_intg\\_azure\\_recommendation\\_subscription\\_queue\\]\n\n\n\nStores the states of generate, get generate status and list recommendations flow launcher jobs, for provider based recommendations of Azure.\n\n
\n\nAzure resource hourly usage last downloaded \\[sn\\_cld\\_intg\\_azure\\_resource\\_hourly\\_usage\\_last\\_downloaded\\]\n\n\n\nHourly usage download status for Azure resources.\n\n
\n\nAzure Resource Rate \\[sn\\_cld\\_intg\\_azure\\_resource\\_rate\\]\n\n\n\nResource rates for Azure meter IDs.\n\n
\n\nAzure Billing Download Job \\[sn\\_cld\\_intg\\_azure\\_schedule\\]\n\n\n\nBilling download jobs and their status for Azure.\n\n
\n\nAzure Software Cost Details \\[n\\_cld\\_intg\\_azure\\_software\\_cost\\_detail\\]\n\n\n\nHourly cost details for Azure software.\n\n
\n\nAzure Storage Price Details \\[sn\\_cld\\_intg\\_azure\\_storage\\_price\\_detail\\]\n\n\n\nStorage price sheet information for Azure.\n\n
\n\nAzure Storage Size Details \\[sn\\_cld\\_intg\\_azure\\_storage\\_size\\_detail\\]\n\n\n\nVarious Azure storage sizes & their functionalities.\n\n
\n\nCloud Action Execution \\[sn\\_cld\\_intg\\_core\\_action\\_exec\\]\n\n\n\nExecution details for various cloud actions.\n\n
\n\nCloud Alias \\[sn\\_cld\\_intg\\_core\\_alias\\]\n\n\n\nList of defined aliases.\n\n
\n\nCloud Alias Mapping \\[sn\\_cld\\_intg\\_core\\_alias\\_mapping\\]\n\n\n\nAlias mapping to the script or action flow.\n\n
\n\nCloud API Request \\[sn\\_cld\\_intg\\_core\\_api\\_request\\]\n\n\n\nAPI request & parameters sent to the provider.\n\n
\n\nCloud API Request Error \\[sn\\_cld\\_intg\\_core\\_api\\_request\\_error\\]\n\n\n\nError responses for failed request items.\n\n
\n\nCloud API Request Item \\[sn\\_cld\\_intg\\_core\\_api\\_request\\_item\\]\n\n\n\nAPI request item details sent to the provider.\n\n
\n\nCloud API Response \\[sn\\_cld\\_intg\\_core\\_api\\_response\\]\n\n\n\nAPI responses for the API calls made to providers.\n\n
\n\nCloud Availability Zones \\[sn\\_cld\\_intg\\_core\\_availability\\_zone\\]\n\n\n\nAvailability zones for various providers.\n\n
\n\nBilling Report Information \\[sn\\_cld\\_intg\\_core\\_billing\\_report\\_info\\]\n\n\n\nBilling summary reports for billing download jobs.\n\n
\n\nBilling Import Progress \\[sn\\_cld\\_intg\\_core\\_bill\\_imp\\_progress\\]\n\n\n\nImport information for various extensions under billing download job.\n\n
\n\nCI Placement Stats \\[sn\\_cld\\_intg\\_core\\_ci\\_placement\\_stats\\]\n\n\n\nStatus of bookmarks created during Configuration Items placement.\n\n
\n\nCI Placement Status \\[sn\\_cld\\_intg\\_core\\_ci\\_placement\\_status\\]\n\n\n\nConfiguration Items placement status for extensions executed.\n\n
\n\nCI Placement Type Information \\[sn\\_cld\\_intg\\_core\\_ci\\_placement\\_type\\]\n\n\n\nAll types of Configuration Items deployed by our product for all providers.\n\n
\n\nCost Tags \\[sn\\_cld\\_intg\\_core\\_cost\\_tags\\]\n\n\n\nMapping information of tag category to cost hash.\n\n
\n\nExecution \\[sn\\_cld\\_intg\\_core\\_execution\\]\n\n\n\nExecution details for all types of running IH flows.\n\n
\n\nExecution Batch \\[sn\\_cld\\_intg\\_core\\_execution\\_batch\\]\n\n\n\nExecution batches for running the flows.\n\n
\n\nExecution To Batch Map \\[sn\\_cld\\_intg\\_core\\_execution\\_batch\\_map\\]\n\n\n\nMapping information of execution jobs to the respective batches.\n\n
\n\nExecution Log \\[sn\\_cld\\_intg\\_core\\_execution\\_log\\]\n\n\n\nLog messages for all the executions.\n\n
\n\nExecution Metric \\[sn\\_cld\\_intg\\_core\\_execution\\_metric\\]\n\n\n\nMetrics for executions.\n\n
\n\nExecution Monitor \\[sn\\_cld\\_intg\\_core\\_execution\\_monitor\\]\n\n\n\nLive status of the ongoing execution.\n\n
\n\nExtension \\[sn\\_cld\\_intg\\_core\\_ext\\]\n\n\n\nAll the available extensions and their details.\n\n
\n\nExtension Type \\[sn\\_cld\\_intg\\_core\\_ext\\_type\\]\n\n\n\nTypes of extensions defined.\n\n
\n\nFlow Launcher Execution \\[sn\\_cld\\_intg\\_core\\_flow\\_launcher\\_execution\\]\n\n\n\nFlow launcher job execution details.\n\n
\n\nFlow Launcher Job \\[sn\\_cld\\_intg\\_core\\_flow\\_launcher\\_job\\]\n\n\n\nList of flow launcher jobs and their status.\n\n
\n\nFlow Launcher Job Configuration \\[sn\\_cld\\_intg\\_core\\_flow\\_launcher\\_job\\_config\\]\n\n\n\nConfigurations for flow launcher jobs.\n\n
\n\nFlow Launcher Workload \\[sn\\_cld\\_intg\\_core\\_flow\\_launcher\\_workload\\]\n\n\n\nWorkload information for flow launcher executions.\n\n
\n\nFlow Map \\[sn\\_cld\\_intg\\_core\\_flow\\_map\\]\n\n\n\nMapping information of input parameters to the flow workloads.\n\n
\n\nFlow Reflection \\[sn\\_cld\\_intg\\_core\\_flow\\_reflection\\]\n\n\n\nFlow reflection link in flow designer for given context.\n\n
\n\nHierarchical Flow Launcher Execution \\[sn\\_cld\\_intg\\_core\\_hierarchical\\_flow\\_launcher\\_execution\\]\n\n\n\nHierarchical flow launcher job execution details.\n\n
\n\nImported Date Range \\[sn\\_cld\\_intg\\_core\\_imported\\_date\\_range\\]\n\n\n\nImported date range of data during billing download execution.\n\n
\n\nInstance Family \\[sn\\_cld\\_intg\\_core\\_instance\\_family\\]\n\n\n\nInstance families available for various providers.\n\n
\n\nCloud Instance Types \\[sn\\_cld\\_intg\\_core\\_instance\\_type\\]\n\n\n\nInstance types & details for various providers.\n\n
\n\nCloud Instance Type Family \\[sn\\_cld\\_intg\\_core\\_instance\\_type\\_family\\]\n\n\n\nInstance family types available for various providers.\n\n
\n\nBilling Line Item Types \\[ sn\\_cld\\_intg\\_core\\_line\\_item\\_type\\]\n\n\n\nTypes of billing charges for various providers.\n\n
\n\nAssociated Flow Execution \\[sn\\_cld\\_intg\\_core\\_m2m\\_ext\\_exec\\_flow\\_exec\\]\n\n\n\nMapping information of extension execution to flow execution.\n\n
\n\nM2m Profile Exec Metrics Profile Table Metrics \\[sn\\_cld\\_intg\\_core\\_m2m\\_profile\\_exec\\_metrics\\_profile\\_table\\_metrics\\]\n\n\n\nMapping information of profile execution to profile table metrics.\n\n
\n\nPipeline Stage Extension Type Map \\[sn\\_cld\\_intg\\_core\\_map\\_pp\\_stage\\_ext\\_type\\]\n\n\n\nMapping information of extension types to their respective stages.\n\n
\n\nCloud Operating Systems \\[sn\\_cld\\_intg\\_core\\_os\\_type\\]\n\n\n\nOperating system details for various providers.\n\n
\n\nPipeline Execution \\[sn\\_cld\\_intg\\_core\\_pp\\_exec\\]\n\n\n\nContains all the pipeline executions for billing download.\n\n
\n\nExecution Stage \\[sn\\_cld\\_intg\\_core\\_pp\\_exec\\_stage\\]\n\n\n\nContains all the pipeline executions for each billing download stage.\n\n
\n\nExtension Execution \\[sn\\_cld\\_intg\\_core\\_pp\\_exec\\_stage\\_ext\\_log\\]\n\n\n\nPipeline execution logs.\n\n
\n\nExecution Stage Log \\[sn\\_cld\\_intg\\_core\\_pp\\_exec\\_stage\\_log\\]\n\n\n\nPipeline execution logs for each stage.\n\n
\n\nImport Stage \\[sn\\_cld\\_intg\\_core\\_pp\\_import\\_stage\\]\n\n\n\nExecutions details for the import state of billing download.\n\n
\n\nCloud Price Sheet Version \\[sn\\_cld\\_intg\\_core\\_price\\_sheet\\_version\\]\n\n\n\nPrice sheet status and version for providers.\n\n
\n\nsn\\_cld\\_intg\\_azure\\_storage\\_ps\n\n\n\nStore azure storage price sheet details.\n\n
\n\nCloud Product Regions \\[sn\\_cld\\_intg\\_core\\_product\\_region\\]\n\n\n\nList of product regions for various providers.\n\n
\n\nProfile Execution Metrics \\[sn\\_cld\\_intg\\_core\\_profile\\_execution\\_metrics\\]\n\n\n\nExecution metrics for performance profiling.\n\n
\n\nProfile Flow Launcher Job Metrics \\[sn\\_cld\\_intg\\_core\\_profile\\_flow\\_launcher\\_job\\_metrics\\]\n\n\n\nFlow launcher execution metrics for performance profiling.\n\n
\n\nProfile Flow Metrics \\[sn\\_cld\\_intg\\_core\\_profile\\_flow\\_metrics\\]\n\n\n\nFlow metrics for performance profiling.\n\n
\n\nProfile Table Metrics \\[sn\\_cld\\_intg\\_core\\_profile\\_table\\_metrics\\]\n\n\n\nTable metrics for performance profiling.\n\n
\n\nCloud Provider Service \\[sn\\_cld\\_intg\\_core\\_provider\\_service\\]\n\n\n\nList of services provided by various cloud providers & their end points.\n\n
\n\nCloud Provider Service Action \\[sn\\_cld\\_intg\\_core\\_provider\\_service\\_action\\]\n\n\n\nScript include actions for the cloud services provided.\n\n
\n\nPrice Sheet Execution \\[sn\\_cld\\_intg\\_core\\_ps\\_download\\_request\\]\n\n\n\nPrice sheet job status and summary.\n\n
\n\nExecution Item \\[n\\_cld\\_intg\\_core\\_ps\\_download\\_request\\_items\\]\n\n\n\nList of items fetched for every price sheet execution.\n\n
\n\nPrice Sheet Download Execution \\[sn\\_cld\\_intg\\_core\\_ps\\_execution\\]\n\n\n\nPrice sheet execution and download information for all scheduled job.\n\n
\n\nPrice Sheet Download Job \\[sn\\_cld\\_intg\\_core\\_ps\\_schedule\\]\n\n\n\nList of the price sheet download jobs created.\n\n
\n\nCloud Purchase Options \\[n\\_cld\\_intg\\_core\\_purchase\\_option\\]\n\n\n\nVarious purchase options available for providers.\n\n
\n\nCloud Regions \\[sn\\_cld\\_intg\\_core\\_region\\]\n\n\n\nList of cloud regions available for various providers\n\n
\n\nResource Group \\[sn\\_cld\\_intg\\_core\\_resource\\_group\\]\n\n\n\nList of resource groups.\n\n
\n\nRS Metrics Configuration \\[sn\\_cld\\_intg\\_core\\_rs\\_metrics\\_configuration\\]\n\n\n\nMetric configurations for rightsizing.\n\n
\n\nCloud Billing Schedule \\[sn\\_cld\\_intg\\_core\\_schedule\\]\n\n\n\nList of billing download jobs created.\n\n
\n\nBilling Download Execution \\[sn\\_cld\\_intg\\_core\\_scheduled\\_exec\\]\n\n\n\nBilling download execution and download information for all scheduled jobs.\n\n
\n\nCloud Integration Action Schedule Job \\[sn\\_cld\\_intg\\_core\\_schedule\\_job\\]\n\n\n\nScheduled jobs for invoking cloud actions.\n\n
\n\nCloud Integration Action Schedule Trigger \\[sn\\_cld\\_intg\\_core\\_schedule\\_trigger\\]\n\n\n\nTriggers for invoking clod actions scheduled jobs\n\n
\n\nStorage Details Base \\[sn\\_cld\\_intg\\_core\\_storage\\_detail\\]\n\n\n\nAvailable storage details for providers.\n\n
\n\nStorage Option \\[sn\\_cld\\_intg\\_core\\_storage\\_option\\]\n\n\n\nAvailable storage options for providers\n\n
\n\nTag Category \\[sn\\_cld\\_intg\\_core\\_tag\\_category\\]\n\n\n\nList of tag categories having various tags under them.\n\n
\n\nTag Name \\[sn\\_cld\\_intg\\_core\\_tag\\_name\\]\n\n\n\nTag names from the billing data or user generated names.\n\n
\n\nTag Name-Category \\[sn\\_cld\\_intg\\_core\\_tag\\_name\\_category\\]\n\n\n\nMapping of tag name to category.\n\n
\n\nTag Name-Value \\[sn\\_cld\\_intg\\_core\\_tag\\_name\\_value\\]\n\n\n\nMapping of tag name to value.\n\n
\n\nTag Resource \\[sn\\_cld\\_intg\\_core\\_tag\\_resource\\]\n\n\n\nTag value pairs associated with a resource.\n\n
\n\nTag Value \\[sn\\_cld\\_intg\\_core\\_tag\\_value\\]\n\n\n\nTag values from the billing data or user generated values.\n\n
\n\nTest Connection Execution \\[sn\\_cld\\_intg\\_core\\_test\\_connection\\_execution\\]\n\n\n\nTest connection execution details\n\n
\n\nVariable \\[sn\\_cld\\_intg\\_core\\_variable\\]\n\n\n\nLocal variables for integrations core.\n\n
\n\nGCP CI Placement Type Information \\[sn\\_cld\\_intg\\_gcp\\_ci\\_placement\\_type\\]\n\n\n\nAll types of Configuration Items deployed by Cloud Cost Management for Google Cloud Platform \\(GCP\\).\n\n
\n\nGCP Cost And Usage Bill Data \\[sn\\_cld\\_intg\\_gcp\\_cost\\_usage\\]\n\n\n\nCost and billing data for GCP.\n\n
\n\nGCP Product Details \\[sn\\_cld\\_intg\\_gcp\\_product\\_details\\]\n\n\n\nAll product details or specifications for GCP.\n\n
\n\nGoogle Billing Download Job \\[sn\\_cld\\_intg\\_gcp\\_schedule\\]\n\n\n\nBilling download jobs and their status for GCP.\n\n
\n\nGCP Services \\[sn\\_cld\\_intg\\_gcp\\_services\\]\n\n\n\nList of services provided by GCP.\n\n
\n\nAWS Spend Report Finalization Information \\[sn\\_cld\\_spend\\_aws\\_report\\_finalization\\_info\\]\n\n\n\nSpend reports finalization status for AWS.\n\n
\n\nSpend Report Daily Aggregated Cost \\[sn\\_cld\\_spend\\_core\\_daily\\_aggregated\\_cost\\]\n\n\n\nSpend report on daily basis aggregated on resources.\n\n
\n\nSpend Report Daily Cost \\[sn\\_cld\\_spend\\_core\\_daily\\_cost\\]\n\n\n\nSpend report for resource usage on daily basis.\n\n
\n\nSpend Report Forecast Cost \\[n\\_cld\\_spend\\_core\\_forecast\\_cost\\]\n\n\n\nForecasted spend information.\n\n
\n\nSpend Report Monthly Cost \\[sn\\_cld\\_spend\\_core\\_monthly\\_cost\\]\n\n\n\nMonthly 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.\n\n
\n\nSpend Report Execution Info \\[sn\\_cld\\_spend\\_core\\_report\\_info\\]\n\n\n\nSpend report execution details.\n\n
\n\nAWS Rightsizing Analytics Report \\[sn\\_clin\\_aws\\_rs\\_analytics\\_report\\]\n\n\n\nRightsizing report for AWS.\n\n
\n\nAWS Rightsizing Skipped Instance Families \\[sn\\_clin\\_aws\\_rs\\_skipped\\_instance\\_family\\]\n\n\n\nAWS instance families that are not considered in rightsizing recommendations.\n\n
\n\nAzure Rightsizing Analytics Report \\[sn\\_clin\\_azure\\_rs\\_analytics\\_report\\]\n\n\n\nRightsizing report for Azure.\n\n
\n\nCloud Insights Aggregated Cost Saving Snapshot \\[sn\\_clin\\_core\\_aggregated\\_cost\\_saving\\_snapshot\\]\n\n\n\nSnapshot of aggregated cost for different service accounts.\n\n
\n\nCloud Insights Aggregated Potential Saving Snapshot \\[sn\\_clin\\_core\\_aggregated\\_potential\\_saving\\_snapshot\\]\n\n\n\nSnapshot of aggregated potential savings from various recommendations.\n\n
\n\nCloud Insights Aggregated Realized Saving Snapshot \\[sn\\_clin\\_core\\_aggregated\\_realized\\_saving\\_snapshot\\]\n\n\n\nSnapshot of the actual realised aggregated savings.\n\n
\n\nBusiness Hours Cost \\[sn\\_clin\\_core\\_bh\\_cost\\]\n\n\n\nBusiness hours vs non business hours cost for a resource.\n\n
\n\nBusiness Hours Policy \\[sn\\_clin\\_core\\_bh\\_policy\\]\n\n\n\nList of policies configured for business hours.\n\n
\n\nBusiness Hours Policy Execution \\[sn\\_clin\\_core\\_bh\\_policy\\_execution\\]\n\n\n\nBusiness hours policy execution information.\n\n
\n\nBusiness Hours Policy Match \\[sn\\_clin\\_core\\_bh\\_policy\\_match \\]\n\n\n\nPolicy matches for various resources in the Business hours cost table.\n\n
\n\nBusiness Hours Policy Summary \\[sn\\_clin\\_core\\_bh\\_policy\\_summary\\]\n\n\n\nInformation summary for the business hour policies.\n\n
\n\nCloud Insights Business Hour Recommendations \\[n\\_clin\\_core\\_bh\\_recommendation\\]\n\n\n\nRecommendations for business hours.\n\n
\n\nBusiness Hours Settings \\[sn\\_clin\\_core\\_bh\\_settings\\]\n\n\n\nSettings record for Business hours module.\n\n
\n\nBudget \\[sn\\_clin\\_core\\_budget\\_policy\\]\n\n\n\nList of budget policies & details.\n\n
\n\nBudget Report Forecast Cost \\[sn\\_clin\\_core\\_budget\\_report\\_forecast\\_cost\\]\n\n\n\nSpend calculation for the budget.\n\n
\n\nBudgets Policy Summary \\[sn\\_clin\\_core\\_budget\\_summary\\]\n\n\n\nSummaries of budget policies with stats.\n\n
\n\nCloud Insights realized saving snapshot \\[sn\\_clin\\_core\\_daily\\_realized\\_saving\\_snapshot\\]\n\n\n\nSnapshot of the actual realised daily savings.\n\n
\n\nExcluded Resources Report Mapping \\[sn\\_clin\\_core\\_exclusion\\_mapping\\]\n\n\n\nExcluded resource mapping to the type report or recommendation it belongs to.\n\n
\n\nExcluded Resources \\[sn\\_clin\\_core\\_excl\\_res\\]\n\n\n\nList of excluded resources from the Cloud Cost Management modules for different service accounts and providers.\n\n
\n\nInsights Alias \\[sn\\_clin\\_core\\_insights\\_alias\\]\n\n\n\nList of defined aliases for Cloud Cost Management scope.\n\n
\n\nInsights Alias Mapping \\[sn\\_clin\\_core\\_insights\\_alias\\_mapping\\]\n\n\n\nAlias mapping to the script or action flow for Cloud Cost Management scope.\n\n
\n\nInsights Execution \\[sn\\_clin\\_core\\_insights\\_execution\\]\n\n\n\nExecution details for all Cloud Cost Management executions.\n\n
\n\nInsights Type \\[sn\\_clin\\_core\\_insights\\_type\\]\n\n\n\nList of insights types available for Cloud Cost Management.\n\n
\n\nM2m Insights Exec Profile Flow Metrics \\[sn\\_clin\\_core\\_m2m\\_insights\\_exec\\_profile\\_flow\\_metrics\\]\n\n\n\nInsights execution to profile flow metrics.\n\n
\n\nCloud Insights Policy Action \\[sn\\_clin\\_core\\_policy\\_action\\]\n\n\n\nActions and flows to be executed for a policy.\n\n
\n\nPolicy Change Request Templates \\[sn\\_clin\\_core\\_policy\\_change\\_request\\_template\\]\n\n\n\nChange request templates for business hours and unassigned recommendations.\n\n
\n\nCloud Insights Policy Match \\[sn\\_clin\\_core\\_policy\\_match\\]\n\n\n\nPolicy matches for various resources and modules.\n\n
\n\nPolicy Summary \\[sn\\_clin\\_core\\_policy\\_summary\\]\n\n\n\nSummary of all the policies available\n\n
\n\nPolicy \\[sn\\_clin\\_core\\_pol\\_policy\\]\n\n\n\nPolicies to be applied on various modules.\n\n
\n\nCloud Insights potential saving snapshot \\[sn\\_clin\\_core\\_potential\\_saving\\_snapshot\\]\n\n\n\nSnapshot of the actual realised savings.\n\n
\n\nCloud Insights Recommendations \\[sn\\_clin\\_core\\_recommendation\\]\n\n\n\nRecommendations for Cloud Cost Management modules.\n\n
\n\nRecommendation Action Job Execution \\[sn\\_clin\\_core\\_recommendation\\_action\\_job\\_execution\\]\n\n\n\nJob execution status for recommendations.\n\n
\n\nReserved Instance Settings \\[sn\\_clin\\_core\\_reserved\\_instance\\_settings\\]\n\n\n\nSettings record for Reserved Instance module.\n\n
\n\nReserved Instance Recommendation \\[sn\\_clin\\_core\\_ri\\_recommendation\\]\n\n\n\nRecommendations for reserved instances modules.\n\n
\n\nRightsizing Analytics Report \\[sn\\_clin\\_core\\_rs\\_analytics\\_report\\_base\\]\n\n\n\nPotential resources for rightsizing recommendations.\n\n
\n\nCloud Insights Job \\[sn\\_clin\\_core\\_rs\\_job\\]\n\n\n\nList of jobs for rightsizing or unused machines module.\n\n
\n\nCloud Insights Rightsizing Recommendation Automatic \\[sn\\_clin\\_core\\_rs\\_recommendation\\_automatic\\]\n\n\n\nRightsizing recommendations.\n\n
\n\nCloud Insights Rightsizing Recommendation \\[sn\\_clin\\_core\\_rs\\_recommendation\\_base\\]\n\n\n\nParent table for rightsizing or unused recommendations.\n\n
\n\nRightsizing Settings \\[sn\\_clin\\_core\\_rs\\_settings\\]\n\n\n\nSettings record for Rightsizing module.\n\n
\n\nCloud Insights Unused Recommendation \\[sn\\_clin\\_core\\_rs\\_unused\\_recommendation\\]\n\n\n\nUnused resources recommendations.\n\n
\n\nService Account Owner Update Policy \\[sn\\_clin\\_core\\_sa\\_owner\\_policy\\]\n\n\n\nPolicies to update the service account owners.\n\n
\n\nInsights Settings\\[sn\\_clin\\_core\\_settings\\]\n\n\n\nSettings for various Cloud Cost Management modules.\n\n
\n\nTag key \\[sn\\_clin\\_core\\_tag\\_key\\]\n\n\n\nTag keys derived from billing data as well as user generated keys.\n\n
\n\nUnassigned Resources Count \\[sn\\_clin\\_core\\_unassigned\\_count\\]\n\n\n\nCount of unassigned resources for various service accounts.\n\n
\n\nCloud Insights Unassigned Policies \\[sn\\_clin\\_core\\_unassigned\\_policy\\]\n\n\n\nPolicies available for unassigned resources.\n\n
\n\nPolicy CI View \\[sn\\_clin\\_core\\_unassigned\\_policy\\_ci\\_view\\_list\\]\n\n\n\nUsed 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.\n\n
\n\nUnassigned Policy Summary \\[sn\\_clin\\_core\\_unassigned\\_policy\\_summary\\]\n\n\n\nPolicy summaries available for unassigned resources.\n\n
\n\nUnassigned Recommendations \\[sn\\_clin\\_core\\_unassigned\\_recommendation\\]\n\n\n\nUnassigned recommendations with assignment group, generated based on matched policies.\n\n
\n\nUnassigned Report \\[sn\\_clin\\_core\\_unassigned\\_report\\]\n\n\n\nReports or policy match for various unassigned resources.\n\n
\n\nUnassigned Resources \\[sn\\_clin\\_core\\_unassigned\\_resource\\]\n\n\n\nList of unassigned resources on which policies can be applied.\n\n
\n\nUnassigned Resource Settings \\[sn\\_clin\\_core\\_unassigned\\_settings\\]\n\n\n\nSettings record for Unassigned resources module.\n\n
\n\nUnused Machine Settings \\[sn\\_clin\\_core\\_unused\\_settings\\]\n\n\n\nSettings record for Unused machines module.\n\n
\n\nSpend Report Monthly Aggregated Costs \\[sn\\_cld\\_spend\\_core\\_monthly\\_aggregated\\_cost\\]\n\n\n\nStores spend for all resources over a time range or a cost type.\n\n
\n\nMulti currency setups \\[sn\\_cld\\_spend\\_core\\_multi\\_currency\\_setup\\]\n\n\n\nStores currency options for the Multi-currency setup.\n\n
\n\n**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.\n\n
\n\nResource Average Costs\n\n \\[sn\\_cld\\_intg\\_core\\_resource\\_avg\\_cost\\_list\\]\n\n\n\nAverage daily cost of the resource. This average daily cost is used to calculate savings for unused recommendations.\n\n
\n\nGoogle Policy Usage Last Downloaded\n\n \\[sn\\_cld\\_intg\\_gcp\\_resource\\_usage\\_last\\_downloaded\\]\n\n\n\nUsage last downloaded timestamp of the resources. This helps in downloading only the delta usage for Business hours.\n\n
\n\nAWS billing job files\n\n \\[sn\\_cld\\_intg\\_aws\\_billing\\_files\\]\n\n\n\nReference and status of the attachments of billing CSV files downloaded for a corresponding billing job of AWS assume role setup.\n\n
\n\nAzure billing Job chunk blob detail\n\n \\[sn\\_cld\\_intg\\_azure\\_job\\_chunk\\_blob\\_detail\\]\n\n\n\nTracking 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.\n\n
\n\nResource Latest Usage\n\n sn\\_cld\\_intg\\_core\\_resource\\_latest\\_usage\n\n\n\nLatest 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.\n\n
\n\nSpend Report Monthly Provider Agg Cost\n\n sn\\_cld\\_spend\\_core\\_monthly\\_provider\\_agg\\_cost\n\n\n\nCloud 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.\n\n
\n\nSpend Report Monthly Master Account Agg Cost\n\n sn\\_cld\\_spend\\_core\\_monthly\\_master\\_account\\_agg\\_cost\n\n
\n\nSpend Report Monthly Service Account Agg Cost\n\n sn\\_cld\\_spend\\_core\\_monthly\\_service\\_account\\_agg\\_cost\n\n
\n\nSpend Report Monthly Purchase Option Agg Cost\n\n sn\\_cld\\_spend\\_core\\_monthly\\_purchase\\_option\\_agg\\_cost\n\n
\n\nSpend Report Monthly Region Agg Cost\n\n sn\\_cld\\_spend\\_core\\_monthly\\_region\\_agg\\_cost\n\n
\n\nSpend Report Monthly Cloud Category Agg Cost\n\n sn\\_cld\\_spend\\_core\\_monthly\\_cloud\\_category\\_agg\\_cost\n\n
\n\nSpend Report Monthly Service Category Agg Cost\n\n sn\\_cld\\_spend\\_core\\_monthly\\_service\\_category\\_agg\\_cost\n\n
\n\nSpend Report Monthly Resource Group Agg Cost\n\n sn\\_cld\\_spend\\_core\\_monthly\\_resource\\_group\\_agg\\_cost\n\n
\n\nSpend Report Monthly Tag Agg Cost\n\n sn\\_cld\\_spend\\_core\\_monthly\\_tag\\_agg\\_cost\n\n
**Parent Topic:**[Cloud Cost Management reference](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/it-asset-management/cloud-cost-management/reference-cloudinsights.md)\n\n"}}