Forum

This content is now out of date.

Visit Our Community

Query to get user information in different Client Org

HI Team ,
Could you please let us know the query to get the list of client Orgs does the user have access to or which user has access to which all client orgs from the Yellowfin metadata.

Thanks in Advance



Hi,

hopefully the following query will give you what you're after:

[code]
SELECT smr.IpEmployee, p.FullName, smr.RoleCode, ic.EmailAddress, ir.IpParent, o.OrgName
FROM staffmemberrole smr INNER JOIN person p ON smr.ipemployee = p.ipperson
INNER JOIN IpRltshp ir on smr.IpEmployee = ir.IpChild
INNER JOIN Organisation o on ir.IpParent = o.IpOrg
INNER JOIN IpContact ic on smr.IpEmployee = ic.IpID
[/code]

if not please let us know exactly which fields are required.

regards,
Dave

Thanks for trying Yellowfin

Please complete the form below to request your copy of Yellowfin today.