SQL Monitor for Log Entries

douglas.ellis

We have a program that writes errors to a table in a SQL DB.

Is there a monitor that will look for keywords in this table and alert if the keyword is found?

The one catch is that this table does not empty...so they keyword we are looking for may be in there from last month.  would would need it to reset every 24hours so it looks for the alert just today.  Further there are date/time stamps for each entry in the table.

Any help would be great!

Petr.Vilem

It should be quite easy to achieve this using SQL Server User Experience Monitor. You just need to compose SQL query which will return information you want to monitor. The query should return single row with numeric column and optional text column, so it may look like:

SELECT COUNT(*) as Statistic, CONVERT(varchar(max),COUNT(*)) + ' messages matches in last 24 hours' as MessageText FROM APM_WindowsEvent_Detail WHERE [TimeGeneratedUtc] > DATEADD(hour,-24,GETUTCDATE()) AND [Message] LIKE '%Keyword%'

Then you can define thresholds to be applied on numeric value to switch monitor into waning/critical state when some events are detected.