Following this guide, I see how to filter on custom dimensions but how do I filter when there is a '.' in the key / property name?
For example, I want to filter on ServiceFabric.ServiceTypeName
from this custom dimension value:
{
"AspNetCoreEnvironment": "Production",
"ServiceFabric.ApplicationTypeName": "MyCompany.MyAppType",
"ServiceFabric.ServiceTypeName": "MyService",
"ServiceFabric.ApplicationName": "fabric:/MyCompany.MyApp",
"ServiceFabric.PartitionId": "some-guid",
"ServiceFabric.ServiceName": "fabric:/MyCompany.MyApp/MyService",
"ServiceFabric.InstanceId": "55555",
"ServiceFabric.NodeName": "my-node",
"CategoryName": "Microsoft.AspNetCore.Hosting.Internal.WebHost",
"Protocol": "HTTP/1.1",
"Host": "MyCompany.com",
"Method": "GET",
"Scheme": "https",
"Path": "/api/values"
}
The following is not working...
traces
| extend type = customDimensions.ServiceFabric.ApplicationTypeName
| where type == "MyCompany.MyAppType"
| order by timestamp desc
the syntax for names with special things is:
customDimensions["ServiceFabric.ApplicationTypeName"]
you can use that bracket+quotes thing to name columns as well:
| extend ["This is a column with spaces"] = blah
or
| project-rename ["Name with space"] = name
-
) must be enclosed using ['
and ']
or using ["
and "]
.['
and ']
or ["
and "]
.['
and ']
or [" and "]
.ThisTable
as thisTABLE
.