GPO Management Reports

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