SQL query to fetch groups

[nikes]

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                 VERSION    NS_ID            local_name
107832015    0      107831558    authorityContainer
107832017           0      107831558   authorityName
107831592    1      107831554     authorityName
107831595    1      107831554    authorityContainer
107834322    0      107831558   authorityDisplayName
‍‍‍‍‍‍‍‍

Does this mean alfresco makes use of two different STORES to manage groups?
URI for NS_ID 107831554  = http://www.alfresco.org/model/user/1.0
URI for NS_ID 107831558  = http://www.alfresco.org/model/content/1.0

Our system has gone through many upgrades since 2.1 version and currently we using 3.4.x.

Thanks

[andy]

Hi

Alfresco 4 supports SQL queries to find authorities.

Andy