1 2 3 4
| SELECT glpi_tickets.id AS ID, 'http://10.20.0.158/GLPI/front/ticket.form.php?id='+CStr(glpi_tickets.id) AS URL, glpi_tickets.name AS Titre, glpi_tickets.content AS Contenu, IIf(glpi_tickets.type=1,"Incident","Demande") AS Type, glpi_itilcategories.completename AS Catégorie, Switch(glpi_tickets.priority=1,'Très Basse',glpi_tickets.priority=2,'Basse',glpi_tickets.priority=3,'Moyenne',glpi_tickets.priority=4,'Haute',glpi_tickets.priority=5,'Très Haute') AS Priorité, [realname] & " " & [firstname] AS Utilisateur, Switch(glpi_tickets.status="assign",'Assigné',glpi_tickets.status="closed",'Clos',glpi_tickets.status="new",'Nouveau',glpi_tickets.status="plan",'Planifié',glpi_tickets.status="solved",'Résolu',glpi_tickets.status="waiting",'En attente') AS Statut, ConcatList("SELECT glpi_groups.completename FROM glpi_groups_tickets LEFT JOIN glpi_groups ON glpi_groups_tickets.groups_id = glpi_groups.id WHERE glpi_groups_tickets.tickets_id=" & glpi_tickets.id," + ") AS Groupe, glpi_tickets.solution AS Solution, ConcatList("SELECT Content FROM glpi_ticketfollowups WHERE tickets_id=" & glpi_tickets.id,"// ") AS Suivi, Switch(glpi_tickets.requesttypes_id=8,'Supervision',glpi_tickets.requesttypes_id=4,'Directe',glpi_tickets.requesttypes_id=5,'Ecrite',glpi_tickets.requesttypes_id=2,'Email',glpi_tickets.requesttypes_id=3,'Téléphone') AS Source, glpi_tickets.Date AS DateCréation, glpi_tickets.due_date AS DateEchéance, GetFrameTime(glpi_tickets.waiting_duration) AS DuréeEnAttente, glpi_tickets.solvedate AS DateRésolution, GetFrameTime(glpi_tickets.solve_delay_stat) AS DélaiDeRésolution, IIf(glpi_tickets.due_date Is Not Null And (glpi_tickets.solvedate>glpi_tickets.due_date Or (glpi_tickets.solvedate Is Null And glpi_tickets.due_date<Now())),'Oui','Non') AS DépassementSLA
FROM ((glpi_tickets LEFT JOIN glpi_itilcategories ON glpi_tickets.itilcategories_id = glpi_itilcategories.id) LEFT JOIN glpi_tickets_users ON glpi_tickets.id = glpi_tickets_users.tickets_id) LEFT JOIN glpi_users1 ON glpi_tickets_users.users_id = glpi_users1.id
GROUP BY glpi_tickets.id, glpi_tickets.name, glpi_tickets.content, glpi_itilcategories.completename, [realname] & " " & [firstname], glpi_tickets.solution, glpi_tickets.Date, glpi_tickets.due_date, glpi_tickets.solvedate, glpi_tickets.requesttypes_id, glpi_tickets.priority, glpi_tickets.status, glpi_tickets.type, glpi_tickets_users.type, glpi_tickets.waiting_duration, glpi_tickets.solve_delay_stat
HAVING (((glpi_tickets_users.type)=1)); |
Partager