Each resource is supposed to choose a default partition when they initially sign on to Clarity. Is there a SQL I can run to determine which partition each resource has chosen?
Try something like
SRM_RESOURCES.ID = ODF_CA_RESOURCE.ID
AND SRM_RESOURCES.IS_ACTIVE =1
AND PRJ_RESOURCES.PRISROLE = 0
for the resources who have a default partition set. If it is not set you would need left join.
That will not bring the user partition memberships which can be given directly through group memberships etc.
Retrieving data ...