1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
| SELECT
d.itilParent_id,
d.rqTitle AS service,
e.rqTitle AS NomParent,
p.LastName,
p.FirstName,
Responsable_id,
(Case When (t.Statut="Ouvert") THEN count(t.Statut) ELSE 0 END) AS Ouvert,
(Case When (t.Statut="Fermé") THEN count(t.Statut) ELSE 0 END) AS Fermé,
FROM
Ticket t,sysperson p,department d,department e
WHERE p.department_id=d.SYSID AND
t.Responsable_id=p.SYSID
AND
d.itilParent_id = e.SYSID
AND
t.Statut IN ("Ouvert","Fermé")
GROUP BY Responsable_id
ORDER BY p.LastName |
Partager