topic Re: Explicit Search/Alert for an Error in Splunk Search

Explicit Search/Alert for an Error

kvallala — Fri, 31 Jul 2020 18:13:55 GMT

I am looking at setting up Search/Alert if i see an only "ERROR OGG-01296", however don't want to receive any alert when i have both errors "ERROR OGG-01296" and "ERROR OGG-01668" for the file xxxxx.prm. How can exclusively ignore this patterns. Pls advise

2020-07-31T08:19:46.925-0700 ERROR OGG-01668 Oracle GoldenGate Delivery, xxxxx.prm: PROCESS ABENDING.

2020-07-31T08:19:46.924-0700 ERROR OGG-01296 Oracle GoldenGate Delivery, xxxxx.prm: Error mapping from LZ.ABCD to LZ.ABCD.

Re: Explicit Search/Alert for an Error

richgalloway — Fri, 31 Jul 2020 18:47:35 GMT

This should do it.

index=foo ("ERROR OGG-01296" OR "ERROR OGG-01668") ```Extract error code and file name``` | rex "ERROR OGG-(?<error>\d+)" | rex ", (?<file>.*\.prm)" ```Combine error code for each file``` | stats count(error) as count by file ```Return only those files with a single error that is 1296``` | where (count=1 AND error=1296)

Re: Explicit Search/Alert for an Error

kvallala — Fri, 31 Jul 2020 22:03:39 GMT

Thanks @richgalloway , i definitely helping to my thought process.

I am still trying for what am looking for. Probably my question was not completely correct.

i might have more than one occurrence of this error.

ERROR OGG-01296

However I should only report when i don't see Error 01668, and i see at least one occurrence of OGG-01296 for that file xxxx.prm (for each file)

RROR OGG-01668