Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

License by User

SOLVED
Go to solution
Highlighted
CHorta
Occasional Advisor

License by User

Hi,

How do I know what kind of license is assigned to each user?

 

Thank you.

2 REPLIES
Mohit_Agrawal
Frequent Visitor
Solution

Re: License by User

Please use below query.

 

 

select ku.first_name "First Name", ku.last_name "Last Name",
       kp.product_name "Product Name"
from KNTA_USERS ku, KNTA_USER_PRODUCTS kup, KNTA_PRODUCTS kp
where ku.end_date is not null  ---For active users
and ku.user_id = kup.user_id
and kp.product_id = kup.product_id

 

 

Thanks

Mohit

CHorta
Occasional Advisor

Re: License by User

Thank you!

//Add this to "OnDomLoad" event