Query to find out which reports are built in which client org

Carly Duncan shared this question 21 months ago
Completed

I am relatively new to exploring the yellowfin db schema so apologies if this is obvious. I would like to run a query against the db that tells me whichrepotr are created in which client org. What table(s) is that data stored in?


TIA

Replies (3)

photo
1

Hello Carly,

Thank you for reaching out to yellowfin support,

Every client org has unique iporg which can be found in table name.

993263a604c84a57dc6799df13793884

To find any specific report belongs to which client org you can take reference of iporg in report header table and identify any client org.

13e546fb4a1a9cf3352075580d98a9f0


Let me know if you have any questions.


Regards

Nishant

photo
1

Thanks!

photo
1

Hello Carly,

Thanks for the update,

I'll go ahead and close this ticket, going forward with this if you have any other issues around this, please let me know, I will be more than happy to assist where I can.


Regards

Nishant

Leave a Comment
 
Attach a file