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 in order to further filter the data to export to a CSV file format.
For example, to generate the data containing the name and the version of the operating system, select the inventory components such as operating system name, operating system version, and specify any other additional filters.
All systems satisfying the conditions 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 systems 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, or specify the filter conditions for systems in Defined Query window.
- Select whether to run the data export processing from the inventoried server or inventoried workstation.
Running the data export from an inventoried server or workstation is recommended if you have a large database or if you have a complex query for filtering the inventoried servers or workstations.
- Save the configuration settings to a .EXP file.
- Specify the .CSV filename.
- Click Finish.
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.
A trademark symbol (®, TM, etc.) denotes a Novell trademark. An asterisk denotes a third-party trademark. For more information, see Legal Notices.