Perform the Query

Lets you perform the query from this computer or from a remote server.

Perform the Query from this Computer
Click this option to run the query from this computer. This option will access the Inventory database on the specified database server and export the data in to a comma separated value (CSV) file.

Perform the Query on a Remote Server
Click this option to run the data export tool from any server that has Workstation Inventory components installed.

Accessing the Inventory database from a server is recommended if you are exporting data from a large database or if you have specified complex queries for filtering the workstations.

After you choose this option, you will be prompted to save the data export settings to a configuration file (.EXP).

From the server console:
  1. Run DBEXPORT.NCF on NetWare® servers or DBEXPORT.BAT on Windows* NT*/2000 servers. Type DBEXPORT configuration_filename.EXP csv_filename.CSV
    where configuration_filename.EXP is an existing file that contains the data export settings. The data exported from the database will be stored in the csv_filename.CSV file.

    The corresponding .CFG file for the .EXP file should be in the same folder as the .EXP file. The .CFG file contains the list of the database attributes to be exported.

  2. Choose the Inventory sites.
The number of workstations displayed indicates the status of the data export. To view the exported data, open the .CSV file in Microsoft* Excel, or any other CSV-supported viewer.


ZENworks for Desktops Online Documentation

A trademark symbol (®, TM, etc.) denotes a Novell trademark. An asterisk (*) denotes a third-party trademark. For more information on trademarks, see Legal Notices.