How do we search/query something in Message column?

[michaelsync]

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?

[harouny]

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.

You can also try using the filter section in the same app specially for filtering by things like (ApplicationName, Pid, Tid)

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.

[michaelsync]

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

[michaelsync]

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

[michaelsync]

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

[harouny]

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?

[michaelsync]

@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..

[harouny]

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

[michaelsync]

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