
synopsis:

  System groups

description:

  List of all available system groups

columns:

  mgm_id The id of the management server instance that contains this data
  group_id The id of this system group
  name The unique name of this system group
  current_members The current number of members of this system group
  organization The organization that owns this data
  synced_date The timestamp of when this data was last refreshed.

sql:

  SELECT * FROM (
      SELECT mgm_id
                , system_group_id AS group_id
                , name
                , current_members
                , organization
                , synced_date
        FROM SystemGroupsReport
  ) X
  -- where placeholder
  ORDER BY mgm_id, group_id
