Find GCP reseller credits in FlexReport

Products

• CloudHealth

Issue/Introduction

With credit name: "Discount on Total Spend", the partner can filter out the reseller GCP credits in FlexReports:

 

Resolution

Query:

{
"sqlStatement": "SELECT timeInterval_Month AS Month, SUM(Cost) AS SUM_Cost, Credit_Name AS Credit_Name FROM GCP_BILLING_EXPORT WHERE (Credit_Name LIKE '%Discount on Total Spend%') AND (Cost_Type LIKE '%regular%') AND (Project_Id IS NOT NULL) GROUP BY timeInterval_Month, Credit_Name",
"dataGranularity": "MONTHLY",
"timeRange": {
"from": "2023-03",
"to": "2023-04"
},
"limit": -1
}