Project and Portfolio Management Practitioners Forum
cancel

Creating a list linking Security Group with Title from Resource Page

SOLVED
Go to solution
Highlighted
dasfweg
Trusted Contributor.

Creating a list linking Security Group with Title from Resource Page

Good morning,

Im trying to create a list of people within a certain Security Group and their Titles (from the Modify Resources page).

I have the list from the Security group:

 

select b.first_name, b.last_name
from knta_user_security a, knta_users b
where a.user_id = b.user_id
and a.security_group_id = 30145

 

And i have the Resource Title info:

 

select * from knta_lookups where lookup_type = 'RSC - Resource Title'

order by meaning

 

But i cant find the table(s) that link the two together.

Any ideas?

1 REPLY
Erik Cole
Acclaimed Contributor.
Solution

Re: Creating a list linking Security Group with Title from Resource Page

SELECT u.user_id, u.full_name, u.username, u.email_address,u.resource_title_meaning
FROM knta_users_v u, knta_user_security_v kus
      where u.user_id = kus.user_id
and kus.security_group_name = 'YOUR GROUP NAME'