[otrs] mysql query to get unanswered tickets and oldest ticket

2004-01-09 Thread Seth Brundle
I would like to run a MySQL query that tells me how many unanswered tickets I have in the entire OTRS database and the date of the oldest one.   This is so I can insert it into a cgi page I use to check the overall status of my website. Then I dont have to login to OTRS to see if I need to c

[otrs] setting queues for auto-close?

2003-09-08 Thread Seth Brundle
How does one set a queue so that when it is responded to, the default state is 'closed-succesful' instead of 'open'?     ___ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://list

Re: [otrs] How does an OTRS user originate a ticket?

2003-09-01 Thread Seth Brundle
Thanks to both who responded.   I think the fact that the feature to originate a ticket is called 'Phone View' is pretty indicative of my complaints regarding the OTRS interface. ;) - Original Message - From: Wilhelm Farrugia To: User questions and discussions about OTRS

[otrs] How does an OTRS user originate a ticket?

2003-09-01 Thread Seth Brundle
We have been using OTRS for several months, and although we have found the configuration and setup design a bit confusing and non-intuituve, we have been able to get it to do what we need, and it does it well.   One example: it took 3 of us, a Perl/UNIX web programmer and two Linux system ad