Feb 18 2020
03:56 AM
- last edited on
Apr 08 2022
10:18 AM
by
TechCommunityAP
Feb 18 2020
03:56 AM
- last edited on
Apr 08 2022
10:18 AM
by
TechCommunityAP
Hello
I would like to add up the total amount of GB for events. However, I don't think my query works the way I want it to
Mar 04 2020 10:31 AM
@MrRog the query seems right.
Adding @Dale Koetke
Mar 05 2020 05:37 AM
Unless you need this segmented by computer, just use the Usage data type, e.g. as documented at https://docs.microsoft.com/en-us/azure/azure-monitor/platform/manage-cost-storage#data-volume-by-sol.... You're query for the total billable data from the last 31 days would be:
Usage
| where TimeGenerated > startofday(ago(31d))
| where IsBillable == true
| summarize BillableDataGB = sum(Quantity) / 1000.