What changes were made to the GPO_REPOSITORY database in the 6.9 upgrade?

  • 7023154
  • 03-Jul-2018
  • 03-Jul-2018

Environment

Group Policy Administrator 6.8.3
Group Policy Administrator 6.9

Situation

Changes were made to tables and stored procedures in the upgrade from GPA 6.8.3 to GPA 6.9

Resolution

Here is the summary changes made to the GPO_REPOSITORY data base.

 

GPA 6.8.3 to GPA 6.9

            Tables added:

                                gpa_rep_activeviews

                                gpa_rep_activeview_members

                                gpa_rep_assignments

                                gpa_rep_assignment_members

                                gpa_rep_roles

               

                Store procedures added:

                                fa_rep_SetLinkOrderOfGposForSom

                                gpa_rep_UpdateLinkOrderOfGpo

                                gpa_rep_createActiveView

                                gpa_rep_renameActiveView

                                gpa_rep_deleteActiveView

                                gpa_rep_updateActiveView

                                fa_rep_enumerateActiveViews

                                fa_rep_enumerateActiveViewMembers

                                fa_rep_getActiveViewIdByName

                                fa_rep_GetActiveView

                                gpa_rep_getGprPathByID

                                gpa_rep_createAssignment

                                gpa_rep_renameAssignment

                                gpa_rep_deleteAssignment

                                gpa_rep_updateAssignment

                                fa_rep_enumerateAssignments

                                fa_rep_enumerateAssignmentMembers

                                fa_rep_enumerateAssignmentMembersByType

                                fa_rep_getAssignmentIdByName

                                fa_rep_GetAssignment

                                fa_rep_RemoveObjectSecurity

                                gpa_rep_createRole

                                gpa_rep_renameRole

                                gpa_rep_deleteRole

                                gpa_rep_updateRole

                                gpa_rep_enumerateRoles

                                gpa_rep_getRoleIdByName

                                gpa_rep_GetRole

                                fa_rep_enumerateAssignmentIDsByGPRObject

                                fa_rep_enumerateAssignmentIDsByMember

                                gpa_rep_AVandAssignmentCleanup

                                gpa_rep_AssignmentCleanup

                                gpa_rep_getGprHierarchicalPathAndTypeByID

               

Stored procedures altered:

                fa_rep_deleteFolder

                fa_rep_deleteGpo

 

                SQL Functions altered:

                                fa_rep_fnGetObjectName

 

GPA 6.9 to GPA 6.9.1

            Stored procedures altered:

                        fa_rep_fnGpoDomainName

fa_rep_createGPInFolder


Cause

The upgrade from 6.8.3 to 6.9 changed some tables and stored procedures