Skip to main content
Planview Customer Success Center

How to identify base user license?

QUESTION:

How to identify a base user license?


ANSWER:

A Base User License is used for every resource record that is marked as “Enterprise User” and are assigned to a workgroup.

Use the query below to retrieve the information:

select rf.FeatureCode, r.name 'Resource', wg.name 'Workgroup', r.ResourceType, r.Licensed
from ResourceFeature rf
left outer join resources r on rf.ResourceId = r.ResourceId
left outer join WorkgroupMember wm on r.ResourceId = wm.ResourceId and Historical = 0
left outer join Workgroup wg on wm.WorkgroupId = wg.WorkgroupId
where rf.FeatureCode = 'BUL'
order by wg.name, r.name