FOG Reporting - query issue?

[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?

[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.

[Wayne Workman]

The figures seem much more stable now, much less fluctuations. Thank you @Quazz !