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