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:
    7
    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:
    7
    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.