Aug 16 2010

GLPI Ticket User Group Auto Assignment

Published by at 1:28 pm under GLPI

GLPI user has to select the group he belongs to when creating a ticket or else the field remains empty.
This stored procedure automatically assigns all tickets to the user’s group. Setup a cron job to run it every so often.

update SI_BD.glpi_tracking t
set t.fk_group= (
   FROM SI_BD.glpi_users u, SI_BD.glpi_groups g, SI_BD.glpi_users_groups ug
   WHERE = ug.fk_users
   AND = ug.fk_groups
   LIMIT 0 , 1)
where t.fk_group is null or t.fk_group='' or t.FK_group=0;

No responses yet

Comments RSS

Leave a Reply