Users wise cost in theazure cost management

Bhuvaneswari Maddi 1

I want to know how to check azure users cost data on day wise in the Azure cost management. Can you please suggest where to get this data?

SadiqhAhmed-MSFT 44,336 Reputation points Microsoft Employee

2021-10-29T05:37:14.987+00:00

Hello @Bhuvaneswari Maddi - Thank you for reaching out to us!

Are you asking for cost data projected based on “who” created the resource (that is emitting the usage/billing events) or something else? We do not have the user-based cost projections but if we understand your scenario better, we could suggest alternatives if possible,
Bhuvaneswari Maddi 1 Reputation point

2021-10-29T07:17:04.297+00:00

I want to know howmany users are connected and their cost on daily wise .. So from where i can get this information from Azure portal?
Bhuvaneswari Maddi 1 Reputation point

2021-10-29T07:25:33.42+00:00

I have followed the below link to with azure cost management.

So By using microsoft connecter it is having only billing info not having user column ..but as per my requirement user wise cost is required. Please refer the below link for further information and suggest me how to get user wise cost information?
https://video2.skills-academy.com/en-us/power-bi/connect-data/desktop-connect-azure-cost-management

1 answer

SadiqhAhmed-MSFT 44,336 Reputation points Microsoft Employee

2021-11-02T05:49:40.583+00:00

@Bhuvaneswari Maddi >>. I want to know how many users are connected and their cost on daily basis.

>Are these users connected to some specific resource deployed in Azure? As I had indicated earlier, Cost Management does not have/provide user telemetry based data.

The following would be my recommendation without understanding your scenario in full details: Cost Management data sets (usage charges download at resource instance level granularity) are meant to give you the charges related dimensions. If you are looking for users connecting to a particular/group of Azure resources, you need to check if the audit logs/metrics on that resource - can provide you the details about users – and if you could “merge/join” the data with cost management data set on your client side.

If the response helped, do "Accept Answer" and up-vote it
Please sign in to rate this answer.

1 person found this answer helpful.
Venkata satyanarayana Machari veera (CIS) 151 Reputation points

2021-11-05T14:53:06.993+00:00

Hi All.. I am also having same kind scenario on cost management by user.

Assume organization having 1000 users (AD Users).I need to display cost consumption of each user on his utilized resources.

Please suggest if any way to check this azure portal. Finally i need to show this in powerBI Report.

SadiqhAhmed-MSFT 44,336 Reputation points Microsoft Employee

2021-11-05T17:02:15.617+00:00

The answer remains the same ": Cost Management data sets (usage charges download at resource instance level granularity) are meant to give you the charges related dimensions. If you are looking for users connecting to a particular/group of Azure resources, you need to check if the audit logs/metrics on that resource - can provide you the details about users – and if you could “merge/join” the data with cost management data set on your client side."

Venkata satyanarayana Machari veera (CIS) 151 Reputation points

2021-11-08T10:53:51.08+00:00

Thank you for quick reply Sadiqh.

As you said Resource wise (VM,storege accounts) cost i am able to get it. My doubt is like an example
User having access of one or more vm's and some other resources .then where can i see that user wise consumed charges. Please help with your suggestion to achieve this. For this billing data i am using the below approach
https://video2.skills-academy.com/en-us/power-bi/connect-data/desktop-connect-azure-cost-management

Thanks
Satya

SadiqhAhmed-MSFT 44,336 Reputation points Microsoft Employee

2021-11-09T19:32:32.277+00:00

Charges are per resource and not based on which user managed the resources, users have access to resources to manage the resource but the cost is not specific to user.
As mentioned earlier telemetry/audit logs can be used to check who accessed a resource but this is not related to cost attribution. Cost attribution would be something that would be done in a custom manner.

Venkata satyanarayana Machari veera (CIS) 151 Reputation points

2021-11-17T04:42:03.673+00:00

Yes Sadiqh Thank you for your response.

Venkata satyanarayana Machari veera (CIS) 151 Reputation points

2021-11-17T04:48:50.117+00:00

We are trying calculate user wise billing for user utilized hours of vms , manner like based on user connected time of vms using wvdConnections table.
Please help with if you have any idea or suggestions. Thank you for your support.

SadiqhAhmed-MSFT 44,336 Reputation points Microsoft Employee

2021-11-17T09:58:16.7+00:00

Appreciate if you could leave a feedback here - https://feedback.azure.com/d365community/forum/748a4eaa-0e25-ec11-b6e6-000d3a4f07b8 for the product team to review your ask and consider the same for future enablement.

Venkata satyanarayana Machari veera (CIS) 151 Reputation points

2021-11-30T14:28:15.167+00:00

Thank you Sadiqh.

As suggested i am trying to achieve in custom manner. I am getting AD Users and Total VMs details using some azure API's. And planning calculate based on VMSize(T-Shirt Size).Please suggest how can we get users with assigned vms ? Right now i am able to get the users and VM details information but not able find vms assigned to the user.

Thanks
VenkataSatya
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Users wise cost in theazure cost management

1 answer

Your answer