Forum Discussion

sarfrazkhs's avatar
sarfrazkhs
Copper Contributor
Mar 30, 2020

Log Analytics with IOTHUb

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....
Azure Log Analytics
azure monitor
CliveWatson's avatar
CliveWatson
Former Employee
Mar 30, 2020

sarfrazkhs 

 

AzureDiagnostics
| where ResourceType == "IOTHUBS"
| distinct _ResourceId
 
Replace _ResourceId with a working column 
 
  • sarfrazkhs's avatar
    sarfrazkhs
    Copper Contributor
    Mar 31, 2020

    Thanks CliveWatson 

     

    I used the query as per the one but would like to know how can I get deviceId in the query.

     

    AzureDiagnostics
    | where ResourceType == "IOTHUBS"
    | distinct properties_s
     

     

    • CliveWatson's avatar
      CliveWatson
      Former Employee
      Mar 31, 2020

      sarfrazkhs 

       

      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





Resources