Forum GLPI-Project

Afol

Member

Registered: 2021-12-23

Posts: 77

activity\tasks statistics

Hi,
when the ticket is managed by a technician he usually inserts a task\activity (hidden from the user who opened the ticket).
How do I get the number of tasks\activities in a date range?

In version 9 of glpi we used "Dashboard" plugin which gave us this detail: https://github.com/stdonato/glpi-dashboard
In glpi version 10 this plugin is no longer supported.
Can I get this data natively with statistics in the new version? If yes, how?
Otherwise, is there another plugin that provides me with this data? Or a database query?

Thank you

Afol

Member

Registered: 2021-12-23

Posts: 77

Re: activity\tasks statistics

uppp

Afol

Member

Registered: 2021-12-23

Posts: 77

Re: activity\tasks statistics

Solved. I use this query:
SELECT COUNT(id) FROM `glpi_tickettasks` WHERE date BETWEEN '2024-02-01 00:00:00' AND '2024-03-01 00:00:00';