Adding a GCP Account

To enable Cloud Manager to explore your GCP cloud account(s), please follow the instructions below

1. New Service Account Key credentials via JSON key type

2. Service account(s) should have Administrator access. For a PoC, the global base role “Viewer” is sufficient

3. Detailed steps described here: https://docs.servicenow.com/bundle/rome-it-operations-management/page/product/cloud-management-v2-setup/task/gcp-create-creds-cloud-mgt.html

4. Billing data export needs to be configured for BigQuery export, per the below query.

   1. Name of the BigQuery Dataset and the Table where billing data is exported. Billing data export should be configured per the following:

      • ‘Daily Cost Detail’ enabled and configured under Billing → Billing Export

      • BigQuery ‘Scheduled Query’ configured to run daily (08:00 suggested time) with the following query (Note the edit required in the 2nd line, “FROM”, in italics, and the period/full-stop delineator).

      • Query (must be exactly the following; if you already have a query, liaise with Kumoco directly to discuss any required changes):

SELECT billing_account_id,

service.id as service_id,

service.description as service_description,

sku.id as sku_id,

sku.description as sku_description,

usage_start_time,

project.id as project_id,

project.number as project_number,

labels,

location.location,

location.region,

cost,

currency,

currency_conversion_rate,

usage.amount,

credits,

project.labels as project_labels,

system_labels

FROM `<BigQueryProjectName>.<BigQueryDataSetName>.gcp_billing_export_v1_013015_2EE221_813BB6`

where cost <> 0

AND date_diff(

current_date(),

EXTRACT(

DATE

from usage_start_time

),

DAY

) <= 1

5. Capture the following details and share with kcm-cs@kumoco.com

• Cloud Account Name

• Account ID

• Secret Key

• BigQuery Dataset

• BigQuery Table