I found this on the HPE Knowledge base:
https://community.hpe.com/t5/Quality-Center-ALM-Practitioners/Re-Setting-a-default-grid-view-for-all-users-in-Defect-Manager/m-p/6564322#M87722
I followed this post to the end and found the 2 step solution and tested it on my test environment.
So, here are the steps:
1. Login to a project and modify the defect module view as desired. Then, login to Site Administration; select the project you just modified and go to the COMMON_SETTINGS table and perform the following SQL query:
UPDATE COMMON_SETTINGS SET CSET_OWNER='__default__'
where CSET_CATEGORY='DefectsModule-000000004243046514'
AND CSET_OWNER=xxxxxx
where xxxxxx is the user name that you changed the Defect Module view.
2. In the template you are using to create new projects, go to Customization Workflow and change the CanLogin function as follows:
Function CanLogin(DomainName, ProjectName, UserName)
On Error Resume Next
Set cs = TDConnection.CommonSettings
Set us = TDConnection.UserSettings
cs.Open ''DefectsModule-000000004243046514''
us.Open ''DefectsModule-000000004243046514''
If us.Value(''ModuleState'') = '''' Then
us.Value(''ModuleState'') = cs.value(''ModuleState'')
End If
cs.Close
us.Post
us.Close
Set us = Nothing
Set cs = Nothing
CanLogin = DefaultRes
On Error GoTo 0
End Function
and Save this code.
Now, when you create create a new project from this template, the Workflow code will be there.
So, after creating a new project from the template, you will still have to perform step 1, but each time you login the Defect Module view should be what you want.
Now, I must add that this solution is not officially supported by HPE or Orasi but I did test it myself and it should decrease the amount of time you use to get the Defect Module view you want for new projects.