Forum Discussion

Shubham150391's avatar
Shubham150391
Copper Contributor
Apr 15, 2019
Solved

Issue with log analytics query

I need to write a log analytics query that can find storage account with supportsHttpsTrafficOnly as false.  Below is the query that I have formed , but it is giving error: AzureActivity | whe...
Azure Log Analytics
azure monitor
  • CliveWatson's avatar
    CliveWatson
    Apr 15, 2019

    Shubham150391 

     

    AzureActivity
| where OperationName == "Create/Update Storage Account"
| where Properties has '"supportsHttpsTrafficOnly\\":true'
| project Properties
    That text has a "\" control char, so you need two "\\".  Would as where work for you? 
     
     
CliveWatson's avatar
CliveWatson
Former Employee
Apr 15, 2019

Shubham150391 

 

AzureActivity
| where OperationName == "Create/Update Storage Account"
| where Properties has '"supportsHttpsTrafficOnly\\":true'
| project Properties
That text has a "\" control char, so you need two "\\".  Would as where work for you? 
 
 

Resources