Skip to content

adm_report_groups_v

Group reporting view showing member counts, ownership statistics, sharing information, and group folder details for group management and analysis.

Category: Groups - Group management and collaboration analysis

  • Group management
  • Collaboration analysis
  • Access control review

The view contains 15 columns providing comprehensive information:

Column NameDescription
group_idPrimary key of the group.
group_nameUnique name of the group (uppercase).
group_folder_nameLowercase name of the group assigned folder.
descriptionOptional description of the group purpose.
group_folder_idForeign key to the group root folder.
group_folder_pathFull path of the group root folder.
created_dateTimestamp when the group was created.
created_byUser who created the group.
updated_dateTimestamp when the group was last updated.
updated_byUser who last updated the group.
member_countNumber of users who are members of this group.
owned_documents_countNumber of documents owned by this group (non-deleted).
shared_documents_countNumber of documents shared with this group.
shared_folders_countNumber of folders shared with this group.
group_size_categoryGroup size category: EMPTY, SINGLE_MEMBER, or MULTI_MEMBER.

Description: Comprehensive reporting view for groups showing member counts, ownership statistics, sharing information, and group folder details for group management and analysis.

  • Member count tracking
  • Ownership statistics
  • Group size categorization
  • Group folder integration