Export Audit Data

		1. Overview
		2. Creation of an Export Setup document
		3. Content of the Export Result document
		4. Specific export: Server Load

Desktop audit results may be exported as XML or CSV files for use outside of the Desktop Manager database environment. By organizing the information coming from user desktops in an external database, it is possible to provide a relational dimension to the collected information, and permit the building of select or sort queries (e.g. to determine the list of people accessing the X database on the Y server).

The data coming from user desktop audits is exported from within the Audit Results / Search & Export / Export Setup view using Export Setup documents.

6 Export Setup documents are predefined in the Desktop Manager database:

• Export Config: Exported information about the Notes client installation (Release, Program folder, Data folder, Notes.ini path, Cache.dsk path, Desktop.dsk path, Number of databases on the workspace, Number of local databases, Size of all local databases...).

• Export Desktop Config: Exported information about the desktop's hardware and software configuration (operating system, memory, screen resolution, hard drives, network information, regional settings, time zone...).

• Export DskMgr Installation : Exported information about the Desktop Manager installation on the user desktop (binaries installation paths, binaries versions, run dates, run time...).

• Export Local Databases : Exported information about Notes databases present on the local drive (Path, Replica ID, ODS, Number of documents, Size, Usage %, Encryption level, Template...).

• Export Mail : Exported information about the user's mailbox (Mail server name, File name, Database size, Number of documents, Size of Quota, Template name, Presence of delegation...).

• Export Workspace Databases : Exported information about database icons present on the workspace (Database name, Replica ID, Server name).

These documents can be used immediately: just select them and press on the button in the Audit Results / Search & Export / Export Setup view to start data export.

It is possible to modify existing Export Setup documents or to create new ones with the  button. The following fields should be filled in:

Parameters

: Name of the Export Setup document.

: Full text edit box to specify the type of Export Setup document or information related to it.

: Name of the last user that has modified the document. Creation and latest modification dates of the document.



: Type of Audit documents used to search for the data to export. These can be either User, or Notes Install documents or the result of a @Formula.

: It is possible to export all documents or just the documents that belong to users selected in the Desktop Manager database.



: Full path where the export file will be created. Clicking on the icon displays a FileSelectionBox Windows window where you can specify file location in the desktop folder structure.

: Export file format. For CSV files, the used separator is ";". For XML files, XML tags are defined further in this document.

: If the option is checked, the created file during export will be attached to the Export Result result document detailed below.

: If the option is checked, a first line will be added in the file created during export. In CSV format, the line will include the heading of columns matching the exported fields. For an XML file, the first line will specify the used character set (<?xml version="1.0" encoding="ISO-8859-1"?>).

: The system allows exporting multi-value fields. For XML export, it is possible to enter here the value of the tag that will be used to define multi-value information.

: If the option is checked, the file created during export will be compressed in ZIP format.

Export Fields

This section is used to define fields and values that will be exported along with their description (for a CSV file) or their tag (for an XML file).

• In the first column, Field Name, select the name of the field to export. The list displayed depends on the type of document to export.
• The second column, Field Type, is used to define how the values of selected fields are exported:
  
  • One value. Get only the first one only exports the first field value.
  • One value, Group all values together exports the values coming from a multi-value field as a single value.
  • Multi-values, Explode all values exports the values coming from a multi-value field with as many lines as there are values (for a CSV file) or with the tag defined above (for an XML file).
• The third column, Label /XML Tag, is used to define the column headings (first line in the CSV file) or the tag names for each field (XML field).

Each export procedure start generates an Export Result result document in the Desktop Manager database including export execution statistics and possibly the file containing the results.

: Name of the used Export Setup document.

: Start and end date of the export procedure.

: Notes link to the used Export Setup document.

: Number of documents read in the Desktop Manager database along with the number of lines generated in the export file.

: Format of the file generated during export (CSV or XML).

: Path where the export file has been created.

: Attached file containing the export results, if the Attach file in result option has been checked in the used Export Setup document.

The User Audit Results / Hardware & Network view of the Desktop Manager database includes an export button that can be used to generate a CSV file displaying concurrent accesses to the Desktop Manager database. This CSV file is used to measure the morning load on Desktop Manager databases when users start their Notes client and run the application.

Back to Top