Database Query Monitor
Dear all,
I am trying to find a solution for following problem:
We are using a query monitor to give us an overview about failed transactions from last day.
Examlple:
that means that the day after it will be completely different:
What I now need is a report (mail) which shows exactly these values each day.
To configure an alarm per row is not working because this row will not come up again, so the alarm won't be triggered again.
My idea was to set a new select query which counts the number of rows and if >0 it should end in an email with the upper table. But how?
Your help is highly appreciated!
Best,
Lukas
I am trying to find a solution for following problem:
We are using a query monitor to give us an overview about failed transactions from last day.
Examlple:
|
|
|
|
||||
| 1234 |
A |
Jun 23 2016 5:42PM |
E |
||||
| 2345 |
A |
Jun 23 2016 2:40PM |
E |
||||
| 3456 |
B |
Jun 23 2016 2:47PM |
X |
||||
| 4567 |
B |
Jun 23 2016 3:43PM |
X |
||||
| 5678 |
C |
Jun 23 2016 4:07PM |
X |
||||
| 6789 |
A |
Jun 23 2016 4:24PM |
X |
that means that the day after it will be completely different:
|
|
|
|
||||
| 9876 |
A |
Jun 24 2016 4:42PM |
E |
||||
| 8765 |
D |
Jun 24 2016 3:40PM |
x |
||||
| 7654 |
B |
Jun 24 2016 3:47PM |
X |
What I now need is a report (mail) which shows exactly these values each day.
To configure an alarm per row is not working because this row will not come up again, so the alarm won't be triggered again.
My idea was to set a new select query which counts the number of rows and if >0 it should end in an email with the upper table. But how?
Your help is highly appreciated!
Best,
Lukas