Hi, Is it possible to get the list of updates to be applied to a system using spacecmd? I mean, I'd get a list of patches (with the detail of the specific package to be installed) as it's possible to do with the command "yum check-update --security".

Regards

is spacewalk-report included in rhnss6? if not how do i install it

can we use spacecmd in Satellite 6.2.x ? or its already build in

Hi,

Others already gave you plenty of information about spacecmd and spacewalk-report. Very easy to use tools.

API is powerful too.

In one place I developed Perl script that uses API and provides monthly Excel report with these columns:

System
Latest Base Channel
Latest Child Channels
Missing RHEL SECURITY Packages in Latest Channels
Missing RHEL BugFix and ENHANCEMENT Packages in Latest Channels
Unverified Third-Party Packages
Total Missing RHEL Packages in Latest Channels
System Type
System Role
Upgraded Packages This Month
Last Boot
RHEL System Currency Status

Some snippets from the Perl script:

my $chaninfo = $client->call('system.getSubscribedBaseChannel', $session, $systemid);
my $childs = $client->call('system.listSubscribedChildChannels', $session, $systemid);
...
my $SysErrata = $client->call('system.getRelevantErrata', $session, $systemid);
...
my $getinfo = $client->call('system.getDetails', $session, $system->{'id'});
         foreach my $ginfo ($getinfo) {
            if ( eval "use DateTime::Format::ISO8601" ) {
               my $dtx = DateTime::Format::ISO8601->parse_datetime($ginfo->{'last_boot'});
               $dt = $dt->strftime('%F %T');
            }
            else {
               $dt = sprintf("%d-%02d-%02d%s%s", unpack('A4A2A2AA8', $ginfo->{'last_boot'}->value()));
            }
         }

I never had problem to get approval to use Satellite 5 spacecmd and spacewalk-report, even for customers who are in special environments.

Regards,

Dusan Baljevic (amateur radio VK2COT)

In the simplest possible form:

Answer to your question 1.

spacewalk-report inventory | awk -F"," '{print $1, $8}'

Or, if you want to include hostname:

spacewalk-report inventory | awk -F"," '{print $1, $2, $8}'

"spacewalk inventory" provides these comma-separated reports:

server_id,profile_name,hostname,ip_address,ipv6_address,registered_by,registration_time,last_checkin_time,kernel_version,packages_out_of_date,errata_out_of_date,software_channel,configuration_channel,entitlements,system_group,organization,virtual_host,architecture,is_virtualized,osad_status,hardware

Regards,

Dusan Baljevic (amateur radio VK2COT)