search

Icinga / icingaweb2-module-reporting

Icinga Reporting is the central component for reporting related functionality in the monitoring web frontend and framework Icinga Web 2.
GNU General Public License v2.0
65 stars 24 forks source link

Beginning of the month scheduler includes new month as well #166

Open davixd opened 2 years ago

davixd commented 2 years ago

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: image

Report breakdown by a month: image

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: image image

Report by a breadown of a month settings: image image

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 commented 1 year ago

@jhoxhaa Please verify.

davixd commented 1 year ago

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 commented 1 year ago

@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 commented 1 year ago

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

nilmerg commented 1 year ago

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