How to automate creation of custom, view under Azure Cost Analysis

Question

How to automate creation of custom, view under Azure Cost Analysis

Sanjay Nipane 21

Hi,

Under 'Cost management' section, we can create a custom view under 'Cost Analysis'. Through portal, this can be done easily.

I want to automate this functionality of creating a view under Cost analysis to show previous month cost.

Since I want to automate this process for different subscription so requesting to advice if we have any solution for this.

Sanjay Nipane 21 Reputation points

2023-07-12T06:22:45.9066667+00:00

Thanks @SadiqhAhmed-MSFT for quick response. I am not able to find 'New-AzConsumptionView' cmdlet. Do we need to import any specific module first?
SadiqhAhmed-MSFT 49,326 Reputation points Microsoft Employee Moderator

2023-07-12T17:27:38.5133333+00:00

@Sanjay Nipane Sorry for the confusion. I have updated my initial response to answer your original question. Please follow the instructions and let me know if you have any questions.
Sanjay Nipane 21 Reputation points

2023-07-13T08:14:50.4733333+00:00

Thanks @SadiqhAhmed-MSFT , this really solved my problem. I have tested it and working as expected. My next concern is to subscribe to this view to get email notification. I am searching for specific Azure APIs (endpoints) but still not finding. Please advise if you know anything or any alternatives for it. I am using PowerShell Runbook.

Also advise me on how I can mark the answer as accepted.
SadiqhAhmed-MSFT 49,326 Reputation points Microsoft Employee Moderator

2023-07-13T16:13:53.8266667+00:00

@Sanjay Nipane Use the ScheduledActions API.

https://aka.ms/costmgmt/ScheduledActions

If using subscriptions or resource groups, you can use Bicep to simplify it a little. We have this in the official Bicep Registry.

https://aka.ms/finops/toolkit/bicepregistry

Also advise me on how I can mark the answer as accepted.

I have enabled the post to "Accept Answer" and "Up-vote" it.
Sanjay Nipane 21 Reputation points

2023-08-07T11:19:09.1366667+00:00

Hi @SadiqhAhmed-MSFT , good day.

When I am trying to find a view using Get or List API, I don't see the view which gets created through Create API. While troubleshooting, I found that, if we create a Private view then it gets retrieved through Get/List API. I was trying to find out a way to create Private view through Create API since the view created by calling APIs are Shared Views. Please advise.
Sanjay Nipane 21 Reputation points

2023-08-08T08:45:26.08+00:00

After quick analysis, I found that using Get by Scope gives the views whether it's Shared or Private ones. Thanks
SadiqhAhmed-MSFT 49,326 Reputation points Microsoft Employee Moderator

2023-08-09T09:59:34.1833333+00:00

Thanks for the update!

Accepted answer

0 additional answers

Your answer

Sanjay Nipane 21 Reputation points

2023-07-12T06:22:45.9066667+00:00

Thanks @SadiqhAhmed-MSFT for quick response. I am not able to find 'New-AzConsumptionView' cmdlet. Do we need to import any specific module first?
SadiqhAhmed-MSFT 49,326 Reputation points Microsoft Employee Moderator

2023-07-12T17:27:38.5133333+00:00

@Sanjay Nipane Sorry for the confusion. I have updated my initial response to answer your original question. Please follow the instructions and let me know if you have any questions.
Sanjay Nipane 21 Reputation points

2023-07-13T08:14:50.4733333+00:00

Thanks @SadiqhAhmed-MSFT , this really solved my problem. I have tested it and working as expected. My next concern is to subscribe to this view to get email notification. I am searching for specific Azure APIs (endpoints) but still not finding. Please advise if you know anything or any alternatives for it. I am using PowerShell Runbook.

Also advise me on how I can mark the answer as accepted.
SadiqhAhmed-MSFT 49,326 Reputation points Microsoft Employee Moderator

2023-07-13T16:13:53.8266667+00:00

@Sanjay Nipane Use the ScheduledActions API.

https://aka.ms/costmgmt/ScheduledActions

If using subscriptions or resource groups, you can use Bicep to simplify it a little. We have this in the official Bicep Registry.

https://aka.ms/finops/toolkit/bicepregistry

Also advise me on how I can mark the answer as accepted.

I have enabled the post to "Accept Answer" and "Up-vote" it.
Sanjay Nipane 21 Reputation points

2023-08-07T11:19:09.1366667+00:00

Hi @SadiqhAhmed-MSFT , good day.

When I am trying to find a view using Get or List API, I don't see the view which gets created through Create API. While troubleshooting, I found that, if we create a Private view then it gets retrieved through Get/List API. I was trying to find out a way to create Private view through Create API since the view created by calling APIs are Shared Views. Please advise.
Sanjay Nipane 21 Reputation points

2023-08-08T08:45:26.08+00:00

After quick analysis, I found that using Get by Scope gives the views whether it's Shared or Private ones. Thanks
SadiqhAhmed-MSFT 49,326 Reputation points Microsoft Employee Moderator

2023-08-09T09:59:34.1833333+00:00

Thanks for the update!

Answer 1

Hello @Sanjay Nipane Thank you for contacting on Microsoft Q&A platform. Happy to help!

As I understand your requirement to automate creation of custom view under Azure Cost Analysis for multiple subscriptions. You can use Cost Management Create/Update views API to programmatically create Cost Management Views:

https://learn.microsoft.com/en-us/rest/api/cost-management/views/create-or-update-by-scope?tabs=HTTP

Example payload which you can customize:

{
    "properties": {
        "currency": "USD",
        "dateRange": "LastMonth",
        "query": {
            "type": "ActualCost",
            "dataSet": {
                "granularity": "Daily",
                "aggregation": {
                    "totalCost": {
                        "name": "Cost",
                        "function": "Sum"
                    },
                    "totalCostUSD": {
                        "name": "CostUSD",
                        "function": "Sum"
                    }
                },
                "sorting": [
                    {
                        "direction": "ascending",
                        "name": "UsageDate"
                    }
                ],
                "grouping": [
                    {
                        "type": "Dimension",
                        "name": "ServiceName"
                    }
                ]
            },
            "timeframe": "None"
        },
        "chart": "Area",
        "accumulated": "true",
        "pivots": [
            {
                "type": "Dimension",
                "name": "ServiceName"
            },
            {
                "type": "Dimension",
                "name": "ResourceLocation"
            },
            {
                "type": "Dimension",
                "name": "ResourceGroupName"
            }
        ],
        "scope": "subscriptions/{SubscriptionGUID}",
        "kpis": [
            {
                "type": "Forecast",
                "enabled": true
            }
        ],
        "displayName": "{ViewName}"
    }
}

Hope this helps!

If the response helped, do "Accept Answer" and up-vote it

Share via

How to automate creation of custom, view under Azure Cost Analysis

0 additional answers

Your answer