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-boun...@redhat.com <spacewalk-list-boun...@redhat.com> On
Behalf Of mian...@gmail.com
Sent: 12 June 2019 20:08
To: spacewalk-list@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-boun...@redhat.com
> <spacewalk-list-boun...@redhat.com> On Behalf Of
> spacewalk-list-requ...@redhat.com
> Sent: Wednesday, June 12, 2019 12:01 PM
> To: spacewalk-list@redhat.com
> Subject: Spacewalk-list Digest, Vol 133, Issue 9
>
> Send Spacewalk-list mailing list submissions to
> spacewalk-list@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-requ...@redhat.com
>
> You can reach the person managing the list at
> spacewalk-list-ow...@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.mr...@redhat.com>
> To: spacewalk-list@redhat.com
> Subject: Re: [Spacewalk-list] cvs report of packages
> Message-ID: <20190612135504.gc4...@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@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@redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
_______________________________________________
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list
