16.11.2 Executing an export operation
An export operation is executed by specifying conditions. These export conditions must have already been created.
To specify conditions and execute an export operation:
-
Specify search conditions as appropriate, and then click the Search button.
A search is conducted for export conditions that match the search conditions.
-
Select the radio button for the name of the desired set of conditions, and then click the Execute button.
The window switches to a window for executing the export operation.
-
Filter the conditions if necessary.
To filter the output items, use the Set Condition dialog box that is displayed by clicking the Filter link.
The Filter Condition items differ depending on the selected asset type.
For details about specifications of the Set Conditions dialog box, see 16.11.2(1) Setting filtering conditions below.
-
Click the Export button.
Export is executed.
- Organization of this subsection
(1) Setting filtering conditions
When output items specified in Export items are to be filtered, such as by the managing group, for example, filtering conditions are set. To filter the conditions, click the link under Filter to display the Set Condition dialog box.
The following figure shows how to specify conditions in the Set Condition dialog box.
|
|
![[Figure]](GRAPHICS/ZU102500.GIF)
The items that can be specified as filtering conditions are displayed in a list. For example, in order to output only the information for a particular group, specify the group name.
The specified conditions become enabled when you click the OK button.
If you click the Close button before you click the OK button, the specified conditions are cleared. Therefore, if you adjust the filter conditions while checking them, you must export them so they are displayed in the dialog box.
(2) Format of output CSV files
The following figure shows the format of a CSV file output by exporting.
|
|
![[Figure]](GRAPHICS/ZU102600.GIF)
If there are multiple pieces of information for the same asset, such as when multiple IP addresses are allocated to one PC, multiple lines are output.
Even if output contents overlap due to the limitation of output items, overlapping lines are not deleted.
Suppose that when you process an output CSV file to edit it to be registered in Asset Console, you use Microsoft Excel to open the CSV file. In such a case, the leading zeros are automatically deleted from numeric values, such as codes and IDs, and the contents of the file might be changed from the original information. Therefore, if you use Microsoft Excel, use the Import Text File function, set the column data format to Text, and then import and edit the file.