Subscriber Data Export Command

Note

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

Important

  • To optimise performance, run and schedule the data export command from the secondary database server if possible.

  • Since a data export can take time, the voss subscriber_data_export and voss export commands can only be run in a screen session. First run screen and then voss export and its parameters. See also: Using the screen command.

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

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 .