topic Re: Selecting users,groups and site from database in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/selecting-users-groups-and-site-from-database/m-p/308180#M261310 <HTML><HEAD></HEAD><BODY><SPAN>test</SPAN></BODY></HTML> Sun, 08 Jun 2014 17:12:42 GMT svetlingulev 2014-06-08T17:12:42Z Selecting users,groups and site from database https://connect.hyland.com/t5/alfresco-archive/selecting-users-groups-and-site-from-database/m-p/308179#M261309 Hi,I would like to select users,in which groups they are, and their sites.. I wan it with a single postgre sql query.I've found&nbsp; these queries, but i want them combined with join if possible.select * from alf_permissionselect * from ALF_AUTHORITY select * from ALF_CHILD_ASSOC where CHILD_NODE_NAME l Sun, 08 Jun 2014 13:15:34 GMT https://connect.hyland.com/t5/alfresco-archive/selecting-users-groups-and-site-from-database/m-p/308179#M261309 svetlingulev 2014-06-08T13:15:34Z Re: Selecting users,groups and site from database https://connect.hyland.com/t5/alfresco-archive/selecting-users-groups-and-site-from-database/m-p/308180#M261310 <HTML><HEAD></HEAD><BODY><SPAN>test</SPAN></BODY></HTML> Sun, 08 Jun 2014 17:12:42 GMT https://connect.hyland.com/t5/alfresco-archive/selecting-users-groups-and-site-from-database/m-p/308180#M261310 svetlingulev 2014-06-08T17:12:42Z