Skip to main content
Language Selector

  1. Other Languages

    (machine translation)

Planview Customer Success Center

How to identify active users in Changepoint? (2014)

  1. Last updated
  2. Save as PDF

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.