Project and Portfolio Management Practitioners Forum
cancel

License by User

SOLVED
Go to solution
Highlighted
CHorta
Frequent Contributor.

License by User

Hi,

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

 

Thank you.

2 REPLIES
Mohit_Agrawal
Outstanding Contributor.
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
Frequent Contributor.

Re: License by User

Thank you!