RyXéo » GLPI

$query2 = "SELECT MD5(e.password),os_license_number,os_license_id FROM glpi_computers AS c

LEFT JOIN glpi_plugin_anet_epacks AS e ON e.FK_serveur=c.ID

WHERE os_license_number!='' AND e.creation_date>'2009-07-06'";

//On supprime les epacks qu'on a marque comme n etant plus sous maintenance

$query2 .= " AND e.FK_contract>'0'";