Forum Discussion

Copper Contributor

Sep 01, 2020

Table count from custom log

Hello, I would like to get the count of table name reference in my custom log which is pushed to the Log analytics. The custom log structure is given below. 020-08-31 16:15:38 ProxyEngine [I...

azure monitor

Log Analytics

Noa Kuperberg

Microsoft

Sep 01, 2020

Hi alchem_rj,

You can use "parse-where" like I did here. The short syntax is

...| parse-where LogText with * "from " table_name
| summarize count() by table_name

where LogText is the name of the field you analyze.

The command is documented here.

alchem_rj

Copper Contributor

Sep 04, 2020

Thanks a lot, Noa Kuperberg for the suggestion