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