https://connect.hyland.com/t5/alfresco-forum/database-query-to-get-all-sites-and-its-users/m-p/121954#M33441 <P>Hi&nbsp;<A href="https://migration33.stage.lithium.com/t5/user/viewprofilepage/user-id/76245">@Syedjunaid</A>&nbsp;</P> <P>You might find this blog on <A href="https://blog.dbi-services.com/alfresco-some-useful-database-queries/" target="_self" rel="nofollow noopener noreferrer">Alfresco database queries</A> useful.</P> <P>HTH</P> Wed, 09 Dec 2020 13:57:24 GMT EddieMay 2020-12-09T13:57:24Z https://connect.hyland.com/t5/alfresco-forum/database-query-to-get-all-sites-and-its-users/m-p/121953#M33440 <P>Can anyone please tell me what would be the database query to get all sites with its users? or Get all users with the site they are member of.</P> Wed, 09 Dec 2020 12:42:30 GMT https://connect.hyland.com/t5/alfresco-forum/database-query-to-get-all-sites-and-its-users/m-p/121953#M33440 Syedjunaid 2020-12-09T12:42:30Z https://connect.hyland.com/t5/alfresco-forum/database-query-to-get-all-sites-and-its-users/m-p/121954#M33441 <P>Hi&nbsp;<A href="https://migration33.stage.lithium.com/t5/user/viewprofilepage/user-id/76245">@Syedjunaid</A>&nbsp;</P> <P>You might find this blog on <A href="https://blog.dbi-services.com/alfresco-some-useful-database-queries/" target="_self" rel="nofollow noopener noreferrer">Alfresco database queries</A> useful.</P> <P>HTH</P> Wed, 09 Dec 2020 13:57:24 GMT https://connect.hyland.com/t5/alfresco-forum/database-query-to-get-all-sites-and-its-users/m-p/121954#M33441 EddieMay 2020-12-09T13:57:24Z https://connect.hyland.com/t5/alfresco-forum/database-query-to-get-all-sites-and-its-users/m-p/121955#M33442 <P>Hi&nbsp;<A href="https://migration33.stage.lithium.com/t5/user/viewprofilepage/user-id/76783">@EddieMay</A>&nbsp;,</P><P>Already checked the link you provided but there is no query to get site with its users.</P> Thu, 10 Dec 2020 06:05:23 GMT https://connect.hyland.com/t5/alfresco-forum/database-query-to-get-all-sites-and-its-users/m-p/121955#M33442 Syedjunaid 2020-12-10T06:05:23Z