how to create an outstanding patch per machine report for Satellite 6

Latest response

Does anyone know how to create a report for Satellite 6 the will display the same type of information that is displayed when I go out the REDHAT and look at my classic registration list. It lists how many Errata and how may packages need to be applied to the registered host. We find this info useful for planning and checking on our patch needs. Is there any help out there with this as the books are not a real big help.

Bob

RT
Log in to join the conversation

Responses

RT Active Contributor 152 points
11 November 2014 9:50 PM

I just got word from support that this is part of Satellite 6.1 but they are looking for a way to do this earlier.

Bob

MT Community Member 25 points
20 November 2014 10:26 AM

https://access.redhat.com/discussions/528013 latest comment

FV Red Hat Active Contributor 120 points
29 March 2015 2:20 PM

@matthias: That is for Satellite 5.

I have created a script for Satellite 6. See https://access.redhat.com/discussions/1395523.

Duncan Innes's picture Guru 2135 points
21 April 2015 3:01 PM

There are still open tickets for a bunch of these kind of things (but also a load of resolved ones) in the Katello issue tracker.

http://projects.theforeman.org/projects/katello/issues

I'd certainly expect this kind of functionality in 6.1 with more to come later. I'm waiting for the ability to report outstanding errata for a Production system by looking at all Errata that have arrived in the Library. Reporting against the current environment is OK, but doesn't then show Errata that are still only in Dev or Test for example.

da Active Contributor 145 points
23 April 2015 4:47 PM

Untill 6.1 is release and if it is not bugged, you might want to use "yum updateinfo list available"

The old way, on all of your servers then parse the results.

KG Community Member 64 points
18 April 2018 10:28 AM

Is this feature available in Redhat Satelite 6.2?

Rich Jerrido's picture Red Hat Guru 2305 points
18 April 2018 12:36 PM

This is trivial to do with Satellite 6.2 and newer:

Firstly, get a list of hosts. use the hammer host list command. Optionally, provide a search query to limit the number of hosts to a host collection or other subset of hosts

#HOST_LIST=$(hammer --output csv host list --search "host_collection = Infrastructure"| cut -f 2 -d ','| tail --lines=+2)

Then given that list of hosts, show their errata

#for host in $HOST_LIST; do echo $host; hammer host errata list --host $host; done
auth01.example.com
---|------------|------|-------|------------
ID | ERRATUM ID | TYPE | TITLE | INSTALLABLE
---|------------|------|-------|------------
kvm01.example.com
---|------------|------|-------|------------
ID | ERRATUM ID | TYPE | TITLE | INSTALLABLE
---|------------|------|-------|------------
monitoring.example.com
---|------------|------|-------|------------
ID | ERRATUM ID | TYPE | TITLE | INSTALLABLE
---|------------|------|-------|------------
rhevm.example.com
------|----------------|----------|----------------------------------|------------
ID    | ERRATUM ID     | TYPE     | TITLE                            | INSTALLABLE
------|----------------|----------|----------------------------------|------------
16931 | RHBA-2018:0597 | bugfix   | tzdata enhancement update        | true
16891 | RHSA-2018:0592 | security | Important: slf4j security update | true
------|----------------|----------|----------------------------------|------------
rhv-hypervisor1.example.com
------|----------------|--------|---------------------------|------------
ID    | ERRATUM ID     | TYPE   | TITLE                     | INSTALLABLE
------|----------------|--------|---------------------------|------------
16931 | RHBA-2018:0597 | bugfix | tzdata enhancement update | true
16882 | RHBA-2018:0580 | bugfix | glusterfs bug fix update  | true
------|----------------|--------|---------------------------|------------
rhv-hypervisor2.example.com
------|----------------|--------|---------------------------|------------
ID    | ERRATUM ID     | TYPE   | TITLE                     | INSTALLABLE
------|----------------|--------|---------------------------|------------
16931 | RHBA-2018:0597 | bugfix | tzdata enhancement update | true
16882 | RHBA-2018:0580 | bugfix | glusterfs bug fix update  | true
------|----------------|--------|---------------------------|------------

You can get creative with the API if you want, but this works too.

Andy Bartholomaus's picture Community Member 67 points
18 September 2018 6:00 PM

Thanks for the commands. but, Trivial? Really? Your definition of that word might need an edit.

KG Community Member 64 points
18 April 2018 2:06 PM

Hi Rich, thanks a lot. Is it also possible to get list of installed errata (possibly with dates)?

US Newbie 16 points
5 October 2018 8:54 AM

Ho w can we create reports in satellite 6.2 ? I do not see any proper documentation

RO Newbie 12 points
17 October 2018 9:19 AM

Satellite 6.3:

! /bin/bash

HOSTS=$(hammer host list | cut -d "|" -f2 | grep -v '---' | grep -v 'NAME') for HOST in $HOSTS; do hammer host errata list --host $HOST >> Errata_Reports.txt done

Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.