Skip to main content
Planview Customer Success Center

Active and Terminated Users at application level (2012 SP1)

Question:

How can we find out in Changepoint:

a) when a user was added or removed at application level ?
b) how many users were added last year and when ?
If there is a database table, which captures this info, can you let me know or share the query to pull the above info from database, please.

 

 


Answer:

If you need to find the users added on Application level, then you can query the resource table in the DB and filter them on the CreatedOn, HireDate and TerminationDate. Apart from this you can also filter on the Employee type too.