IBM Cloudability

Cloudability

A place for Cloudability product users to learn, connect, share and grow together.


#Cloudability
#Automation
#FinOps
#Cloud
#Apptio
#ITAutomation
 View Only
Expand all | Collapse all

Azure service names

  • 1.  Azure service names

    Posted 02/21/24 09:37 AM

    Hi

    I want to show specific Azure Service names within cloudability so I can understand their usage and map them to the ATUM azure model.  However, like AWS RDS, the service name looks like a generalisation field rather than a specific service name e.g. Compute could be virtual machines but could also be K8 technologies, Database could be sql, Postgres, MariaDB etc.  I could probably look at the usage and other service fields to formulate a list that matches the ATUM service description but before I try am I missing something? :)

    Thanks


    #Cloudability


  • 2.  RE: Azure service names

    Posted 02/22/24 04:06 AM

    The way I understand this, @Drew Dubber, is that ATUM is, as you wrote, a series of generic objects or categories.

    Maybe it's easier to think of it in an on-prem scenario: under Compute/Servers you'll find all kinds of manufacturers and operating systems. There is no loss of information or granularity. You can always drill down to the individual line items., in your case, the Oracle / Postgres / MariaDB costs under Application / Database.



  • 3.  RE: Azure service names

    Posted 02/22/24 09:28 AM

    I agree with statement, but rather than for ATUM, it is because it is very difficult to find necessary data when you are looking for something specific.  I can see the raw data from our cloud providers, but being able to re-create the data in Cloudability is difficult because I have to split using other methods.  i.e. Service = EC2 - Instance in AWS; Service = AWS EC2 in Cloudability; but AWS EC2 includes data transfer, and other services that are listed in EC2 - Other in AWS.  Trying to see total cost of eligible savings (calculated as we calculate it) is difficult because the tool doesn't allow and "exclude" for only one specific item (i.e. trying to see savings plans, EC2 (instance usage only), ECS, Lambda by lease type).  It would be ideal if the data that is sent in to Cloudability is the same as the data sent in from the providers (don't aggregate the fields) and then you can normalize the name if necessary (Account vs Subscription)




  • 4.  RE: Azure service names

    Posted 02/22/24 10:53 AM
    Edited by Thomas Kazmierczak 11/05/24 06:25 PM

    Hi, have you looked at the product name dimension instead?  Service name indeed is being normalized as discussed earlier, but product name should be the official product name as provided by the vendor (for example, Amazon Elastic Compute Cloud, GCP Cloud Storage, Microsoft.Compute or OCI Compute).  Please see here for a list of available cost and usage dimensions. https://help.apptio.com/en-us/cloudability/product/glossary-of-cost-dimensions-and-metrics.html?  Hope this helps.




  • 5.  RE: Azure service names

    Posted 02/22/24 12:02 PM

    Hi Thomas

    Thanks for replying.  As far as I can tell, with respect to Azure the product name is too general.  As I understand, Microsoft.compute could mean its a virtual machine or AKS.  I need this to be more specific. I can potentially figure this out from fields like the description, but it's a lot of work.

    AWS has this generalisation in places (AWS RDS, EMR, Elastic Load Balancers); not necessarily your fault because I think that is the way they provide the info.  But it makes it difficult for me to understand what service is actually being used. 




  • 6.  RE: Azure service names

    Posted 02/23/24 06:02 AM

    Hi Drew, have you considered breaking down the service name or product name by usage family and usage type?




  • 7.  RE: Azure service names

    Posted 02/26/24 01:57 PM

    Hi Thomas 

    Sorry for the tardy reply, thought I'd replied to this.  The product name provides the same generic bucket e.g. Microsoft.compute.  It could be a possibility to cross refer to the usage family / type (that is what I ended up doing to break down AWS RDS into Aurora vs RDS vs Maria etc) but I'm starting to have to write a heap of custom excel lookups parsing multiple lines with no guarantee I'll be able to map all the Azure products correctly.




  • 8.  RE: Azure service names

    Posted 03/04/24 05:28 PM

    Hi Drew,

                       To see the proper Azure service names we found them embedded in the usage type with a delimiter of '::', we split on that to get just Azure Service Name as Microsoft map it in their CUR data for our reports. So now we can see that is Virtual machines, virtual machine licenses etc instead of Microsoft.Compute.



    ------------------------------
    Regards, Jeremy Bryant
    Transport for NSW
    ------------------------------



  • 9.  RE: Azure service names

    Posted 03/04/24 05:44 PM

    Jeremy,

    How are you doing the split?  Are you using business mappings, did you create a business rule, or are you doing it outside of Cloudability?  

    Curious on your implementation, as we are currently at a cross roads ourselves with this.




  • 10.  RE: Azure service names

    Posted 03/04/24 06:09 PM

    Hi Shanon,

                           We are currently doing this outside of Cloudability in Power BI as we couldn't do it in business mappings.



    ------------------------------
    Regards, Jeremy Bryant
    Transport for NSW
    ------------------------------



  • 11.  RE: Azure service names

    Posted 03/04/24 06:27 PM

    Thanks Jeremy, I suspected as much.  We have been attempting to avoid doing that (we are trying to get from PowerBI to Cloudability) but sounds like we should stay on PowerBI for now.




  • 12.  RE: Azure service names

    Posted 03/05/24 11:38 AM

    Hi Jeremy, Shanon

    Thanks for your advice, comments, will look at using the usage type.  

    Apptio - what I am slightly puzzled at still is that this is how I understood how ATUM maps these services in Cloudability.  At least for Azure this doesn't look to be implemented yet.  Is this something you are working on or should I submit a feature request?

            {
                "matchExpression": "(DIMENSION['enhanced_service_name'] == 'AWS EC2' || DIMENSION['enhanced_service_name'] == 'Azure Compute' || DIMENSION['enhanced_service_name'] == 'AWS ECS' || DIMENSION['enhanced_service_name'] == 'AWS Lambda')",
                "valueExpression": "'Compute'"
            },
            {
                "matchExpression": "DIMENSION['enhanced_service_name'] CONTAINS 'Azure Analysis Services'",
                "valueExpression": "'Platform'"
            },
            {
                "matchExpression": "DIMENSION['enhanced_service_name'] CONTAINS 'Azure Cosmos DB'",
                "valueExpression": "'Platform'" 




  • 13.  RE: Azure service names

    Posted 03/05/24 12:42 PM

    Hi @Drew Dubber, I would definitely submit a feature request and also post that link so others can upvote it. 




  • 14.  RE: Azure service names

    Posted 10/15/25 06:44 PM

    Could probably do the string split using the REPLACE regular expression functionality Business Mapping Expression Language - IBM Documentation



    ------------------------------
    Costas Ttofa
    ------------------------------