Dec 03 2021 07:59 AM
I've added the "Sentinel Cost Workbook" and I've found it gives me a lot of valuable information. However, near the top, under the section entitled "Breakdown of billable ingestion by log category in the last > ago(7d)" the largest category is "Other". That category represents over 75% of the data ingestion. Is there a way to get more detail for what that data is?
TIA
~DGM~
Dec 06 2021 02:43 AM
SolutionDec 06 2021 09:56 AM - edited Dec 06 2021 09:56 AM
Warning Over the top explanation, scroll to the bottom for the answer
Just to give a break down what the workbook does:
The section in the workbook you are on about basically creates a table assigning the Data types logs into the correct naming solutions, for example a snippet from the code:
"Datatype Logs" Are apart of the solution "AAD", and then you get a costing for the solution AAD rather than individual logs.
"AuditLogs", "Azure Active Directory",
"SigninLogs", "Azure Active Directory",
"AADNonInteractiveUserSignInLogs", "Azure Active Directory",
"AADServicePrincipalSignInLogs", "Azure Active Directory",
"AADManagedIdentitySignInLogs", "Azure Active Directory",
"AADProvisioningLogs","Azure Active Directory",
Then it Joins this and any Custom Logs you are ingesting (| where DataType contains "_CL")
Anything labelled as other is because again, snipping the relevant code, basically saying if the result is empty in Log Type, mark it as "Other"
| project ['Log Type'] = DataType
| project ['Log Type'] = iif(isnotempty( Category),Category,"Other")
So any logs that arnt captured under the categories at the start / anything that does not have CL will be marked as Other.
Looking at a table that is flagged as Other in my environment "ContainerLog" is captured so is flagged as Other
Answer:
Long story Short This should give you a good view of everything cost wise:
Usage
| where TimeGenerated > ago(7d)
| where StartTime >= startofday(ago(7d)) and EndTime < startofday(now())
| where IsBillable == true
| summarize BillableDataGB = sum(Quantity) / 1000. by Solution, DataType
| order by BillableDataGB desc
Other Documents to assist
Dec 06 2021 01:37 PM
Thank you for this. It seemed like the top table was probably responsible for Other but I wasn't sure. This helped a lot.
Thanks
~DGM~
Dec 06 2021 02:59 PM