Generate Reports

The spacewalk-report command is used to produce a variety of reports. These reports can be helpful for taking inventory of your subscribed systems, users, and organizations. Using reports is often simpler than gathering information manually from the SUSE Manager Web UI, especially if you have many systems under management.

To generate reports, you must have the spacewalk-reports package installed.

The spacewalk-report command allows you to organize and display reports about content, systems, and user resources across SUSE Manager.

You can generate reports on:

System Inventory: list all the systems registered to SUSE Manager.
Patches: list all the patches relevant to the registered systems. You can sort patches by severity, as well as the systems that apply to a particular patch.
Users: list all registered users and any systems associated with a particular user.

To get the report in CSV format, run this command at the command prompt on the server:

spacewalk-report <report_name>

This table lists the available reports:

Table 1. `spacewalk-report` Reports
Report	Invoked as	Description
Actions	`actions`	All actions.
Activation Keys	`activation-keys`	All activation keys, and the entitlements, channels, configuration channels, system groups, and packages associated with them.
Activation Keys: Channels	`activation-keys-channels`	All activation keys and the entities associated with each key.
Activation Keys: Configuration	`activation-keys-config`	All activation keys and the configuration channels associated with each key.
Activation Keys: Server Groups	`activation-keys-groups`	All activation keys and the system groups associated with each key.
Activation Keys: Packages	`activation-keys-packages`	All activation keys and the packages each key can deploy.
Channel Packages	`channel-packages`	All packages in a channel.
Channel Report	`channels`	Detailed report of a given channel.
Cloned Channel Report	`cloned-channels`	Detailed report of cloned channels.
Configuration Files	`config-files`	All configuration file revisions for all organizations, including file contents and file information.
Latest Configuration Files	`config-files-latest`	The most recent configuration file revisions for all organizations, including file contents and file information.
Custom Channels	`custom-channels`	Channel metadata for all channels owned by specific organizations.
Custom Info	`custom-info`	Client custom information.
Patches in Channels	`errata-channels`	All patches in channels.
Patches Details	`errata-list`	All patches that affect registered clients.
All patches	`errata-list-all`	All patches.
Patches for Clients	`errata-systems`	Applicable patches and any registered clients that are affected.
Host Guests	`host-guests`	Host and guests mapping.
Inactive Clients	`inactive-systems`	Inactive clients.
System Inventory	`inventory`	Clients registered to the server, together with hardware and software information.
Kickstart Scripts	`kickstart-scripts`	All kickstart scripts, with details.
Kickstart Trees	`kickstartable-trees`	Kickstartable trees.
All Upgradable Versions	`packages-updates-all`	All newer package versions that can be upgraded.
Newest Upgradable Version	`packages-updates-newest`	Newest package versions that can be upgraded.
Proxy Overview	`proxies-overview`	All proxies and the clients registered to each.
Repositories	`repositories`	All repositories, with their associated SSL details, and any filters.
Result of SCAP	`scap-scan`	Result of OpenSCAP `sccdf` evaluations.
Result of SCAP	`scap-scan-results`	Result of OpenSCAP `sccdf` evaluations, in a different format.
System Data	`splice-export`	Client data needed for splice integration.
System Currency	`system-currency`	Number of available patches for each registered client.
System Extra Packages	`system-extra-packages`	All packages installed on all clients that are not available from channels the client is subscribed to.
System Groups	`system-groups`	System groups.
Activation Keys for System Groups	`system-groups-keys`	Activation keys for system groups.
Systems in System Groups	`system-groups-systems`	Clients in system groups.
System Groups Users	`system-groups-users`	System groups and users that have permissions on them.
History: System	`system-history`	Event history for each client.
History: Channels	`system-history-channels`	Channel event history.
History: Configuration	`system-history-configuration`	Configuration event history.
History: Entitlements	`system-history-entitlements`	System entitlement event history.
History: Errata	`system-history-errata`	Errata event history.
History: Kickstart	`system-history-kickstart`	Kickstart event history.
History: Packages	`system-history-packages`	Package event history.
History: SCAP	`system-history-scap`	OpenSCAP event history.
MD5 Certificates	`system-md5-certificates`	All registered clients using certificates with an MD5 checksum.
Installed Packages	`system-packages-installed`	Packages installed on clients.
System Profiles	`system-profiles`	All clients registered to the server, with software and system group information.
Users	`users`	All users registered to SUSE Manager.
MD5 Users	`users-md5`	All users for all organizations using MD5 encrypted passwords, with their details and roles.
Systems administered	`users-systems`	Clients that individual users can administer.

For more information about an individual report, run spacewalk-report with the option --info or --list-fields-info and the report name. This shows the description and list of possible fields in the report.

For further information on program invocation and options, see the spacewalk-report(8) man page as well as the --help parameter of the spacewalk-report command.