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:
- Select the database fields in
Database Fields window.
- 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.
- 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.
- Save the configurations settings to an .EXP file.
- 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