topic How can I send alerts based on usernames? in Alerting

How can I send alerts based on usernames?

rbonillaa — Tue, 10 May 2011 21:40:47 GMT

My log file contains several lines with the following format:
... Failed password for invalid user someuser from somehost

Now, I would like to send an e-mail alert every time I see this line for any new user.

Any ideas?

Thanks,
Rafael

southeringtonp — Tue, 10 May 2011 22:19:53 GMT

Typically the way to track state in Splunk is via a lookup table.

Create a lookup with two fields -- user and firstSeen.

Then, do one of the following:

Create two searches. The first just maintains the lookup table, and the second does your alerting based on a search using inputlookup instead of querying the indexed data.
Create one search that pulls in your new events and the lookup table both, then outputs the updated lookup table, then filters the results to recent entries. Trigger the alert if any are found with firstSeen > now()-xx seconds.

rbonillaa — Wed, 11 May 2011 19:41:14 GMT

Thanks, I'll try to work with lookup tables.

Regards,
Rafael