Forum Discussion
Dimitri Artemov
Nov 01, 2021Former Employee
AzureActivity - When my cosmos account was actually deleted?
Hello,
If I run below TQL
AzureActivity
| where TimeGenerated > ago(24h)
| where OperationNameValue has "MICROSOFT.DOCUMENTDB/DATABASEACCOUNTS/DELETE"
| where ActivityStatusValue == "Succe...
CliveWatson
Nov 01, 2021Former Employee
To help with these I use the (little known) "Group Columns" feature, then drag and drop a column heading, you can then simply scroll to teh right to see what maybe different in each column (or drag and drop other columns into the group).
Ultimately many solutions log multiple rows, often looking almost the same apart from the timestamp.
Myself I'd use arg_max to see the last row from each
...
| extend p=parse_json(Properties)
| extend ResourceDeleted=split(_ResourceId, "/", 8)[0]
| summarize arg_max(TimeGenerated,*) by OperationNameValue
Note: You can replace the "*" with specific named columns e.g.
| summarize arg_max(TimeGenerated,OperationNameValue, ActivityStatusValue, ResourceDeleted) by OperationNameValue