Tables
| Table / View | Children | Parents | Columns | Type | Comments |
|---|---|---|---|---|---|
| account | 4 | 0 | 13 | Table | The list of the user authorized to access a SUSE Manager instance |
| accountgroup | 0 | 2 | 9 | Table | The list of groups a user is a member of |
| accountsreport | 0 | 0 | 14 | View | List of all users for all organizations, with their details and roles. |
| accountssystemsreport | 0 | 0 | 8 | View | Systems administered by individual users |
| actionsreport | 0 | 0 | 12 | View | List of all actions performed on all systems |
| channel | 8 | 0 | 13 | Table | The list of channel managed by a SUSE Manager instance |
| channelerrata | 0 | 4 | 6 | Table | The list of patches distributed by a channel |
| channelpackage | 0 | 4 | 4 | Table | The list of packages distributed by a channel |
| channelpackagesreport | 0 | 0 | 10 | View | List of all packages in all channels. |
| channelrepository | 0 | 4 | 5 | Table | The list of the repositories of a channel |
| channelsreport | 0 | 0 | 7 | View | List of all channels with number of packages in each channel. |
| clonedchannelsreport | 0 | 0 | 8 | View | List of cloned channels with their original channel. |
| customchannelsreport | 0 | 0 | 12 | View | Channel metadata for all channels owned by an organization |
| custominforeport | 0 | 0 | 7 | View | Display all custom info for every system with any info associated |
| errata | 4 | 0 | 14 | Table | The list of patches managed by a SUSE Manager instance |
| erratachannelsreport | 0 | 0 | 6 | View | List of all erratas and their relation to channels. |
| erratalistreport | 0 | 0 | 10 | View | Patches out of compliance information with their details. |
| erratasystemsreport | 0 | 0 | 9 | View | Patches out of compliance information with the details about the system. |
| historyreport | 0 | 0 | 9 | View | Event history for each system. |
| hostguestsreport | 0 | 0 | 4 | View | List all systems, along with their guests |
| inventoryreport | 0 | 0 | 27 | View | List of all registered systems, together with hardware and software information. |
| package | 4 | 0 | 14 | Table | The list of the packages managed by a SUSE Manager instance |
| packagesupdatesallreport | 0 | 0 | 12 | View | List of packages that can be updated for all systems, showing all available newer versions. |
| packagesupdatesnewestreport | 0 | 0 | 12 | View | List of packages that can be updated for all systems, showing only the newest package version available. |
| proxyoverviewreport | 0 | 0 | 6 | View | List of proxies and the systems registered through them |
| repository | 2 | 0 | 8 | Table | The list of repositories managed by a SUSE Manager instance |
| scapscanreport | 0 | 0 | 20 | View | List the SCAP scans performed for each system. |
| scapscanresultreport | 0 | 0 | 11 | View | List the identifiers and the results of SCAP rules for each scan performed. |
| system | 30 | 0 | 28 | Table | The list of systems managed by a SUSE Manager instance |
| systemaction | 3 | 2 | 15 | Table | The list of the actions performed on a system |
| systemchannel | 0 | 4 | 9 | Table | The list of channels a system is subscribed to |
| systemconfigchannel | 0 | 2 | 6 | Table | The list of configuration channels a system is subscribed to |
| systemcustominfo | 0 | 2 | 7 | Table | List custom pieces of information related to a system |
| systementitlement | 0 | 2 | 10 | Table | Lists the entitlements of a system |
| systemerrata | 0 | 4 | 7 | Table | The list of patches applicable to a system |
| systemextrapackagesreport | 0 | 0 | 10 | View | List all packages installed on a system that are not available from any of the channels the system is subscribed to |
| systemgroup | 4 | 0 | 7 | Table | The list of system groups managed by a SUSE Manager instance |
| systemgroupmember | 0 | 4 | 6 | Table | The list of system group a system is member of |
| systemgrouppermission | 0 | 4 | 5 | Table | The list of additional user accounts allowed to access a system group |
| systemgroupsreport | 0 | 0 | 6 | View | List of all available system groups |
| systemgroupssystemsreport | 0 | 0 | 6 | View | List of all systems which belongs to any system group |
| systemhistory | 0 | 2 | 8 | Table | The history events associated to a system |
| systemhistoryautoinstallationreport | 0 | 0 | 10 | View | Automatic installations event history. |
| systemhistorychannelsreport | 0 | 0 | 8 | View | Channel event history. |
| systemhistoryconfigurationreport | 0 | 0 | 10 | View | Configuration event history. |
| systemhistoryentitlementsreport | 0 | 0 | 8 | View | System entitlement event history. |
| systemhistoryerratareport | 0 | 0 | 10 | View | Patch event history. |
| systemhistorypackagesreport | 0 | 0 | 10 | View | Package event history. |
| systemhistoryscapreport | 0 | 0 | 10 | View | OpenSCAP event history. |
| systeminactivityreport | 0 | 0 | 7 | View | List of the inactivity period of all systems. |