Issue with log analytics query

[Shubham150391]

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

| where OperationName == "Create/Update Storage Account"

| where Properties matches regex """supportsHttpsTrafficOnly":true,""

Error message:

Query could not be parsed at ':' on line [3,61] Token: : Line: 3 Position: 61

Can someone please help on this

[#2 · Accepted solution]

@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?