How to check in the database if a resource is unassigned
An unassigned resource has not been assigned to a workgroup. The best way to determine this in the database is to check whether the resourceid in the WorkgroupMember table has a record with "historical=0":
- A record with "historical=0" provides the current GlobalWorkGroupId and WorkGroupId for the resourceid.
- No record with "historical=0" indicates the resource is not currently assigned to a workgroup.