
synopsis:

  System Hardware report

description:

  List of all registered systems, together with hardware information.

columns:

  mgm_id The id of the management server instance that contains this data
  system_id The id of the system
  profile_name The unique descriptive name of the system
  hostname The hostname that identifies this system
  machine_id The identifier of the machine
  architecture The architecture of the system

  cpus The total number of CPUs of the system - sometimes called vCPUs
  sockets The total number of CPU Sockets of the system
  cores The number of Cores of a single CPU
  threads The number of Threads of a single Core
  cpu_bogomips The CPU bogomips value
  cpu_cache The CPU cache size in KiB
  cpu_family The CPU family
  cpu_mhz The CPU frequence in MHz
  cpu_stepping The CPU stepping
  cpu_flags The CPU flags
  cpu_model The CPU model
  cpu_version The CPU version
  cpu_vendor The CPU vendor
  memory_size The amount of RAM of the system in MiB
  swap_size The amount of swap space of the system in MiB
  vendor The system vendor
  system Additional information about the system
  product The Product information of the system
  bios_vendor The bios vendor
  bios_version The bios version
  bios_release The bios release date
  asset The assets of the system
  board The board information of the system
  primary_interface The name of the system primary network interface
  hardware_address The MAC address of the network interface
  ip_address The IPv4 address of the primary network interface of the system
  ip6_addresses The list of IPv6 addresses and their scopes of the primary network interface of the system, separated by ;
  is_virtualized True if the system is virtualized
  synced_date The timestamp of when this data was last refreshed.

sql:

  SELECT * FROM (
      SELECT mgm_id
                 , system_id
                 , profile_name
                 , hostname
                 , machine_id
                 , architecture
                 , cpus
                 , sockets
                 , cores
                 , threads
                 , cpu_bogomips
                 , cpu_cache
                 , cpu_family
                 , cpu_mhz
                 , cpu_stepping
                 , cpu_flags
                 , cpu_model
                 , cpu_version
                 , cpu_vendor
                 , memory_size
                 , swap_size
                 , vendor
                 , system
                 , product
                 , bios_vendor
                 , bios_version
                 , bios_release
                 , asset
                 , board
                 , primary_interface
                 , hardware_address
                 , ip_address
                 , ip6_addresses
                 , is_virtualized
                 , synced_date
        FROM SystemHardwareReport
  ) X
  -- where placeholder
  ORDER BY mgm_id, system_id
