{"id":15504,"date":"2019-07-23T07:30:24","date_gmt":"2019-07-23T07:30:24","guid":{"rendered":"https:\/\/www.microsoft.com\/en-gb\/industry\/blog\/?p=15504"},"modified":"2019-10-07T14:09:39","modified_gmt":"2019-10-07T13:09:39","slug":"azure-sentinel-meets-azure-log-analytics","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-gb\/industry\/blog\/cross-industry\/2019\/07\/23\/azure-sentinel-meets-azure-log-analytics\/","title":{"rendered":"Azure Sentinel meets Azure Log Analytics – looking at data use and estimated costs."},"content":{"rendered":"
\/\/ ————————————————————————————————<\/p>\n Please use the above link – posted retained for examples only, now that Sentinel has been released <\/p>\n ————————————————————————————————<\/p>\n This post combines two previous posts, one on Log Analytics and one on Sentinel Dashboards.<\/p>\n https:\/\/www.microsoft.com\/en-gb\/industry\/blog\/cross-industry\/2019\/07\/22\/azure-log-analytics-looking-at-data-and-costs-part-4\/<\/a> Please note Azure Sentinel prices have not been disclosed yet. However we can see the Log Analytics tables used by Sentinel and look at those costs. I’ve used the query from the “Azure Sentinel Dashboard query” post to find the relevant tables in Log Analytics, to work out the GB consumed and then estimate the costs (in USD).<\/p>\n Azure Sentinel Documentation<\/a><\/p>\n A variant of the above query is this, which filters specifically on the past 31days (and only full days). I also grab the oldest and newest date\/time per solution:<\/p>\n
\n\/\/
\n\/\/ Now that the pricing is released – please see https:\/\/azure.microsoft.com\/en-gb\/pricing\/calculator\/ <\/a>
\n\/\/
\n\/\/ Please use https:\/\/www.microsoft.com\/en-gb\/industry\/blog\/cross-industry\/2019\/10\/03\/azure-sentinel-average-gb-per-day\/<\/a>
\n\/\/ <\/p>\n
\nhttps:\/\/www.microsoft.com\/en-gb\/industry\/blog\/cross-industry\/2019\/07\/19\/azure-sentinel-dashboard-queries\/<\/a><\/p>\n
\nlet aap = 2.30; \/\/Add Azure Pricing ($ USD) source: https:\/\/azure.microsoft.com\/en-us\/pricing\/details\/monitor\/
\nunion isfuzzy=true withsource = tt *
\n| where _IsBillable == True
\n| where tt in (\"Syslog\", \"SecurityEvent\",\"AWSCloudTrail\", \"CommonSecurityLog\",
\n\"SecurityAlert\", \"ThreatIntelligenceIndicator\", \"LinuxAuditLog\",
\n\"HuntingBookmark\", \"WindowsFirewall\",\"SigninLogs\",\"SymantecICDX_CL\",
\n\"DnsEvents\",\"SecurityCenterFree\",\"OfficeActivity\")
\n| summarize
\nTotalGBytes =round( sum(_BilledSize\/(1024*1024*1024)),2),
\nEstimatedCostUSD=round(aap * sum(_BilledSize\/(1024*1024*1024)),2)
\nby Solution=tt
\n| sort by TotalGBytes desc
\n<\/code><\/p>\n
\nlet aap = 2.30; \/\/Add Azure Pricing ($ USD) source: https:\/\/azure.microsoft.com\/en-us\/pricing\/details\/monitor\/
\nunion isfuzzy=true withsource = tt *
\n| where TimeGenerated > startofday(ago(31d)) and TimeGenerated < startofday(now())
\n| where _IsBillable == True
\n| where tt in
\n(
\n\"Syslog\", \"SecurityEvent\",\"AWSCloudTrail\", \"CommonSecurityLog\",
\n\"SecurityAlert\", \"ThreatIntelligenceIndicator\", \"LinuxAuditLog\",
\n\"HuntingBookmark\", \"WindowsFirewall\",\"SigninLogs\",\"SymantecICDX_CL\",
\n\"DnsEvents\",\"SecurityCenterFree\",\"OfficeActivity\", \"McasShadowItReporting \"
\n)
\n| summarize
\nTotalGBytes =round( sum(_BilledSize\/(1024*1024*1024)),2),
\nEstimatedCostUSD=round(aap * sum(_BilledSize\/(1024*1024*1024)),2),
\nOldestRecord=min(TimeGenerated), NewestRecord=max(TimeGenerated)
\nby Solution=tt
\n| sort by TotalGBytes desc
\n<\/code><\/p>\n