jcervantes-sipecom
commented
2 years ago Reviewing a bit more, I found that the Scheduled Maintenances widget is mostly related to the GLPI Remiders option rather than Tickets, Changes, or Problems.
When I checked the reminder that had been created from the test CHANGE that I created, I came across this date in the Visibility Begin and End part: 2038-01-18 22:14:07
This reminded me of something I reported on GLPI some time ago: https://github.com/glpi-project/glpi/issues/8250
show columns from glpi.glpi_reminders where `Default`= '2038-01-18 22:14:07';
So, using DBeaver, I changed from the database the default values for those columns according to the values that I would think should be between NULL and CURRENT_TIMESTAMP, taking as a reference some data already created for that table:
SELECT * FROM glpi.glpi_reminders;
Where I found that DATE, DATE_MOD, DATE_CREATION will always have data, but BEGIN, END, BEGIN_VIEW_DATE, and END_VIEW_DATE can be NULL.
When re-creating a new test CHANGE, the reminder was no longer created with that default date, but empty. And finally data appeared in the Scheduled Maintenance widget:
I have already created a Ticket template with task and a calendar, also the recurrent Ticket is created correctly, but the widget Scheduled maintenances still has no data.
I also created a Change and Problem and I set up an Alert for My Dashboard, I selected Scheduled maintenances, but the widget still has no data.
How is it configured or what am I doing wrong?