DB Export

About this task

Optionally configure the guest user database export parameters. The guest user database can be periodically exported to an external server for backup and analysis.

To define the database export parameters:

Procedure

  1. Select ConfigurationServicesGuest Management.
    Review existing guest management configurations to determine whether new configuration requires creation or an existing guest user configuration requires modification or deletion.
  2. Select the DB Export tab.
    Click to expand in new window
    Guest Management - Add/Edit - DB Export Tab
    GUID-CD2A4660-8281-42D0-A9A5-F1AA12A03BCC-low.png
  3. Set the following DB Export parameters:
    Enable Enable this setting to configure the guest user database to an external server for backup and analysis. This setting is disabled by default and must be enabled to define the required settings.
    Start Time Define the start time when the first database backup occurs. The first run of the guest user database backup is always the current day. Use the spinner controls to set the start hour and minute. Use the AM/PM options to configure the exact hour. The default value is 12:00 AM.
    Frequency Define the backup frequency. This is the time interval between two consecutive backups. Use the spinner control to set the value between 1 hour and 168 hours. The default frequency is 4 hours.
    Format The guest user database can be exported in the following formats:
    • CSV
    • JSON

    Select the appropriate export format. The default export format is CSV.

    Last Visit Time Use this field to filter or restrict the amount of data that is exported. Use the spinner to set a value in the range 1 - 168 hours. When set, any data that is older than the set period - from when the database is being backed up - is not exported.

    The default value is 4 hours.

    URL Directory Use the field to provide the URL to which the guest user database is exported. Select the Advanced link to expose fields for setting the remote server‘s URL.
    Protocol Select the protocol used for exporting the guest user database. Available options include:
    • tftp
    • ftp
    • sftp
    • http
    • cf
    • usb1-4
    Port Use the spinner control to set the port. This option is not valid for cf and usb1-4.
    Host Provide the hostname string or numeric IP address of the server to export the guest user database to. Hostnames cannot include an underscore character. This option is not valid for cf and usb1-4.

    Select IPv4 Address to use an IPv4 formatted address as the host. Select IPv6 Address to use an IPv6 formatted address as the host. IPV6 provides enhanced identification and location information for computers on networks routing traffic across the Internet. IPv6 addresses are composed of eight groups of four hexadecimal digits separated by colons.

    Path/File Specify the path on the remote server where the guest user database file is copied to. Enter the complete relative path to the file on the remote server.
  4. Click OK to save the updates to the guest management DB Export configuration.
    Click Reset to revert the screen back to its last saved configuration.