How can I search for strings within alert history?
jcat
Posts: 9
Hello,
How can I search through alert history for strings? I want to find how often specific processes are causing blocks, showing up as long-running queries, etc. The data is obviously stored so there has to be a way to search/filter it.
If this really isn't a current option then is anyone familiar with the schema enough to point me to where I can query the tables directly for what I need?
Thanks!
How can I search through alert history for strings? I want to find how often specific processes are causing blocks, showing up as long-running queries, etc. The data is obviously stored so there has to be a way to search/filter it.
If this really isn't a current option then is anyone familiar with the schema enough to point me to where I can query the tables directly for what I need?
Thanks!
Comments
Unfortunately, I don't think that this is currently possible. I have raised a feature request with our development team, reference SRP-4641, so that they can look into improving this aspect.
We are working on producing schema documentation which may help, although this is unlikely to be ready until the next release.
I'm sorry that I do not have a better answer for you.
It just seems that this should be fairly easy. The data I need to search through looks to be in the tables already since it displays when you look at any specific alert so doing a search against it "should" be easy.
This is definitely a feature addition that would be great in the software!