
synopsis:

  Errata out of compliance information - erratas for systems

description:

  Patches out of compliance information with the details about the system.

columns:

  mgm_id The id of the management server instance that contains this data
  advisory The unique name of this advisory
  system_id The id of the system
  profile_name The unique descriptive name of the system
  hostname The hostname that identifies this system
  ip_address The IPv4 address of the primary network interface of the system
  ipv6_address The list of IPv6 addresses and their scopes of the primary network interface of the system, separated by ;
  synced_date The timestamp of when this data was last refreshed.

sql:

  SELECT * FROM (
      SELECT mgm_id
                , advisory_name AS advisory
                , system_id
                , profile_name
                , hostname
                , ip_address
                , ip6_addresses AS ipv6_address
                , synced_date
        FROM ErrataSystemsReport
  ) X
  -- where placeholder
  ORDER BY mgm_id, advisory, system_id
