Hi Jon,

Thanks for the information.
I understand that this will not be possible within labkey, I was more interested in accomplishing this task by connecting to postgres directly.

I also understand that this might be a security issue if we were to expose this to other users. Our goal is to build a integrated user tracking system with all our our platform components, one of which is labkey, and this will solely be managed by our internal team and will not be visible on our web labkey instance.

I have been trying to figure out how to get the information using the postgres tables, but I find the column names to be very confusing and would appreciate some guidance on this.

There are container ids, groupids, user ids (but they are not really user ids depending on table) entity ids, and bunch of other columns and I am not sure how they are all connected and if possible I would appreciate a diagram or an explanation about all the tables in the core schema.

Thanks
Alper