---
title: Group Management Reports
slug: kronpam-how-to-guides-180/group-management-reports
description: Learn about the powerful filtering options presented in this document, allowing you to easily sort and manage data within a system. Discover how to filter by system group, system name, access protocol, and element type for seamless organization. Visualize
docTags: 
createdAt: 2022-08-18T16:43:20.000Z
---

# Filter

Data can be filtered by:

- System Group (device group)
- System Name (Device name)
- Access protocol
- Element type


Charts
======

| **Realms for System-User:**  | It returns the list of the realm, system group, system name, user group, username, access protocol, and element type.<br />This chart was obtained by joining the ids of the tables below. It basically shows the interconnected list of devices/users, enabling the understanding of which device group/user group it is on. |
| ---------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **device \_realm\_view**     | The user name is pulled from here                                                                                                                                                                                                                                                                                             |
| **t \_group**                | User group name is pulled from here                                                                                                                                                                                                                                                                                           |
| **t \_device\_group**        | The device group name is pulled from here                                                                                                                                                                                                                                                                                     |
| **t \_device**               | Returns the defined device list. Access protocol, element type and device name are drawn from this table                                                                                                                                                                                                                      |

| **System-System Group:&#xA0;**    | his chart lists the interconnected ones according to the realms between System and System Groups (device and device group). The following three tables are used. |
| --------------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **t \_device\_to\_device\_group** | The device group and device realm are defined here                                                                                                               |
| **t \_device\_group**             | The device group is defined here                                                                                                                                 |
| **t \_device**                    | Device information is defined here                                                                                                                               |

| **User-User Group:&#xA0;** | This chart lists the users assigned to the user groups. The following three tables are used.  |
| -------------------------- | --------------------------------------------------------------------------------------------- |
| **t \_group\_users**       | User group and user id stored realm table                                                     |
| **t \_group**              | User groups are defined here                                                                  |
| **t \_user**               | Users are defined here                                                                        |