Forum GLPI-Project

ChristopherF

Member

Registered: 2022-08-19

Posts: 3

Reporting possibility of time recording in the activities

Is there a report so that you can report the times entered for activities?

LaDenrée

HELPER

Registered: 2012-11-19

Posts: 6,291

Re: Reporting possibility of time recording in the activities

glpi version ?

activities : do you mean ticket tasks ?

using report plugin, you can create custom reports :

ie to get time spent by tecnician during some periods :
use this request :

SELECT U.`realname` AS UREALNAME, SEC_TO_TIME( sum( T.actiontime ) ) AS TDUREE
FROM `glpi_tickettasks` AS T JOIN `glpi_users` AS U ON T.`users_id` = U.`id`
WHERE 1=1 AND (T.`date_creation`>= '2022-08-01 00:00:00' AND T.`date_creation`<='2022-08-31 23:59:59' ) group by UREALNAME
 

/!\ gdpr regulation (if in EU) : is your goal compatible with  initial purposes ?

---

Trouver la panne avant de réparer...
GLPI10.0.16 (ubuntu 22.04 PHP8.1  Mariadb10.6 ) plugins : comportements 2.7.3 reports 1.16.0 formcreator 2.13.9, datainjection 2.13.5 fields 1.21.9

ChristopherF

Member

Registered: 2022-08-19

Posts: 3

Re: Reporting possibility of time recording in the activities

yes i mean ticket tasks
glpi version is GLPI 9.5.5

i will try that sql-statement

thank you
Christopher

ChristopherF

Member

Registered: 2022-08-19

Posts: 3

Re: Reporting possibility of time recording in the activities

sql statement works fine :-)

thank you