FlexReport to retrieve the Instance Type and Processor Type for GreenOps Data set

Products

• CloudHealth

Issue/Introduction

You can utilize FlexReport to retrieve the Instance Type and Processor Type for the GreenOps Data set.  

 

Resolution

Below is the query that can be utilized:

Note: This report uses the MULTICLOUD_OPERATIONAL_EMISSIONS and AWS_CUR data set

{
  "sqlStatement": " WITH \"cxtemp_carb\" AS ( SELECT timeInterval_Day AS Day, SUM(AverageCPU) AS SUM_AverageCPU, SUM(Carbon) AS SUM_Carbon, SUM(vCPUHours) AS SUM_vCPUHours, SUM(Power) AS SUM_Power, SUM(UsageMinutes) AS SUM_UsageMinutes, InstanceType AS InstanceType, ResourceId AS ResourceId, ModelVersion AS ModelVersion FROM MULTICLOUD_OPERATIONAL_EMISSIONS GROUP BY timeInterval_Day, InstanceType, ResourceId, ModelVersion ), \"cxtemp_res\" as ( SELECT timeInterval_Day AS Day, lineItem_ResourceId AS LineItem_ResourceId, product_instanceFamily AS Product_instanceFamily, product_instanceType AS Product_instanceType, product_productFamily AS Product_productFamily, product_ProductName AS Product_ProductName, product_physicalProcessor AS Product_physicalProcessor, product_processorArchitecture AS Product_processorArchitecture, product_processorFeatures AS Product_processorFeatures FROM AWS_CUR WHERE (product_productFamily LIKE '%Compute Instance%') AND ( product_ProductName LIKE '%Amazon Elastic Compute Cloud%' ) GROUP BY timeInterval_Day, lineItem_ResourceId, product_instanceFamily, product_instanceType, product_productFamily, product_ProductName, product_physicalProcessor, product_processorArchitecture, product_processorFeatures ) select cxtemp_carb.Day, SUM_AverageCPU, SUM_Carbon, SUM_vCPUHours, SUM_Power, SUM_UsageMinutes, cxtemp_carb.InstanceType, cxtemp_carb.ResourceId, ModelVersion, Product_instanceFamily, Product_instanceType, Product_productFamily, Product_ProductName, Product_physicalProcessor, Product_processorArchitecture, Product_processorFeatures from cxtemp_carb left join cxtemp_res on cxtemp_carb.Day = cxtemp_res.Day and cxtemp_carb.ResourceId = cxtemp_res.LineItem_ResourceId and InstanceType=Product_instanceType ",
  "dataGranularity": "DAILY",
  "timeRange": {
    "last": 30
  },
  "limit": -1
}