Some helpful queries related to groups are described in this section. These queries are based on the information presented in this chapter.
The following query retrieves information about a group named
SELECT group_name, group_address, owner_name, group_admin FROM dm_group WHERE group_name = 'zone1_all'
The following query retrieves the names of the groups that a user named
John is a member of, directly or indirectly (through nested group memberships):
SELECT group_name FROM dm_group WHERE ANY i_all_users_names = 'John'
The following query retrieves the names of the users and groups that are direct members of a group named
SELECT r_object_id, users_names, groups_names FROM dm_group WHERE group_name = 'zone_all' ...