生成报告

SUSE Multi-Linux Manager 允许用户生成各种报告。这些报告有助于清点已订阅的系统、用户和组织。使用报告通常比从 SUSE Multi-Linux Manager Web UI 手动收集信息更方便，尤其是要管理众多的系统时。

虽然可以使用命令行工具 spacewalk-report 生成预配置的报告，但随着Hub Reporting的引入，也可以生成完全自定义的报告。可以通过将任何支持 SQL 语言的报告工具连接到报告数据库并直接提取数据来实现此目的。有关数据可用性和结构的详细信息，请参见报告数据库纲要文档。

1. 使用 spacewalk-report

请在服务器容器内执行相应步骤之前使用 mgrctl term。

要生成报告，必须安装 spacewalk-reports 软件包。使用 spacewalk-report 命令可以组织和显示有关整个 SUSE Multi-Linux Manager 中的内容、系统和用户资源的报告。

由于Hub Reporting的引入，spacewalk-report 现在默认会从报告数据库中收集数据。有关详细信息，请参见 spacewalk-report 和报告数据库。

可以针对以下各项生成报告：

系统库存

列出所有已注册到 SUSE Multi-Linux Manager 的系统。

补丁

列出与已注册系统相关的所有补丁。可以按严重性以及适用于特定补丁的系统将补丁排序。

用户

列出所有已注册用户以及与特定用户关联的所有系统。

要获取 CSV 格式的报告，请在服务器上的命令提示符下运行以下命令：

spacewalk-report <报告名称>

2. spacewalk-report 和报告数据库

spacewalk-report 默认使用新的报告数据库来提取数据。这意味着，新生成的报告在数据结构和格式方面存在一定的差异。所有报告的共同差异是：

  • 报告数据不会实时更改，而只能通过执行安排的任务来更新；

  • 已去除重复数据，以前被视为“多值”的列现在包含多个由 ; 分隔的值。这也意味着命令行选项 --multival-on-rows 和 --multival-separator 不再适用于新报告，因为它们的行为现在是默认行为；

  • 在所有报告中引入了新列 mgm_id 和 synced_date，以标识中心方案中的管理服务器，以及上次从应用程序数据库更新信息的时间；

  • 现在，所有布尔值都由 True/False 表示，而不是由 1/0 值表示；

  • org_id 列已由 organization 取代，后者包含组织名称而不是数字标识符；

  • “server”一词已由“system”取代。因此，举例而言，server_id 列现在名为 system_id。

有关特定于报告的更改，请参见可用报告列表。

如果这种行为更改造成了问题，可以使用新选项 --legacy-report 回退到针对应用程序数据库执行的旧报告。

有关中心报告的详细信息，请参见 Hub Reporting。

3. 可用报告列表

下表列出了可用报告：

Table 1. spacewalk-report 报告
Report Invoked as Description Uses reporting database Specific differences

Actions

actions

All actions.

Yes

The column id is now called action_id

Activation Keys

activation-keys

All activation keys, and the entitlements, channels, configuration channels, system groups, and packages associated with them.

No

Activation Keys: Channels

activation-keys-channels

All activation keys and the entities associated with each key.

No

Activation Keys: Configuration

activation-keys-config

All activation keys and the configuration channels associated with each key.

No

Activation Keys: Server Groups

activation-keys-groups

All activation keys and the system groups associated with each key.

No

Activation Keys: Packages

activation-keys-packages

All activation keys and the packages each key can deploy.

No

Channel Packages

channel-packages

All packages in a channel.

Yes

Channel Report

channels

Detailed report of a given channel.

Yes

Cloned Channel Report

cloned-channels

Detailed report of cloned channels.

Yes

Configuration Files

config-files

All configuration file revisions for all organizations, including file contents and file information.

No

Latest Configuration Files

config-files-latest

The most recent configuration file revisions for all organizations, including file contents and file information.

No

Custom Channels

custom-channels

Channel metadata for all channels owned by specific organizations.

Yes

The column id is now called channel_id

Custom Info

custom-info

Client custom information.

Yes

Patches in Channels

errata-channels

All patches in channels.

Yes

Patches Details

errata-list

All patches that affect registered clients.

Yes

All patches

errata-list-all

All patches.

No

Patches for Clients

errata-systems

Applicable patches and any registered clients that are affected.

Yes

Host Guests

host-guests

Host and guests mapping.

Yes

Inactive Clients

inactive-systems

Inactive clients.

Yes

The mandatory parameter is now called threshold.

System Inventory

inventory

Clients registered to the server, together with hardware and software information.

Yes

The column osad_status has been removed.

Kickstart Scripts

kickstart-scripts

All kickstart scripts, with details.

No

Kickstart Trees

kickstartable-trees

Kickstartable trees.

No

"

All Upgradable Versions

packages-updates-all

All newer package versions that can be upgraded.

Yes

Newest Upgradable Version

packages-updates-newest

Newest package versions that can be upgraded.

Yes

Proxy Overview

proxies-overview

All proxies and the clients registered to each.

Yes

Repositories

repositories

All repositories, with their associated SSL details, and any filters.

No

Result of SCAP

scap-scan

Result of OpenSCAP sccdf evaluations.

Yes

Result of SCAP

scap-scan-results

Result of OpenSCAP sccdf evaluations, in a different format.

Yes

System Data

splice-export

Client data needed for splice integration.

No

System Currency

system-currency

Number of available patches for each registered client.

No

System Extra Packages

system-extra-packages

All packages installed on all clients that are not available from channels the client is subscribed to.

Yes

System Groups

system-groups

System groups.

Yes

System Hardware

system-hardware

System hardware information.

No

Activation Keys for System Groups

system-groups-keys

Activation keys for system groups.

No

Systems in System Groups

system-groups-systems

Clients in system groups.

Yes

System Groups Users

system-groups-users

System groups and users that have permissions on them.

No

History: System

system-history

Event history for each client.

Yes

History: Channels

system-history-channels

Channel event history.

Yes

History: Configuration

system-history-configuration

Configuration event history.

Yes

The column created_date has been removed.

History: Entitlements

system-history-entitlements

System entitlement event history.

Yes

History: Errata

system-history-errata

Errata event history.

Yes

The column created_date has been removed.

History: Kickstart

system-history-kickstart

Kickstart event history.

Yes

The column created_date has been removed.

History: Packages

system-history-packages

Package event history.

Yes

The column created_date has been removed.

History: SCAP

system-history-scap

OpenSCAP event history.

Yes

The column created_date has been removed.

MD5 Certificates

system-md5-certificates

All registered clients using certificates with an MD5 checksum.

No

Installed Packages

system-packages-installed

Packages installed on clients.

Yes

System Profiles

system-profiles

All clients registered to the server, with software and system group information.

No

Users

users

All users registered to SUSE Multi-Linux Manager.

Yes

The column organization_id has been removed.

MD5 Users

users-md5

All users for all organizations using MD5 encrypted passwords, with their details and roles.

Yes

The column organization_id has been removed.

Systems administered

users-systems

Clients that individual users can administer.

Yes

The column organization_id has been removed.

如需单个报告的详细信息，请运行 spacewalk-report 并指定选项 --info 或 --list-fields-info 和报告名称。这会显示该报告中可用字段的说明和列表。

有关程序调用和选项的更多信息，请参见 spacewalk-report(8) 手册页以及 spacewalk-report 命令的 --help 参数。