9.2.3 Executing jamCsvExport.bat
This subsection gives the function, format, options, return value, notes about command execution, and an execution example of jamCsvExport.bat, which executes the export operation equivalent to the Export job menu from the command line.
jamCsvExport.bat is stored in the following folder:
Asset-Console-installation-folder\exe
- Organization of this subsection
(1) Function
This command outputs asset management database information to a CSV file. The CSV file information is output in a batch operation, based on the conditions. For details about how to create conditions, see 16.11.1 Creating export conditions.
When an asset type is specified, information is registered in a batch operation into the asset management database based on the default settings. For details about the items imported based on the default settings, see 20.4 Items to be imported or exported using a job menu.
(2) Format
jamCsvExport.bat "CSV-file-path" " -c conditions-name | -a asset-type "
(3) Options
- CSV-file-path
-
Specifies the CSV file to export, in terms of the file path. This option is mandatory.
- -c conditions-name
-
Specifies the name of the export conditions saved from the Export window.
- -a asset-type
-
The table below lists the codes that indicate the type of asset information to be exported. When this option is specified, all properties of the class set in the Customize Managed Items job menu are output.
Table 9‒24: Asset type codes Code
Meaning
001
Device information
002
Installed software information
003
Installed software list
004
Software information
005
Software list
006
Group information
007
User information
008
Location information
009
Maintenance contract information
010
Rental contract information
011
Lease contract information
012
Volume contract information
013
IP group information
014
Device catalog information
015
User definition (user report)
016
User definition (form)
017
Customize (Acquiring ITDM2 management information)
018
User definition (import/export)
019
Problems
020
Assigned license information
021
Patches
022
Virus definition
023
User definition (Item definition)
024
User definition (contract history)
025
Related asset information
026
Division information
027
Division assignment
(4) Return value
The following table shows the return values.
Return value |
Meaning |
---|---|
0 |
Normal end |
1 |
No data |
2 or more |
Error occurred during processing. |
(5) Notes on command execution
A user with administrator permissions must execute jamCsvExport.bat.
(6) Example
jamCsvExport.bat "c:\temp\Hardware.csv" -a 001