<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <meta name="Generator" content="Microsoft Word 15 (filtered medium)"> <style></style> </head> <body lang="EN-GB" link="blue" vlink="purple"> <div class="WordSection1"> Hi Matthias<o:p></o:p> <o:p> </o:p> Have you looked at the standard Spacewalk reports or “spacecmd” command at all?<o:p></o:p> <o:p> </o:p> The “spacewalk-report” tool outputs information in a CSV format.<o:p></o:p> <o:p> </o:p> The related package needs to be installed from the Spacewalk repository:<o:p></o:p> <o:p> </o:p> # yum -y install spacewalk-reports<o:p></o:p> <o:p></o:p> The man page for spacewalk-report is in the usual format and there is also an option "--list-fields-info" that is helpful:<o:p></o:p> <o:p> </o:p> # spacewalk-report --list-fields<o:p></o:p> <o:p> </o:p> See report descriptions below – the “system-currency” report might be useful for what you’re after?<o:p></o:p> <![if !supportLists]>· <![endif]>channel-packages - Packages in channels <o:p></o:p> <![if !supportLists]>· <![endif]>channels - Channel report <o:p></o:p> <![if !supportLists]>· <![endif]>custom-info - Display system custom info <o:p></o:p> <![if !supportLists]>· <![endif]>entitlements - Entitlement and channel list and usage <o:p></o:p> <![if !supportLists]>· <![endif]>errata-channels - List of errata in channels <o:p></o:p> <![if !supportLists]>· <![endif]>errata-list - Errata information based upon compliance checks against systems <o:p></o:p> <![if !supportLists]>· <![endif]>errata-list-all - List of all erratas <o:p></o:p> <![if !supportLists]>· <![endif]>errata-systems - Listing of each errata applicable to each affected system <o:p></o:p> <![if !supportLists]>· <![endif]>inactive-systems - Inactive systems in Satellite <o:p></o:p> <![if !supportLists]>· <![endif]>inventory - Inventory report <o:p></o:p> <![if !supportLists]>· <![endif]>kickstartable-trees - List of kickstartable trees <o:p></o:p> <![if !supportLists]>· <![endif]>packages-updates-all - List of packages that can be upgraded <o:p></o:p> <![if !supportLists]>· <![endif]>packages-updates-newest - List of packages that can be upgraded <o:p></o:p> <![if !supportLists]>· <![endif]>scap-scan - Results of OpenSCAP xccdf evaluation <o:p></o:p> <![if !supportLists]>· <![endif]>scap-scan-results - Results of OpenSCAP xccdf evaluation <o:p></o:p> <![if !supportLists]>· <![endif]>system-crash-count - Crash count for systems <o:p></o:p> <![if !supportLists]>· <![endif]>system-crash-details - Crash details for systems <o:p></o:p> <![if !supportLists]>· <![endif]>system-currency - System currency list <o:p></o:p> <![if !supportLists]>· <![endif]>system-groups - System groups in Satellite <o:p></o:p> <![if !supportLists]>· <![endif]>system-groups-keys - Activation keys for system groups <o:p></o:p> <![if !supportLists]>· <![endif]>system-groups-systems - Systems in system groups <o:p></o:p> <![if !supportLists]>· <![endif]>system-groups-users - System groups users report <o:p></o:p> <![if !supportLists]>· <![endif]>system-history - System event history <o:p></o:p> <![if !supportLists]>· <![endif]>system-history-channels - Channel event history <o:p></o:p> <![if !supportLists]>· <![endif]>system-history-configuration - Configuration event history <o:p></o:p> <![if !supportLists]>· <![endif]>system-history-entitlements - System entitlement event history <o:p></o:p> <![if !supportLists]>· <![endif]>system-history-errata - Errata event history <o:p></o:p> <![if !supportLists]>· <![endif]>system-history-kickstart - Kickstart event history <o:p></o:p> <![if !supportLists]>· <![endif]>system-history-packages - Package event history <o:p></o:p> <![if !supportLists]>· <![endif]>system-history-scap - OpenSCAP event history <o:p></o:p> <![if !supportLists]>· <![endif]>system-packages-installed - Packages installed on systems <o:p></o:p> <![if !supportLists]>· <![endif]>users - Users in the system <o:p></o:p> <![if !supportLists]>· <![endif]>users-systems - Systems administered by individual users <o:p></o:p> <o:p> </o:p> The output could be piped through awk to get just the columns of info you’re interested in perhaps - see example command below:<o:p></o:p> <o:p> </o:p> # spacewalk-report inventory | awk -F"," '{print $4, $3, $8}' > inventory.csv<o:p></o:p> <o:p> </o:p> 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.<o:p></o:p> <o:p> </o:p> Regards<o:p></o:p> Phil<o:p></o:p> <o:p> </o:p> From: spacewalk-list-bounces@redhat.com <spacewalk-list-bounces@redhat.com> On Behalf Of MGruber@metzler.com Sent: 12 February 2019 14:56 To: spacewalk-list@redhat.com Subject: [Spacewalk-list] List of patched/to patched systems by commandline<o:p></o:p> <o:p> </o:p> Hi! I am seeking for a way to determine via commandline or SQL-select, which systems are patched (no patches to apply) and which ones needed to be patched. I have used system_listerrata with a SSM, but the output is. well a little bit verbose, the Hostname would be enough Does anyone have some hint or trick for me, to get that done? cheers Matthias ------------------------------------------------------------------------------------ METZLER Informationstechnologie Matthias Gruber IT-Infrastruktur & -Betrieb B. Metzler seel. Sohn & Co. Kommanditgesellschaft auf Aktien Untermainanlage 1 60329 Frankfurt am Main Telefon (0 69) 21 04 - 43 30 Telefax (0 69) 21 04 - 40 40 <a href="mailto:MGruber@metzler.com">MGruber@metzler.com</a> <a href="www.metzler.com">www.metzler.com</a> Persönlich haftende Gesellschafter: Harald Illy, Michael Klaus, Friedrich von Metzler, Emmerich Müller, Gerhard Wiesheu Vorsitzender des Aufsichtsrats: Dr. Christoph Schücking Sitz der Gesellschaft: Frankfurt am Main, Handelsregister-Nr. HRB 27 515 Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfänger sein, so bitten wir Sie höflich, dies unverzüglich dem Absender mitzuteilen und die Nachricht zu löschen. Es ist unzulässig, die Nachricht unbefugt weiterzuleiten oder zu kopieren. Da wir nicht die Echtheit oder Vollständigkeit der in dieser Nachricht enthaltenen Informationen garantieren oder zusichern können, sind die vorstehenden Ausführungen rechtlich nicht bindend. Eine Haftung hierfür wird ausgeschlossen. This message is confidential. If you are not the intended recipient, we kindly ask you to inform the sender and delete the information. Any unauthorised dissemination or copying hereof is prohibited. As we cannot guarantee or assure the genuineness or completeness of the information contained in this message, the statements set forth above are not legally binding. Accordingly we cannot accept any liability for their contents. <o:p></o:p> </div> </body> </html>