Apptio

 View Only

 Fields concatenated in Azure Usage Details Row ID field

Jump to  Best Answer
Dawn Kassube's profile image
Dawn Kassube posted Fri October 25, 2024 12:59 PM

With moving from the old Azure Usage Details API to the Cost Export jobs, I need to know which fields were concatenated in the Row ID field.  We use this field for Uniqueness in some circumstances.

Varad Rajeev Muthal's profile image
Varad Rajeev Muthal posted Wed November 20, 2024 05:13 AM  Best Answer

Hello @Dawn Kassube, After analyzing the screenshot, It looks like Row ID is not an Azure field, nor a Cloudability Field, so it is likely created in the your TBM Studio environment from concatenating other fields or the row() function. You should reach out to their CSM or account manager for guidance on the specific TBM Studio configuration.

Hope this will help to resolve query.

Varad Rajeev Muthal's profile image
Varad Rajeev Muthal posted Tue November 19, 2024 02:44 PM

Hello @Dawn Kassube, Thanks for sharing the question.
I'll look for the answer and share it soon.

Guillermo Cuadrado's profile image
Guillermo Cuadrado posted Thu November 21, 2024 03:59 AM

In our case, it comes from the special Datalink Connector that Apptio Engineering set up for us in the migration from the MultiCloud one to CDI:
In the dataset in CT There is a similar formula as @Varad Rajeev Muthal points out:

Row ID=AzureAccountId&&AzureAccountName&&AvailabilityZone&&AccountIdentifier&&AccountName&&Seller&&Currency Code&&Item&&Instance Type&&OS&&Platform&&LeaseType&&Operation&&Product&&Product Code&&Unit&&TransactionType&&Location&&AzureReservationOrderName&&Service Category&&Service Name&&Service Type&&Tower&&{Sub-Tower}&&Type&&Azure Cost CenterTag&&Azure Department NameTag&&Description