Skip to main content
Planview Customer Success Center

How to identify active users in Changepoint? (2014)

QUESTION

Is there a simple way to restrict a report or a SQL query showing resource data to only include active resources?

 


ANSWER

The best way is to filter your report on "where resource.licensed = 1"

This will return only users that are enterprise users currently assigned to a workgroup. These are the users that can log into Changepoint (and thus consume a license). Unassigned users or undefined users would not be returned using this filter.