Is it possible to print out a list of security group members

Hi Nick,

If you go to the Shared Reports space on TASK, you will find some security-related reports there that you can install and use. I think the one we used was solution #78, although there are others there as well.  For just grabbing group membership, this simple query will give you all active group members:

SELECT g.UG_name, g.UG_id, ug.userid, u.fname, u.lname

from TX_USER_GROUP ug

inner join T_METUSER u on ug.userid = u.userid

inner join T_METUSERGROUP g on ug.ug_id = g.UG_id

where u.inactive = 'N'

order by g.UG_name, ug.userid

Thanks,

David

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Nick Torres
Sent: Monday, October 7, 2013 12:46 PM
To: David Frederick
Subject: [Tessitura Technical Forum] Is it possible to print out a list of security group members

When I go into the security app I have to look at each group individually to see the members.  Is there a way to print that out in it's entirety?

v. 10.1.0.0

Thanks

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Hi Nick,

If you go to the Shared Reports space on TASK, you will find some security-related reports there that you can install and use. I think the one we used was solution #78, although there are others there as well.  For just grabbing group membership, this simple query will give you all active group members:

SELECT g.UG_name, g.UG_id, ug.userid, u.fname, u.lname

from TX_USER_GROUP ug

inner join T_METUSER u on ug.userid = u.userid

inner join T_METUSERGROUP g on ug.ug_id = g.UG_id

where u.inactive = 'N'

order by g.UG_name, ug.userid

Thanks,

David

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Nick Torres
Sent: Monday, October 7, 2013 12:46 PM
To: David Frederick
Subject: [Tessitura Technical Forum] Is it possible to print out a list of security group members

When I go into the security app I have to look at each group individually to see the members.  Is there a way to print that out in it's entirety?

v. 10.1.0.0

Thanks

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!