Forum Discussion

alchem_rj's avatar
alchem_rj
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
Rafi_Rabo's avatar
Rafi_Rabo
Icon for Microsoft rankMicrosoft
Sep 08, 2020

Hi alchem_rj,

 

Try it here (I added some months): Go to Log Analytics and run query

 
 

 

 

I'm not sure why the results when you added log for the 7th month are wrong, I need more context here (maybe add a link to the query and explain why the result is wrong?).

 

Please attach the link to the error again (the current link does not show any error), or just write it here.

 

Rafi

 

Noa Kuperberg's avatar
Noa Kuperberg
Icon for Microsoft rankMicrosoft
Sep 08, 2020

Thanks Rafi_Rabo!

The query itself is valid.

Is it possible that the inegested data has a different format that what you (customer) used on your original question? TimeGenerated should be in UTC. A different formatting may cause "getmonth" to fail or return a wrong value. 

Resources