[Spacewalk-list] Spacewalk-list Digest, Vol 133, Issue 9

[P.Cookson at bham.ac.uk]

Hi Merphis

The “spacewalk-report” tool outputs information in a CSV format.

The related package needs to be installed from the Spacewalk repository:

                # yum -y install spacewalk-reports		(note plural "s" on end)
                
The man page for spacewalk-report is in the usual format and there is also an option "--list-fields-info" that is helpful:

# spacewalk-report --list-fields

See report descriptions below – we find the “system-currency” report useful:

•	channel-packages - Packages in channels 
•	channels - Channel report 
•	custom-info - Display system custom info 
•	entitlements - Entitlement and channel list and usage 
•	errata-channels - List of errata in channels 
•	errata-list - Errata information based upon compliance checks against systems 
•	errata-list-all - List of all erratas 
•	errata-systems - Listing of each errata applicable to each affected system 
•	inactive-systems - Inactive systems in Satellite 
•	inventory - Inventory report 
•	kickstartable-trees - List of kickstartable trees 
•	packages-updates-all - List of packages that can be upgraded 
•	packages-updates-newest - List of packages that can be upgraded 
•	scap-scan - Results of OpenSCAP xccdf evaluation 
•	scap-scan-results - Results of OpenSCAP xccdf evaluation 
•	system-crash-count - Crash count for systems 
•	system-crash-details - Crash details for systems 
•	system-currency - System currency list 
•	system-groups - System groups in Satellite 
•	system-groups-keys - Activation keys for system groups 
•	system-groups-systems - Systems in system groups 
•	system-groups-users - System groups users report 
•	system-history - System event history 
•	system-history-channels - Channel event history 
•	system-history-configuration - Configuration event history 
•	system-history-entitlements - System entitlement event history 
•	system-history-errata - Errata event history 
•	system-history-kickstart - Kickstart event history 
•	system-history-packages - Package event history 
•	system-history-scap - OpenSCAP event history 
•	system-packages-installed - Packages installed on systems 
•	users - Users in the system 
•	users-systems - Systems administered by individual users 

The output could be piped through awk to get just the columns of info you’re interested in perhaps - see example command below:

                # spacewalk-report inventory | awk -F"," '{print $4, $3, $8}' > inventory.csv

In addition, the “spacecmd” tool is also available from the Spacewalk repository and can be installed on a system other than the Spacewalk server to execute reporting queries and other commands remotely.

Regards
Phil

-----Original Message-----
From: spacewalk-list-bounces at redhat.com <spacewalk-list-bounces at redhat.com> On Behalf Of mianosm at gmail.com
Sent: 12 June 2019 20:08
To: spacewalk-list at redhat.com
Subject: Re: [Spacewalk-list] Spacewalk-list Digest, Vol 133, Issue 9

It is not included by default, you'd have to install the "spacewalk-reports" package.

This provides approximately 51 reports (and you can easily extend those once you see what they are, located in /usr/share/spacewalk/reports/data ).

~Steven


On 6/12/19 12:11, Ellis, Merphis wrote:
> I do not see that program on my system I am running spacewalk 2.7
>
> -----Original Message-----
> From: spacewalk-list-bounces at redhat.com 
> <spacewalk-list-bounces at redhat.com> On Behalf Of 
> spacewalk-list-request at redhat.com
> Sent: Wednesday, June 12, 2019 12:01 PM
> To: spacewalk-list at redhat.com
> Subject: Spacewalk-list Digest, Vol 133, Issue 9
>
> Send Spacewalk-list mailing list submissions to 
> spacewalk-list at redhat.com
>
> To subscribe or unsubscribe via the World Wide Web, visit 
> https://www.redhat.com/mailman/listinfo/spacewalk-list
> or, via email, send a message with subject or body 'help' to 
> spacewalk-list-request at redhat.com
>
> You can reach the person managing the list at 
> spacewalk-list-owner at redhat.com
>
> When replying, please edit your Subject line so it is more specific than "Re: Contents of Spacewalk-list digest..."
>
>
> Today's Topics:
>
>    1. Re: cvs report of packages (Michael Mraka)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Wed, 12 Jun 2019 15:55:04 +0200
> From: Michael Mraka <michael.mraka at redhat.com>
> To: spacewalk-list at redhat.com
> Subject: Re: [Spacewalk-list] cvs report of packages
> Message-ID: <20190612135504.GC4150 at magni.brq.redhat.com>
> Content-Type: text/plain; charset=utf-8
>
> Ellis, Merphis:
>> I need to get a list of currently install packages on some systems.
>> I see I can get a list of the files that not the same with the compare function, but do not see how to get a list of what is installed on a base system.
> Hello Ellis,
>
> as root on spacewalk server run
>
>    spacewalk-report system-packages-installed
>
>> Making plans actionable!
>>
>> Regards,
>>
>> Merphis Ellis
> --
> Michael Mr?ka
> System Management Engineering, Red Hat
>
>
>
> ------------------------------
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
>
> End of Spacewalk-list Digest, Vol 133, Issue 9
> **********************************************
>
>
> ________________________________
>
> This message is only for the use of the intended recipient and may contain information that is CONFIDENTIAL and PROPRIETARY to IDEMIA. If you are not the intended recipient, please erase all copies of the message and its attachments and notify the sender immediately.
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list