Beginning of the month scheduler includes new month as well

[davixd]

Hi Icinga2 Reporting team,
I'm making two reports with the timeframe of a month: one by a breadown of a day and the other one by a breadown of a month. Both scheduler are set to start at: 01.10.2022 00:00:00 and frequently by a month. The report by a breadown of a day correctly did report today at 01.10.2022 00:00:00 and included in the report: 01.11.2022 till 30.11.2022. The report by a breadown of a month did report today at 01.10.2022 00:00:00 as well and included in the report: 11.2022 till 12.2022. Why those the report with a breakdown of a month reports the previous month and the actual month?

Report breakdown by a day:

Report breakdown by a month:

I would expect the report breakdown by a month to be also only from 01.11.2022 till 30.11.2022 (just for the previous month).

Report by a breadown of a day settings:

Report by a breadown of a month settings:

Versions in use:
pdfexport 0.10.2
reporting 0.10.0
Icinga Web 2 Version | 2.11.2
PHP Version | 7.3.33

Is it a bug? Or config problem?

Many thanks in advance!

Best regards
David

[lippserd]

@jhoxhaa Please verify.

[davixd]

I'm using:
centos-release-7-9.2009.1.el7.centos.x86_64

icinga-php-thirdparty-0.11.0-1.el7.icinga.noarch
icingaweb2-vendor-Parsedown-2.11.2-1.el7.icinga.noarch
php-Icinga-2.11.2-1.el7.icinga.noarch
icinga-php-library-0.10.0-2.el7.noarch
icingaweb2-common-2.11.2-1.el7.icinga.noarch
icinga2-bin-2.13.6-1.el7.x86_64
icingaweb2-vendor-zf1-2.11.2-1.el7.icinga.noarch
icingaweb2-vendor-JShrink-2.11.2-1.el7.icinga.noarch
icinga2-2.13.6-1.el7.x86_64
icinga2-ido-mysql-2.13.6-1.el7.x86_64
icinga-l10n-1.2.0-1.el7.icinga.noarch
icingaweb2-vendor-HTMLPurifier-2.11.2-1.el7.icinga.noarch
icingaweb2-vendor-dompdf-2.11.2-1.el7.icinga.noarch
icinga2-common-2.13.6-1.el7.x86_64
vim-icinga2-2.13.6-1.el7.x86_64
icinga-php-common-1.0.0-1.el7.icinga.noarch
icingacli-2.11.2-1.el7.icinga.noarch
icingaweb2-2.11.2-1.el7.icinga.noarch
icingaweb2-vendor-lessphp-2.11.2-1.el7.icinga.noarch

google-chrome-stable-107.0.5304.110-1.x86_64

rh-php73-runtime-1-1.el7.x86_64
rh-php73-php-intl-7.3.33-1.el7.x86_64
icinga-php-thirdparty-0.11.0-1.el7.icinga.noarch
rh-php73-php-gd-7.3.33-1.el7.x86_64
php-5.4.16-48.el7.x86_64
rh-php73-php-mbstring-7.3.33-1.el7.x86_64
php-Icinga-2.11.2-1.el7.icinga.noarch
php-cli-5.4.16-48.el7.x86_64
icinga-php-library-0.10.0-2.el7.noarch
php-common-5.4.16-48.el7.x86_64
rh-php73-php-zip-7.3.33-1.el7.x86_64
rh-php73-php-ldap-7.3.33-1.el7.x86_64
rh-php73-php-fpm-7.3.33-1.el7.x86_64
rh-php73-php-pgsql-7.3.33-1.el7.x86_64
php-gd-5.4.16-48.el7.x86_64
rh-php73-php-common-7.3.33-1.el7.x86_64
rh-php73-php-mysqlnd-7.3.33-1.el7.x86_64
rh-php73-php-xml-7.3.33-1.el7.x86_64
rh-php73-php-cli-7.3.33-1.el7.x86_64
rh-php73-php-json-7.3.33-1.el7.x86_64
icinga-php-common-1.0.0-1.el7.icinga.noarch
sclo-php73-php-pecl-imagick-3.4.4-3.el7.x86_64
rh-php73-php-pdo-7.3.33-1.el7.x86_64
rh-php73-php-soap-7.3.33-1.el7.x86_64

[jhoxhaa]

@jhoxhaa Please verify.

Can confirm. It happens because the boundary of the month breakdown is set to 'first day of next month midnight'. The issue is fixed if i change the boundary to 'last day of next month'. This sets the day to the last day of the current month. Should i change it? @lippserd

[davixd]

@lippserd
is there a Update? It would be awesome if @jhoxhaa could change it.

[nilmerg]

We're currently reworking the SLA reporting with Icinga DB, as long as that's not finished we postponed a decision here.