Hi!
Gibt es eine einfache SQL-Abfrage, um alle Queues mit gesetzter Eskalation zu finden?
Queues mit Eskalation finden
-
root
- Administrator
- Posts: 4250
- Joined: 18 Dec 2007, 12:23
- Znuny Version: Znuny and Znuny LTS
- Real Name: Roy Kaldung
- Company: Znuny
- Contact:
Re: Queues mit Eskalation finden
Hi,
das sollte so passen:
SELECT id,name,first_response_time,update_time,solution_time FROM queue where (update_time<>0 or solution_time<>0 or first_response_time<>0) and valid_id=(select id from valid where name='valid')
- Roy
das sollte so passen:
SELECT id,name,first_response_time,update_time,solution_time FROM queue where (update_time<>0 or solution_time<>0 or first_response_time<>0) and valid_id=(select id from valid where name='valid')
- Roy
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
-
hildeb
- Znuny newbie
- Posts: 51
- Joined: 25 Jun 2019, 11:06
- Znuny Version: 6.5.4
- Real Name: Ralf Hildebrandt
- Company: Charite
- Contact:
Re: Queues mit Eskalation finden
Danke, klappt 1A.