Dismiss Notice
We would like to remind you that we’re updating our login process for all 3CX forums whereby you will be able to login with the same credentials you use for the Partner or Customer Portal. Click here to read more.

Export List of ring group members

Discussion in '3CX Phone System - General' started by andrew.mcintosh, Oct 7, 2014.

Thread Status:
Not open for further replies.
  1. andrew.mcintosh

    Joined:
    Aug 14, 2013
    Messages:
    9
    Likes Received:
    0
    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
     
  2. andrew.mcintosh

    Joined:
    Aug 14, 2013
    Messages:
    9
    Likes Received:
    0
    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.
     
Thread Status:
Not open for further replies.