Jul 30 2018
09:46 AM
- last edited on
Apr 07 2022
05:25 PM
by
TechCommunityAP
Jul 30 2018
09:46 AM
- last edited on
Apr 07 2022
05:25 PM
by
TechCommunityAP
Hello.
I'm part of a support team for an application that's being moved over to the Azure Platform.
I'm trying out various queries to see what data is available in which location.
e.g. If I want to see where any "404" errors show up, I write the following query
search in (*) "404" | summarize count() by $table
This gives me the table names which have "404" along with the number of entries with that data.
AzureMetrics 400
AzureDiagnostics 37,548
Is there a way in which I can locate the column which has the above data, after I've identified the table?
e.g the above query shows that AzureDiagnostics has ~37K rows which have 404.
What query do I write to locate which column(s) have the data of interest?
Any help is appreciated. Thank you!
Jul 30 2018 10:33 AM
When creating a new query, try using the "Analytics" portal (selected with the button at the top of a query window). The black bar on the left had the entire schema.
Hope this helps!
Jul 30 2018 10:36 AM
Orion,
Thanks for the reply.
But that gives all the columns in the given table.
I was looking to find out which column had the data (in my case the text "404") of interest.