Note: This bug is displayed in read-only format because
the product is no longer active in Red Hat Bugzilla.
Red Hat Satellite engineering is moving the tracking of its product development work on Satellite to Red Hat Jira (issues.redhat.com). If you're a Red Hat customer, please continue to file support cases via the Red Hat customer portal. If you're not, please head to the "Satellite project" in Red Hat Jira and file new tickets here. Individual Bugzilla bugs will be migrated starting at the end of May. If you cannot log in to RH Jira, please consult article #7032570. That failing, please send an e-mail to the RH Jira admins at rh-issues@redhat.com to troubleshoot your issue as a user management inquiry. The email creates a ServiceNow ticket with Red Hat. Individual Bugzilla bugs that are migrated will be moved to status "CLOSED", resolution "MIGRATED", and set with "MigratedToJIRA" in "Keywords". The link to the successor Jira issue will be found under "Links", have a little "two-footprint" icon next to it, and direct you to the "Satellite project" in Red Hat Jira (issue links are of type "https://issues.redhat.com/browse/SAT-XXXX", where "X" is a digit). This same link will be available in a blue banner at the top of the page informing you that that bug has been migrated.
Description of problem: Applied errata report doesn't consider input Since and 'Up to'. It returns all the result.
Selected Since 15th Oct and upto 15th Oct But result contains 18th Oct
date hostname erratum_id erratum_type status
2020-09-18 08:59:33 +0530 rhel7u5-1.gsslab.rdu2.redhat.com RHBA-2020:3615 bugfix success
Satellite log also confirm, since and up_to is not in parameter list
here is production log
~~~
2020-10-15T18:22:06 [I|app|b56f2285] Started POST "/templates/report_templates/197-Applied%20Errata/schedule_report" for 10.74.9.242 at 2020-10-15 18:22:06 +0530
2020-10-15T18:22:06 [I|app|b56f2285] Processing by ReportTemplatesController#schedule_report as HTML
2020-10-15T18:22:06 [I|app|b56f2285] Parameters: {"utf8"=>"✓", "authenticity_token"=>"vqzyuzBcNUhF++JBl7ZpoPHTMo3hq9f6z43VMfALv+Du7hKZTcV7F98biivLDzfNSfCCo9bwBH+kgpSsrBgxqw==", "report_template_report"=>"[FILTERED]", "commit"=>"Submit", "id"=>"197-Applied Errata"}
2020-10-15T18:22:07 [I|app|b56f2285] Enqueued TemplateRenderJob (Job ID: d96240ac-c6d4-4951-a30c-c1d7bd2eff2a) to Dynflow(default) with arguments: {"template_id"=>"197-Applied Errata", "gzip"=>false, "send_mail"=>false, "mail_to"=>"a", "format"=>"csv", "input_values"=>{"55"=>{"value"=>"all"}, "56"=>{"value"=>"no"}, "57"=>{"value"=>"success"}}}, {:user_id=>62}
2020-10-15T18:22:07 [I|app|b56f2285] Redirected to https://dhcp131-99.gsslab.pnq2.redhat.com/templates/report_templates/197-Applied%20Errata/report_data?job_id=d96240ac-c6d4-4951-a30c-c1d7bd2eff2a
2020-10-15T18:22:07 [I|app|b56f2285] Completed 302 Found in 182ms (ActiveRecord: 22.7ms)
~~~
Version-Release number of selected component (if applicable): Satellite 6.7
How reproducible: Always
Steps to Reproduce:
1. Go to Monitor -> Report Template --> "Host - Applied Errata" --> generate
2. Fill up Since and Up to
3. It doesn't consider since and upto and list all applied errata
Actual results: Return wrong result
Expected results: Should consider since and upto input value.
Additional info:
Hammer works fine, here is an exaple
# hammer report-template generate --name "Applied Errata" --inputs 'Filter Errata Type="all",Include Last Reboot="no",Status="success",Since="2020-09-18 00:29:30",Up to="2020-09-18 03:50:33"'
date,hostname,erratum_id,erratum_type,status
2020-09-18 03:29:33 UTC,rhel7u5-1.gsslab.rdu2.redhat.com,RHBA-2020:3615,bugfix,success
Upon review of our valid but aging backlog the Satellite Team has concluded that this Bugzilla does not meet the criteria for a resolution in the near term, and are planning to close in a month. This message may be a repeat of a previous update and the bug is again being considered to be closed. If you have any concerns about this, please contact your Red Hat Account team. Thank you.
Verified on 6.13 - Snap 12
Steps to Verify:
1) Register a host.
2) Enable and Sync a repository that includes applicable erratum.
3) Apply at least 1 errata to a host.
4) Generate a "Applied Errata" report
Expected Results:
When using either Since or Up To options in the template, the report will respect these parameters.
Actual Results:
When using either Since or Up To options in the template, the report will respect these parameters.
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.
For information on the advisory (Important: Satellite 6.13 Release), and where to find the updated
files, follow the link below.
If the solution does not work for you, open a new bug report.
https://access.redhat.com/errata/RHSA-2023:2097
Description of problem: Applied errata report doesn't consider input Since and 'Up to'. It returns all the result. Selected Since 15th Oct and upto 15th Oct But result contains 18th Oct date hostname erratum_id erratum_type status 2020-09-18 08:59:33 +0530 rhel7u5-1.gsslab.rdu2.redhat.com RHBA-2020:3615 bugfix success Satellite log also confirm, since and up_to is not in parameter list here is production log ~~~ 2020-10-15T18:22:06 [I|app|b56f2285] Started POST "/templates/report_templates/197-Applied%20Errata/schedule_report" for 10.74.9.242 at 2020-10-15 18:22:06 +0530 2020-10-15T18:22:06 [I|app|b56f2285] Processing by ReportTemplatesController#schedule_report as HTML 2020-10-15T18:22:06 [I|app|b56f2285] Parameters: {"utf8"=>"✓", "authenticity_token"=>"vqzyuzBcNUhF++JBl7ZpoPHTMo3hq9f6z43VMfALv+Du7hKZTcV7F98biivLDzfNSfCCo9bwBH+kgpSsrBgxqw==", "report_template_report"=>"[FILTERED]", "commit"=>"Submit", "id"=>"197-Applied Errata"} 2020-10-15T18:22:07 [I|app|b56f2285] Enqueued TemplateRenderJob (Job ID: d96240ac-c6d4-4951-a30c-c1d7bd2eff2a) to Dynflow(default) with arguments: {"template_id"=>"197-Applied Errata", "gzip"=>false, "send_mail"=>false, "mail_to"=>"a", "format"=>"csv", "input_values"=>{"55"=>{"value"=>"all"}, "56"=>{"value"=>"no"}, "57"=>{"value"=>"success"}}}, {:user_id=>62} 2020-10-15T18:22:07 [I|app|b56f2285] Redirected to https://dhcp131-99.gsslab.pnq2.redhat.com/templates/report_templates/197-Applied%20Errata/report_data?job_id=d96240ac-c6d4-4951-a30c-c1d7bd2eff2a 2020-10-15T18:22:07 [I|app|b56f2285] Completed 302 Found in 182ms (ActiveRecord: 22.7ms) ~~~ Version-Release number of selected component (if applicable): Satellite 6.7 How reproducible: Always Steps to Reproduce: 1. Go to Monitor -> Report Template --> "Host - Applied Errata" --> generate 2. Fill up Since and Up to 3. It doesn't consider since and upto and list all applied errata Actual results: Return wrong result Expected results: Should consider since and upto input value. Additional info: Hammer works fine, here is an exaple # hammer report-template generate --name "Applied Errata" --inputs 'Filter Errata Type="all",Include Last Reboot="no",Status="success",Since="2020-09-18 00:29:30",Up to="2020-09-18 03:50:33"' date,hostname,erratum_id,erratum_type,status 2020-09-18 03:29:33 UTC,rhel7u5-1.gsslab.rdu2.redhat.com,RHBA-2020:3615,bugfix,success