---
title: GPO Management Reports
slug: kronpam-how-to-guides/gpo-management-reports
description: Learn how to effectively filter data in this document and explore three insightful charts: Recently Created GPO's, User Rights Assignment, and Recently Modified GPO's. Discover valuable information on policy groups, rules, and updates by applying various 
docTags: 
createdAt: 2022-08-18T16:43:22.000Z
---

# Filter

Data can be filtered by the following that make up the policy:

- Date
- Group name
- Action
- User
- Type

# Charts

**Recently Created GPO's: **Filters and displays how many policy groups have policies. Three tables are used for this chart: Policy Groups, Policy Rules, and the realm table of the 2 tables.     

- **sc\_policy\_key\_group: **Policy groups are defined here. The **action** column of this table is checked for the action** **filter. SQL SERVER 17 PG is an example of a policy group.
- **sc\_policy\_key:** The** **policy rule has also been defined here. **Type **(BLACK / WHITE) and **user\_create** that are used when filtering are also read from this table.
- **sc\_policy\_key\_group\_to\_keys: **Realm table. By joining the other 2 tables, the desired chart model is created.


**User Rights Assignment: **A chart showing which users define how many policies from the policies assigned to the policy groups. It is the same as the User Rights Assignment chart in the realm relationship.
**group\_name **is used, instead of **user\_create**. In addition, policy type **BLACK **is considered, while **WHITE **policies are ignored.

**Recently Modified GPO's: **The Recently Modified GPO chart is filtered by last\_update date. It displays how many policy updates the policy group has.