Forum Discussion
Solved
Logs Size and Total Data Received in Azure Sentinel
Hello, I need to find a way how to check for the logs size in total that is been received from data connectors and the total number of data that is been received? Regards, Mazhar
There are few ways to collect data from Azure Sentinel:
- Visualize data using the Azure Data Explorer (including excel report)
- Using Workbook inside Azure Sentinel to gain extensive insight
- Create a PowerBI report (need to create connector and few customizations)
- With KQL you can pull out any data, example general command:
// Billable performance data over the last 30 days
Usage| where TimeGenerated > ago(30d)| where IsBillable == true| summarize TotalVolumeGB = sum(Quantity) / 1024
There are few ways to collect data from Azure Sentinel:
- Visualize data using the Azure Data Explorer (including excel report)
- Using Workbook inside Azure Sentinel to gain extensive insight
- Create a PowerBI report (need to create connector and few customizations)
- With KQL you can pull out any data, example general command:
// Billable performance data over the last 30 days
Usage
| where TimeGenerated > ago(30d)
| where IsBillable == true
| summarize TotalVolumeGB = sum(Quantity) / 1024
Hello,
By the documentation isn't TotalVolumeGB = sum(Quantity )/ 1000
?https://learn.microsoft.com/en-us/azure/azure-monitor/reference/tables/usage
https://learn.microsoft.com/en-us/azure/azure-monitor/logs/analyze-usage#querying-data-volumes-from-the-usage-table