NLog.Extensions.AzureTableStorage icon indicating copy to clipboard operation
NLog.Extensions.AzureTableStorage copied to clipboard

How do we search/query something in Message column?

Open michaelsync opened this issue 11 years ago • 8 comments

Hello, I am using NLog extension in my Azure project. (I did pull-request for app setting and latest package a couple of months back for your project.) I found it pretty easy to use.. But the issue that I have now is that it's difficult to search something in message. We are writing the error/exception information in "Message" column, right? What would be the best way to search something (e.g. user name or specific error code) in "Message" column of Azure Table Storage?

message

michaelsync avatar Oct 23 '14 04:10 michaelsync

Hi @michaelsync I'm having the same problem. What I do is using this tool, I export the table to csv files and then open it in Excel and do my search. screen shot 2014-10-23 at 10 47 20 pm You can also try using the filter section in the same app specially for filtering by things like (ApplicationName, Pid, Tid) screen shot 2014-10-23 at 10 55 44 pm Of course we could also spend some time to write an app that reads the table and filter it in memory for example to be more efficient.

harouny avatar Oct 23 '14 11:10 harouny

Why did you close this? u mean, you don't care because it's the limitation of azure?

michaelsync avatar Oct 23 '14 13:10 michaelsync

and i am not going to use the storage explorer.. it's a most stupid tool ever..

michaelsync avatar Oct 23 '14 13:10 michaelsync

are u thinking about nlog users? or, u just think about users like us?

michaelsync avatar Oct 23 '14 13:10 michaelsync

I would be happy to reopen again if there is something to do. I closed it because viewing the logs is beyond the scope of this project, its just an Nlog target not a table storage log viewer.

Do you have a plan or something in mind?

harouny avatar Oct 23 '14 20:10 harouny

@harouny I wasn't asking for log viewer. But Azure table storage has the limitation on what we can search and etc. so we need to log the data in searchable way so that we can search the message by using another tool later..

I am using zud.io to view the logs..

Again, I am asking how to log the data so that we can search them later..

michaelsync avatar Oct 24 '14 02:10 michaelsync

Hi @michaelsync I not sure. do you have any suggestions?

harouny avatar Oct 27 '14 01:10 harouny

@harouny Thanks! I am not familiar with azure table storage yet.. I will read up about azure table storage and its query limitation. Thanks!

michaelsync avatar Oct 29 '14 04:10 michaelsync