topic SQL query to fetch groups in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/sql-query-to-fetch-groups/m-p/273390#M226520 <HTML><HEAD></HEAD><BODY><SPAN>Hello,</SPAN><BR /><BR /><SPAN>I am trying to fetch list of groups using SQL.</SPAN><BR /><BR /><SPAN>I have few questions:</SPAN><BR /><BR /><SPAN>I ran this:</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />select * from alf_qname where local_name like 'authority%';<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>which returned:</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VERSION&nbsp;&nbsp;&nbsp; NS_ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; local_name<BR />107832015 &nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 107831558 &nbsp;&nbsp;&nbsp;authorityContainer<BR />107832017&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 107831558&nbsp;&nbsp;&nbsp;authorityName<BR />107831592 &nbsp;&nbsp;&nbsp;1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 107831554&nbsp; &nbsp;&nbsp;&nbsp;authorityName<BR />107831595 &nbsp;&nbsp;&nbsp;1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 107831554 &nbsp;&nbsp;&nbsp;authorityContainer<BR />107834322 &nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 107831558&nbsp;&nbsp;&nbsp;authorityDisplayName<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>Does this mean alfresco makes use of two different STORES to manage groups?</SPAN><BR /><SPAN>URI for NS_ID 107831554&nbsp; = </SPAN><A href="http://www.alfresco.org/model/user/1.0" rel="nofollow noopener noreferrer">http://www.alfresco.org/model/user/1.0</A><BR /><SPAN>URI for NS_ID 107831558&nbsp; = </SPAN><A href="http://www.alfresco.org/model/content/1.0" rel="nofollow noopener noreferrer">http://www.alfresco.org/model/content/1.0</A><BR /><BR /><SPAN>Our system has gone through many upgrades since 2.1 version and currently we using 3.4.x.</SPAN><BR /><BR /><SPAN>Thanks</SPAN></BODY></HTML> Wed, 17 Oct 2012 15:13:11 GMT nikes 2012-10-17T15:13:11Z SQL query to fetch groups https://connect.hyland.com/t5/alfresco-archive/sql-query-to-fetch-groups/m-p/273390#M226520 Hello,I am trying to fetch list of groups using SQL.I have few questions:I ran this:select * from alf_qname where local_name like 'authority%';‍‍‍which returned:ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VERSION&nbsp;&nbsp;&nbsp; NS_ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; local_name107832015 &nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 107831558 &nbsp;&nbsp;&nbsp;authorityContainer107832017&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1078 Wed, 17 Oct 2012 15:13:11 GMT https://connect.hyland.com/t5/alfresco-archive/sql-query-to-fetch-groups/m-p/273390#M226520 nikes 2012-10-17T15:13:11Z Re: SQL query to fetch groups https://connect.hyland.com/t5/alfresco-archive/sql-query-to-fetch-groups/m-p/273391#M226521 <HTML><HEAD></HEAD><BODY><SPAN>Hi</SPAN><BR /><BR /><SPAN>Alfresco 4 supports SQL queries to find authorities.</SPAN><BR /><BR /><SPAN>Andy</SPAN></BODY></HTML> Wed, 17 Oct 2012 16:21:31 GMT https://connect.hyland.com/t5/alfresco-archive/sql-query-to-fetch-groups/m-p/273391#M226521 andy 2012-10-17T16:21:31Z