Project

General

Profile

Feature #28787

RFE - last_checkin report template

Added by Waldirio Pinheiro over 1 year ago. Updated 11 months ago.

Status:
Closed
Priority:
Normal
Category:
Reporting
Target version:
-
Difficulty:
Triaged:
No
Bugzilla link:

Description

Description of problem:
All the time customers are looking for a way to check the last_checkin just to remove the content host automatically (based on timeframe). For example, virt-who-* servers, hypervisors with more than 10 days without checking could be removed.

Version-Release number of selected component (if applicable):
6.6.z

How reproducible:
100%

Steps to Reproduce:
1. We don't have this report available.
2.
3.

Actual results:
not available

Expected results:
List of content hosts with last_checkin
---
[root@wallsat66 ~]# echo "select h.name,h.id,ksf.host_id,ksf.last_checkin,ksf.hypervisor from katello_subscription_facets as ksf, hosts as h where h.id=ksf.host_id and ksf.hypervisor='t' order by ksf.last_checkin" | su - postgres c "psql foreman"
name | id | host_id | last_checkin | hypervisor
---------------------------------------------
-------------+---------------------+------------
virt-who-esxi1.lab.eng.rdu2.redhat.com-1 | 16 | 16 | 2020-01-10 18:36:44 | t
virt-who-esxi2.lab.eng.rdu2.redhat.com-1 | 17 | 17 | 2020-01-10 18:36:44 | t
virt-who-esxi5.lab.eng.rdu2.redhat.com-1 | 19 | 19 | 2020-01-10 18:36:44 | t
virt-who-newserver.lab.eng.rdu2.redhat.com-1 | 18 | 18 | 2020-01-10 19:37:04 | t
---

Additional info:

Associated revisions

Revision 4021eca3 (diff)
Added by Marek Hulán about 1 year ago

Fixes #28787 - Introduce last host checkin report

History

#1 Updated by Ondřej Pražák over 1 year ago

  • Category set to Templates
  • Project changed from Templates to Foreman

#2 Updated by The Foreman Bot over 1 year ago

  • Status changed from New to Ready For Testing
  • Pull request https://github.com/theforeman/community-templates/pull/739 added

#3 Updated by The Foreman Bot about 1 year ago

  • Pull request https://github.com/theforeman/foreman/pull/7815 added

#4 Updated by The Foreman Bot about 1 year ago

  • Fixed in Releases 2.3.0 added

#5 Updated by Marek Hulán about 1 year ago

  • Status changed from Ready For Testing to Closed

#6 Updated by Tomer Brisker 11 months ago

  • Category changed from Templates to Reporting

Also available in: Atom PDF