Mar 30 2020
05:42 AM
- last edited on
Apr 08 2022
10:21 AM
by
TechCommunityAP
Mar 30 2020
05:42 AM
- last edited on
Apr 08 2022
10:21 AM
by
TechCommunityAP
Hi Members,
I am in the process of fetching the distinct devices which are sending the data from log analytics but not quite getting the query to work as I know some syntax I am missing it.
Mar 30 2020 09:56 AM
Mar 31 2020 02:03 AM
Thanks @CliveWatson
I used the query as per the one but would like to know how can I get deviceId in the query.
Mar 31 2020 08:11 AM
I don't have that data, but these are a near example:
AzureActivity
| extend clientRequestId_ = tostring(parse_json(HTTPRequest).clientRequestId)
| distinct clientRequestId_
AzureActivity
| extend clientRequestId_ = tostring(parse_json(HTTPRequest).clientRequestId)
| summarize count() by clientRequestId_
Go to Log Analytics and run query
You can press the "..." to extend the data into a column