Subscriber Data Export Command

Note

The command voss subscriber_data_export is equivalent to voss export group subscriber.

More than one type parameter can be specified for the command by using the type parameter for each. For example:

voss export type line type site.

The type parameter values by subscriber group are listed below, as well as a reference to the content details:

The export file directory and file format of the subscriber group is:

  • directory: media/data_export/<YYYY-MM-DD>
  • file naming format: <YYYY-MM-DD_HHMM>_<type>.json.gz

For subscriber group files:

  • A retention policy of 30 days is in place. After each successful extraction of the data, any extract files 31 days old or older will be removed.
  • If an export contains no data, a JSON file will contain an empty JSON list: [].

Example:

media/data_export/2018-10-11/2018-10-11_1236_analogue_line_sccp.json.gz

Command examples:

  • Single type
$ voss export type line
Starting line export, please wait...
Completed line export, created 2018-10-11_1236_line.json.gz.
  • Multiple types
$ voss export type line type site
Starting line export, please wait...
Completed line export, created 2018-10-11_1236_line.json.gz.
Starting site export, please wait...
Completed site export, created 2018-10-11_1236_site.json.gz.
  • Group

    All types in a group are exported.

$ voss export group subscriber
Starting subscriber group export consisting of analogue_line_mgcp, analogue_line_sccp, [...]
Starting analogue_line_mgcp export, please wait...
Completed analogue_line_mgcp export, created 2018-10-11_1236_analogue_line_mgcp.json.gz.
Starting analogue_line_sccp export, please wait...
Completed analogue_line_sccp export, created 2018-10-11_1236_analogue_line_sccp.json.gz.
[...]
Completed subscriber group export.

The export files can then be copied to a remote system. For example, from the VOSS-4-UC system, list out the data export files:

$ ls media/data_export/2018-10-11
2018-10-11_1236_analogue_line_sccp.json.gz

The exported files can be copied to a remote system using SCP or SFTP on port 22. For example:

remote_system:~$ scp <platform_user>@<voss_system>:media/data_export/2018-10-11/2018-10-11_1236_analogue_line_sccp.json.gz .

Important

Since the data export command runs database queries, it is recommended that the data exports be scheduled. Refer to the topic on scheduling for details and syntax.

for example:

schedule add subscriber_export voss export group subscriber

schedule time subscriber_export weekly 1

Best practices for scheduling to consider, are:

  • Individual report exports should be scheduled in a serial manner so that they do not overlap and result in a high database load.
  • For resilience:
    • Stagger the schedule based on how long it is expected to run - in accordance with the number of subscribers in the database.
    • For better failover support, schedules can be created on all active Unified Nodes. This requires a more complex schedule staggering and collection management.
    • For simplified schedule staggering and the export collection management, schedules can be created and staggered on a single Unified Node. This option but requires a manual re-schedule in the case of node failover.