Export List of ring group members

[andrew.mcintosh]

We occasionally get asked to provide a list of ring group members.
Is there a way to export this list from 3cx or does anyone know of a Postgresql query we can run to produce the list?

Thanks in advance for any help

 

[andrew.mcintosh]

No worries we figured out the psql query.
If anybody is interested:
SELECT
ringgroup2dn.fkiddn,
ringgroup.name,
users.firstname,
users.lastname,
extension.authid
FROM
public.ringgroup,
public.ringgroup2dn,
public.extension,
public.users
WHERE
ringgroup.idringgroup = ringgroup2dn.fkidringgroup AND
ringgroup2dn.fkiddn = extension.fkiddn AND
extension.idextension = users.fkidextension;

we then used copy to to create csv with , as the delimiter.