Guys, I am trying to monitor SLA due date using external tools like nagios or zabbix, but I haven’t find a way to do that, we have SLA extension running for couple months now.
Anyone could give me some advice based on rt command line or mysql queue?
BlackBerry solution provided by www.principleone.com
Guys, I am trying to monitor SLA due date using external tools like nagios or zabbix, but I haven’t find a way to do that, we have SLA extension running for couple months now.
Anyone could give me some advice based on rt command line or mysql queue?
Use the Query Builder to search for overdue tickets, once you’re happy
with the results, you can run that same search from bin/rt
-kevin
Yes, I understand the method, but not sure why due date can’t define time, any idea?
BlackBerry solution provided by www.principleone.com----- Original Message -----
From: rt-users-bounces@lists.bestpractical.com rt-users-bounces@lists.bestpractical.com
To: rt-users@lists.bestpractical.com rt-users@lists.bestpractical.com
Sent: Fri Dec 16 04:09:48 2011
Subject: Re: [rt-users] SLA due exceed monitor
On Thu, Dec 15, 2011 at 07:49:45PM +0800, Thomas Lau wrote:
Guys, I am trying to monitor SLA due date using external tools like nagios or zabbix, but I haven’t find a way to do that, we have SLA extension running for couple months now.
Anyone could give me some advice based on rt command line or mysql queue?
Use the Query Builder to search for overdue tickets, once you’re happy
with the results, you can run that same search from bin/rt
-kevin
Yes, I understand the method, but not sure why due date can’t define time, any idea?
I’m not sure I understand the question. The SLA Extension and Due
date absolutely set times.
-kevin
I could set due before Dec 10 2011, but I can’t set display all ticket which due before Dec 10 2011, 2PM, how do you do such query?From: rt-users-bounces@lists.bestpractical.com [rt-users-bounces@lists.bestpractical.com] On Behalf Of Kevin Falcone [falcone@bestpractical.com]
Sent: Friday, December 16, 2011 7:54 AM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] SLA due exceed monitor
Yes, I understand the method, but not sure why due date can’t define time, any idea?
I’m not sure I understand the question. The SLA Extension and Due
date absolutely set times.
-kevin
----- Original Message -----
From: rt-users-bounces@lists.bestpractical.com rt-users-bounces@lists.bestpractical.com
To: rt-users@lists.bestpractical.com rt-users@lists.bestpractical.com
Sent: Fri Dec 16 04:09:48 2011
Subject: Re: [rt-users] SLA due exceed monitor
Guys, I am trying to monitor SLA due date using external tools like nagios or zabbix, but I haven’t find a way to do that, we have SLA extension running for couple months now.
Anyone could give me some advice based on rt command line or mysql queue?
Use the Query Builder to search for overdue tickets, once you’re happy
with the results, you can run that same search from bin/rt
-kevin
RT Training Sessions (http://bestpractical.com/services/training.html)
I could set due before Dec 10 2011, but I can’t set display all ticket which due before Dec 10 2011, 2PM, how do you do such query?
Due < ‘2011-11-10 14:00:00’
Best regards, Ruslan.
Thanks, but does query could show ticket which due date and time is 30minutes away from now?
BlackBerry solution provided by www.principleone.com----- Original Message -----
From: ruslan.zakirov@gmail.com ruslan.zakirov@gmail.com
To: Thomas Lau
Cc: rt-users@lists.bestpractical.com rt-users@lists.bestpractical.com
Sent: Fri Dec 16 19:20:49 2011
Subject: Re: [rt-users] SLA due exceed monitor
On Fri, Dec 16, 2011 at 13:19, Thomas Lau Thomas.Lau@principleone.com wrote:
I could set due before Dec 10 2011, but I can’t set display all ticket which due before Dec 10 2011, 2PM, how do you do such query?
Due < ‘2011-11-10 14:00:00’
Best regards, Ruslan.
Thanks, but does query could show ticket which due date and time is 30minutes away from now?
SearchByDates page on the wiki.
BlackBerry solution provided by www.principleone.com
----- Original Message -----
From: ruslan.zakirov@gmail.com ruslan.zakirov@gmail.com
To: Thomas Lau
Cc: rt-users@lists.bestpractical.com rt-users@lists.bestpractical.com
Sent: Fri Dec 16 19:20:49 2011
Subject: Re: [rt-users] SLA due exceed monitor
I could set due before Dec 10 2011, but I can’t set display all ticket which due before Dec 10 2011, 2PM, how do you do such query?
Due < ‘2011-11-10 14:00:00’
–
Best regards, Ruslan.
RT Training Sessions (http://bestpractical.com/services/training.html)
Best regards, Ruslan.
All work fine now, thanks
BlackBerry solution provided by www.principleone.comFrom: ruslan.zakirov@gmail.com ruslan.zakirov@gmail.com
To: Thomas Lau
Cc: rt-users@lists.bestpractical.com rt-users@lists.bestpractical.com
Sent: Fri Dec 16 20:32:28 2011
Subject: Re: [rt-users] SLA due exceed monitor
Thanks, but does query could show ticket which due date and time is 30minutes away from now?
SearchByDates page on the wiki.
BlackBerry solution provided by www.principleone.com
----- Original Message -----
From: ruslan.zakirov@gmail.com ruslan.zakirov@gmail.com
To: Thomas Lau
Cc: rt-users@lists.bestpractical.com rt-users@lists.bestpractical.com
Sent: Fri Dec 16 19:20:49 2011
Subject: Re: [rt-users] SLA due exceed monitor
I could set due before Dec 10 2011, but I can’t set display all ticket which due before Dec 10 2011, 2PM, how do you do such query?
Due < ‘2011-11-10 14:00:00’
–
Best regards, Ruslan.
RT Training Sessions (http://bestpractical.com/services/training.html)
Best regards, Ruslan.