Command Line Interface (CLI) based Spacewalk Reports

These reports are script based and can be ran on the server CLI w/o having access to the spw application

you can ssh to the host and run the following report commands with "sudo"

$ spacewalk-report
channel-packages
channels
custom-info
entitlements
errata-channels
errata-list
errata-list-all
errata-systems
inactive-systems
inventory
kickstartable-trees
packages-updates-all
packages-updates-newest
scap-scan
scap-scan-results
system-currency
system-groups
system-groups-keys
system-groups-systems
system-groups-users
system-history
system-history-channels
system-history-configuration
system-history-entitlements
system-history-errata
system-history-kickstart
system-history-packages
system-history-scap
system-packages-installed
users
users-systems

sample command and output
$ spacewalk-report channels
channel_label,channel_name,number_of_packages
centos-4-i386-base,z CentOS 4 i386 Base,1598
centos-4-x86-64-base,z CentOS 4 x86_64 Base,1843
centos5-base-i386,Centos 5 base i386,5542
centos5-base-x86_64,Centos 5 base x86_64,8694
centos5-centosplus-i386,CentOS 5 CentOSPlus - i386,55
centos5-centosplus-x86_64,CentOS 5 CentOSPlus - x86_64,121

Sample command and output
[root@lpm01-oss01-lpm01-app-01 ~]# spacewalk-report inventory | grep 'cli07'

1000033645,lpm01-acd01-lpm01-cli07-01,lpm01-acd01-lpm01-cli07-01,10.239.60.32,::1,space.admin,2020-05-28 21:53:36,2020-06-03 00:45:04,3.10.0-862.2.3.el7.x86_64,252,3,OpenLogic-Mirrors-CentOS 7.7 Base - x86_64;OpenLogic-Mirrors-CentOS 7.7 Updates - x86_64;OpenLogic-Mirrors-CentOS 7.7 Base_CR - x86_64;spacewal-client-2.10_x86_64_epel_7;O_epel7server-x86_64;OpenLogic-Mirrors-CentOS 7.7 Plus - x86_64;OpenLogic-Mirrors-CentOS 7.7 Extras - x86_64,,Spacewalk Management Entitled Servers,gcp-kwfr-sys-grp,mycigar-top-org,,x86_64,No,,offline,1 CPUs 1 Sockets; eth0 10.239.60.32/255.255.255.255 42:01:0a:ef:3c:20; lo 127.0.0.1/255.0.0.0 00:00:00:00:00:00

Output breakdown:
------------------
1000033645, systemID
lpm01-acd01-lpm01-cli07-01, hostname
lpm01-acd01-lpm01-cli07-01, fqdn
10.239.60.32,::1, IPv4 and v6
space.admin, spw user
2020-05-28 21:53:36, date system registered 1st time
2020-06-03 00:45:04, last checked in date/time
3.10.0-862.2.3.el7.x86_64,252,3, kernel version

channel subscription:
OpenLogic-Mirrors-CentOS 7.7 Base - x86_64;
OpenLogic-Mirrors-CentOS 7.7 Updates - x86_64;
OpenLogic-Mirrors-CentOS 7.7 Base_CR - x86_64;
spacewal-client-2.10_x86_64_epel_7;
O_epel7server-x86_64;
OpenLogic-Mirrors-CentOS 7.7 Plus - x86_64;
OpenLogic-Mirrors-CentOS 7.7 Extras - x86_64,,
Spacewalk Management Entitled Servers,

gcp-kwfr-sys-grp, group membership inside the spw server
mycigar-top-org,, org membership inside the spw server
x86_64, CPU Architecture
No,, Auto Errata Update:
offline, OSA Status:
1 CPUs 1 Sockets; system specs (1x cpu, 1x socket)
eth0 10.239.60.32/255.255.255.255 IP address and mask
42:01:0a:ef:3c:20; hw address or mac
lo 127.0.0.1/255.0.0.0 loopback IP and mask
00:00:00:00:00:00 lo hw address or mac

Ref url for this from the official spw site

https://github.com/spacewalkproject/spacewalk/wiki/SpacewalkReport

**Note: if you are setting up new server and need these reports install this pkg "yum install spacewalk-reports.noarch"

Spacewalk CLI based Reports

Command Line Interface (CLI) based Spacewalk Reports