Inventory Database Export

Lets you customize the inventory data you want to export from the Inventory database to a comma separated value (CSV) file. Select the inventory components that you need and further filter the data to export to a CSV file format. For example, to generate the data containing the name and version of the operating system, select the inventory components such as operating system name and operating system version and specify any other additional filters. All workstations satisfying the filter you specify in the selected database will be exported to a CSV file.

If you save the settings, you can reload the configuration file later to export the data.
Create a New Database Query
Lets you add a new query that defines the inventory fields such as hardware, software, network, and others that you want to export. You can also specify the criteria to limit the workstations and the database to be included in the query. Based on the inventory components and criteria you specify, the inventory data from the database is exported to a CSV file.

To create a new database query:
  1. Select the database fields in Database Fields window.


  2. Use the default settings to export the inventory component information from all databases as described in Defined Query window, or specify the filter conditions for workstations in Define Query window.


  3. Select whether to run the data export processing from the workstation computer or from any server.

    Running the data export from a server is recommended if you have a large database or if you have a complex query for filtering the workstations.


  4. Save the configurations settings to an .EXP file.


  5. Specify the .CSV filename.

Open a Saved Database Query
Lets you load an existing configuration file (.EXP). After you load the .EXP file, you can modify the settings for data export and then export the data to a CSV file.

The default directory for .EXP files is CONSOLEONE\version\REPORTING\EXPORT.

When you open an existing database query, you load an existing .EXP file as described in Inventory Database Queries and modify the settings, if required. Then you export the data to a .CSV file.

ZENworks for Desktops Online Documentation