FOG Reporting - query issue?


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


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

  • Moderator

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

360
Online

8.6k
Users

15.3k
Topics

143.5k
Posts