How do i get a list of all users per Organisation?

Hello Jimmar Claro Tangkia,

My name is Ankit Asati from the Yellowfin Technical Support Team. We have received your support request, and I will be your primary contact on the following ticket:

Ticket Number: #32161
Case Title: How do i get a list of all users per Organisation?

Issue Overview:
How do i get a list of all users per Organisation?

Request for Additional Information:

To better understand and expedite the resolution of your case, please provide me following details:

• The info.jsp file for this instance in HTML format. In order to get this file please follow the instructions in the following link: https://community.yellowfinbi.com/topic/how-to-get-the-info-jsp/

Next Steps and Workarounds:

Please allow us some time while we fetch the information for you, Please share requested information.

Sincerely,

Ankit Asati

Yellowfin Technical Support Engineer

Here you go

Hello Jimmar Claro Tangkia,

Thank you for your patience,

The IpRltshp table outlines the connection between individuals and their respective organizations. The IpParent field represents the organization code, while the IpChild field indicates the user's ID. in order to retrieve information about 'ACTIVE' users within an organization, we can utilize a query similar to the one provided below.

SELECT o.OrgName, ir.IpChild, p.IpPerson, p.LastName, p.FirstName
FROM Person p
JOIN IpRltshp ir
ON p.IpPerson = ir.IpChild
JOIN Organisation o
ON ir.IpParent = o.IpOrg
where p.Status = 'ACTIVE'
AND ir.IpParent = <OrgCode>

Kindly update their IpParent to Organization id which can be retrieved from the Organization table within the configuration database.

We have the capability to adjust the query to display the required fields from various tables. Hope it helps!

Thank you,

Ankit Asati

Yellowfin Technical Support

Hello Jimmar Claro Tangkia

I wanted to follow up with you regarding the solution I provided in my last email. Did the solution we sent you resolve the issue?

Please let us know if you need additional support on this issue.

Thank you,

Ankit Asati

Yellowfin Technical Support

Hello Jimmar Claro Tangkia

I wanted to follow up with you regarding the solution I provided in a previous email. Did the solution we sent you resolve the issue?

If you are unavailable right now, you can always contact us again at a later time by opening a new ticket I will close this case by the end of business tomorrow if I do not receive a reply.

Please let us know if you need additional support on this issue.

Thank you,

Ankit Asati

Yellowfin Technical Support

Hi Ankit, you can close this case now.

Hello Jimmar Claro Tangkia

I am glad to hear the issue was resolved, thank you for the confirmation on closure of the case. If you have any other issue please contact us again by opening up a new ticket and we will provide additional support.

Thank you,

Ankit Asati

Yellowfin Technical Support