How-To Guides
...
Data Model Dictionary
Built-In Dashboards and Charts
GPO Management Reports
2min
Data can be filtered by the following that make up the policy:
- Date
- Group name
- Action
- User
- Type
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.