Is it possible to send a notification to Slack when the subscription fee ratio changes rapidly?

shohei_kobayashi 45

For example:

The previous month's subscription fees for service A, B, and C were 50%, 30%, and 20%, respectively, but this month they changed to 80%, 10%, and 10%. Therefore, a notification was sent to Slack.

I also don't quite understand why "Anomaly" as Alert type cannot be selected when creating Costs alerts. It writes: "Not available for billing accounts. Please change scope to a subscription."

Thank you very much for your support in advance.

SadiqhAhmed-MSFT 38,081 Reputation points Microsoft Employee

2024-04-16T20:20:13.4166667+00:00
Hello @shohei_kobayashi Thank you for contacting us on Microsoft Q&A platform. Happy to assist you!

From the tile of the post, I understand that you want to know if it is possible to trigger notification to Slack when the subscription fee ratio changes rapidly.

I have not tried this personally, you may want to give a shot:

Create a log alert rule in Azure Monitor to monitor the changes in subscription fees and configure an action group to send notifications to Slack. Here are the steps to create a log alert rule:

Go to the Azure portal and navigate to the Azure Monitor service.

Click on "Alerts" in the left-hand menu and then click on "New alert rule".

In the "Scope" section, select the subscription that you want to monitor.

In the "Condition" section, select "Signal logic" and then select "Custom log search".

In the "Custom log search" section, enter the following query to calculate the subscription fee ratio:

AzureConsumption | where ResourceType == "subscriptions" | where TimeGenerated >= ago(30d) | summarize TotalCost = sum(Cost) by SubscriptionId | extend Ratio = TotalCost / toscalar(TotalCost)

This query calculates the subscription fee ratio for the last 30 days.

In the "Alert logic" section, set the threshold for the subscription fee ratio. For example, you can set the threshold to 0.5 if you want to be notified when the subscription fee ratio for a service exceeds 50%.

In the "Action group" section, configure an action group to send notifications to Slack. You can follow the instructions in this article to create an action group that sends notifications to Slack: https://docs.microsoft.com/en-us/azure/azure-monitor/platform/action-groups#create-an-action-group

Regarding your question about the "Anomaly" alert type, it is not available for billing accounts because it requires a machine learning model to detect anomalies in the data. This feature is only available for subscriptions, not billing accounts.

Hope this helps!
shohei_kobayashi 45 Reputation points

2024-04-22T07:15:06.2633333+00:00

I really appreciate your detailed explanation!

I will give it a shot!
SadiqhAhmed-MSFT 38,081 Reputation points Microsoft Employee

2024-04-22T10:41:17.12+00:00

@shohei_kobayashi Let us know how it goes!
SadiqhAhmed-MSFT 38,081 Reputation points Microsoft Employee

2024-04-24T11:17:41.67+00:00

@shohei_kobayashi Any progress on this?
shohei_kobayashi 45 Reputation points

2024-04-25T23:38:02.0833333+00:00

My boss has yet to authorize me to access and edit Azure Monitor.

I will let you know if I make some progress on this issue.

Sincerely from Japan
SadiqhAhmed-MSFT 38,081 Reputation points Microsoft Employee

2024-04-30T19:17:20.3333333+00:00

@shohei_kobayashi Any update on this?