desolé pour la reinitegration du message, erreur de ma part
voici une requette
donc la on a bien les totaux generaux
select dplo.name as Site_Name, count(*) Total_by_Site
from glpi_computers as co, glpi_tracking as tr, glpi_dropdown_locations as dplo
where tr.computer = co.ID
and co.location = dplo.ID
and tr.date BETWEEN '$startdate' and '$enddate'
group by co.location
order by Total_by_Site desc;
voici la 2eme (pour la priorité 1)
select glpi_dropdown_locations.name , count(glpi_tracking.priority)
from glpi_computers, glpi_tracking, glpi_dropdown_locations
where glpi_tracking.priority = 1
and glpi_tracking.computer = glpi_computers.ID
and glpi_computers.location = glpi_dropdown_locations.ID
and glpi_tracking.date BETWEEN '2009/07/01 01:00:00' and '2009/07/30 23:00:00'
et en fait il faudrait arriver au tableau ci dessus. C'est pour cela que nous pensions a des sous-requetes
(une par niveau) mais je ne suis pas du tout sur de çà ...