# The query behind each alert, saved in the workspace under the alert's own # name and looking back a week, plus one for working a case. locals { saved = merge( { for k, d in local.exchange_detections : "m365-${k}" => { display = d.doc query = "${replace(d.query, "ingestion_time() > ago(5m)", "TimeGenerated > ago(7d)")} | project TimeGenerated, UserId, ClientIP, Operation, OfficeObjectId, Parameters | order by TimeGenerated desc" } }, { m365-bulk-download = { display = "Users ranked by distinct files downloaded or synced in the last hour" query = replace(local.bulk_download, "| where Files > ${var.bulk_download_files}", "| order by Files desc") } m365-signals-silent = { display = "When each Microsoft 365 workload last sent a record" query = "OfficeActivity | summarize Latest = max(TimeGenerated) by OfficeWorkload" } m365-one-user = { display = "Everything one user did in Microsoft 365, last seven days" query = "OfficeActivity | where TimeGenerated > ago(7d) | where UserId =~ \"REPLACE-WITH-UPN\" | project TimeGenerated, OfficeWorkload, Operation, ClientIP, OfficeObjectId, Parameters | order by TimeGenerated desc" } }, ) } resource "azurerm_log_analytics_saved_search" "m365" { for_each = local.saved name = each.key log_analytics_workspace_id = azurerm_log_analytics_workspace.m365.id category = "Identity provider signals" display_name = each.value.display query = each.value.query tags = local.tags }