Skip to main content
Language Selector

  1. Other Languages

    (machine translation)

Planview Customer Success Center

How to check in the database if a resource is unassigned

  1. Last updated
  2. Save as PDF

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.