FOG Reporting - query issue?
Wayne Workman last edited by Wayne Workman
I’ve been watching the figures from the new FOG Reporting very frequently. The numbers fluctuate but there seems to be a really significant downwards fluctuation when we pass UTC midnight 00:00 every day.
Just a bit earlier today, there was something like 52 total fog systems in the last 7 days. A little later after UTC midnight it’s dropped to 42.
The timestamp in the database is a standard MariaDB datetime field. This is how the total count is gathered:
select count(id) from versions_out_there where creation_time >= DATE(NOW()) - INTERVAL 7 DAY;
Maybe this is wrong?
Wayne Workman last edited by
The figures seem much more stable now, much less fluctuations. Thank you @Quazz !
@Wayne-Workman DATE() returns the date without the timestamp. So it will be assumed to be 00:00:00
Use just NOW() and drop DATE(), so that it is updated more accurately.