Inventory information can be collected with CSV linkage by creating the CSV format file to record the PC’s Inventory information and registering to Systemwalker Desktop Patrol.
Take the following steps.
Creation of CSV format file
Register to Systemwalker Desktop Patrol
Creation of CSV format file
Format of the CSV format file is based on information of the following CSV format (SJIS code).
Data in unit of line(till new line)
Each item to be indicated with double quotation marks “"”. Software operation status will not be indicated with double quotation marks “"”.
Items are separated from each other by comma “,”.
Leave blank for no data item. (for example: marked as “,” and “,,”)
Due to the above reasons, double quotation marks “"” and comma “,” won’t be used in item data. The data having used those marks won’t be saved.
Item of software operation status won’t be indicated with double quotation marks “”. But if the item data includes comma “,” and double quotation marks “"”, the item will be indicated with double quotation marks “"”. If the item data includes double quotation marks “"”, double quotation marks “"” will be repeatedly marked as ‘"".
Example)
Value of item data | Value recorded in CSV file |
|---|---|
AA,AA | "AA,AA" |
BB"BB | "BB""BB" |
Format of one piece of information in each Inventory information is shown as below. “(mandatory)” item information means mandatory item. The Inventory information without item information is invalid. In addition, the item information of “(lowest limit needed)” is needed for normal operation of the function. Please save virtual information when there is no information to save.
No. | Item | Item data format | Item type | Remarks |
|---|---|---|---|---|
0 | Client key(mandatory) | “Identification name of client” | String | Only key to identify client. |
1 | PC attribution (lowest limit needed) | “Attribution” | String | |
2 | CPU name (lowest limit needed) | “CPU” | String | Name of CPU. |
3 | Memory size(lowest limit needed) | “Memory size” | Number | Unit: KiloByte |
4 | Drive information (lowest limit needed) | “Drive name, drive type, capacity, available capacity,…” | "String, String, Number, Number" | Unit of capacity/available capacity: KiloByte. Fixed character string for drive type (refer to *1). Can specify many. |
5 | Network card information (lowest limit needed) | “Name of network card, MAC address(mandatory),…” | "String, String" | Name of network drive and MAC address of network card (half-width 12 digits). Can specify many. |
6 | Host name(lowest limit needed) | “Full domain name,…” | String | host1 and host1.budgetmgr.com etc. Corresponding network card information. Can specify many. |
7 | IP address (mandatory) | “IP address,…” | String | Address in format of xxx.xxx.xxx.xxx. Corresponding network card information. Can specify many. |
8 | OS name(lowest limit needed) | “OS name” | String | Fixed character string for OS name(refer to *2). |
9 | BIOS version/date | “BIOS version, date” | "String, String" | Name and date of BIOS version. PhoenixBIOS 4.0 Release 6.0,06/02/97 and etc. |
10 | Computer name | “Computer name” | String | Host name without domain. |
11 | Domain name | “Domain name” | String | Suffix of domain. |
12 | Login name | “Login name” | String | Login user. |
13 | CPU Clock Speed | “CPU Clock Speed” | Number | CPU Clock Speed. Unit: MegaHertz |
14 | Number of actual installation | “Number of actual installation” | Number | Number of actually installed CPU. Unit: Numeral. |
15 | Detailed information of CPU | “Detailed information of CPU” | String | Detailed information of CPU. |
16 | Size of swap file | “Size of swap file” | Number | Unit: KiloByte |
17 | Name of keyboard type | “Keyboard type” | String | Type of keyboard. |
18 | Installation Language | “Language” | String | Type of language. |
19 | Name of mouse type | “Mouse type” | String | Type of mouse. |
20 | Number of mouse buttons | “Number of mouse buttons” | Number | Number of mouse buttons. Unit: Numeral |
21 | Manufacturer Name | “Manufacturer Name” | String | Manufacturing place of PC. |
22 | PC model | “PC model” | String | PC model(type) |
23 | PC serial | “PC serial” | String | PC serial number(PCID) |
24 | Session level cache, second level cache | “Session level cache, second level cache” | "Number, Number" | Size of Session level cache and second level cache. Unit: KiloByte |
25 | OS buliding number | “OS building number” | String | Construction number of Windows OS. |
26 | service pack | “service pack” | String | Number of service pack. |
27 | DOS version | “DOS version” | String | DOS Version. |
28 | User name | “User name” | String | Name of installed user of Windows OS. |
29 | Company name | “Company name” | String | Company name of installed user. |
30 | OS product ID | “OS product ID” | String | Product ID of Windows OS. |
31 | Windows directory name | “Windows directory” | String | Windows installation directory. |
32 | Name of system directory | “System directory” | String | Windows system directory. |
33 | Image resolution | “Width, height” | "Number, Number" | Monitor resolution. |
34 | Video adapter | “Video adapter” | String | Name of video adapter. |
35 | Size of video memory | “Size of video memory” | Number | Memory size of video adapter card Unit: KiloByte |
36 | Pixel | “Pixel” | Number | Display pixel. Unit: Numeral. |
37 | Monitor name | “Monitor name” | String | Name of monitor. |
38 | Name of Screen Saver | “Name of Screen Saver” | String | Name of screen capture tool. |
39 | Window update rate | “Window update rate” | Number | Cycle number of monitor. Unit: Hertz |
40 | Label | “Label,…” | String | Corresponding to drive information. Can specify many. |
41 | Type of file system | “Type of file system,…” | String | Corresponding to drive information. Can specify many. |
42 | Subnet mask | “Subnet mask,…” | String | Corresponding to network card information Can specify many. |
43 | Default gateway | “Default gateway,…” | String | Corresponding to network card information. Can specify many. |
44 | DHCP server | “DHCP server” | String | Name of DHCP server. |
45 | DNS server | “DNS server” | String | Name of DNS server. |
46 | Printer name | “Printer name,…” | String | Printer information: name of printer. Can specify many. |
47 | Printer type | “Printer type,…” | String | Printer information: type of printer. Corresponding to printer name. Can specify many. |
48 | CD-ROM device name | “CD-ROM device name” | String | Name of CD-ROM device. |
49 | Network path | “Network path,…” | String | Shared information: name of network patch. Corresponding to drive information. Can specify many. |
50 | Name of network provider | “Name of network provider,…” | String | Shared information: name of network provider. Corresponding to drive information. Can specify many. |
51 | Drive name | “Drive name,…” | String | Shared information: name of network drive. Corresponding to drive information. Can specify many. |
52 | Memory device locator | “Memory device locator,…” | String | Memory information: name of memory device locator. Can specify many. |
53 | Memory size | “Memory size,…” | Number | Memory information: Memory size of memory device localizer. Unit: KiloByte Corresponding to memory device localizer. Can specify many. |
54 | Name of disk vendor | “Name of disk vendor” | String | Disk information: manufacturer of hard disk. |
55 | Name of disk type | “Name of disk type” | String | Disk information: type of hard disk (type). |
56 | Disk capacity | “Disk capacity” | Number | Disk information: hard disk capacity. Unit: KiloByte |
57 | Disk IF | “Disk IF” | String | Disk information: I/F specification of hard disk. |
58 | Disk description | “Disk description” | String | Disk information: explanation about hard disk. |
Drive type | Value of drive type |
|---|---|
Floppy disk | Floppy disk |
Hard disk | Hard disk drive |
CD-ROM | CD-ROM drive |
RAM | RAM drive |
Removable | Removable drive |
Network | Network drive |
Unknown | Unknown |
OS | Value of OS name |
|---|---|
Microsoft® Windows® XP Home Edition | Windows XP Home Edition |
Microsoft® Windows® XP Professional | Windows XP Professional |
Microsoft® Windows Server® 2003, Standard Edition | Windows Server 2003 Standard Edition |
Microsoft® Windows Server® 2003, Enterprise Edition | Windows Server 2003 Enterprise Edition |
Microsoft® Windows Server® 2003, Web Edition | Windows Server 2003 Web Edition |
Microsoft® Windows Server® 2003 Standard x64 Edition | Windows Server 2003 Standard x64 Edition |
Microsoft® Windows Server® 2003 Enterprise x64 Edition | Windows Server 2003 Enterprise x64 Edition |
Microsoft® Windows Vista® Home Basic | Windows Vista Home Basic |
Microsoft® Windows Vista® Home Premium | Windows Vista Home Premium |
Microsoft® Windows Vista® Business | Windows Vista Business |
Microsoft® Windows Vista® Enterprise | Windows Vista Enterprise |
Microsoft® Windows Vista® Ultimate | Windows Vista Ultimate |
Microsoft® Windows Vista® Home Basic 64bit version | Windows Vista Home Basic (x64) |
Microsoft® Windows Vista® Home Premium 64bit version | Windows Vista Home Premium (x64) |
Microsoft® Windows Vista® Business 64bit version | Windows Vista Business (x64) |
Microsoft® Windows Vista® Enterprise 64bit version | Windows Vista Enterprise (x64) |
Microsoft® Windows Vista® Ultimate 64bit version | Windows Vista Ultimate (x64) |
Windows Server® 2008 Standard | Windows Server 2008 Standard |
Windows Server® 2008 Standard without Hyper-V | Windows Server 2008 Standard without Hyper-V |
Windows Server® 2008 Enterprise | Windows Server 2008 Enterprise |
Windows Server® 2008 Enterprise without Hyper-V | Windows Server 2008 Enterprise without Hyper-V |
Windows Server® 2008 Datacenter | Windows Server 2008 Datacenter |
Windows Server® 2008 Datacenter without Hyper-V | Windows Server 2008 Datacenter without Hyper-V |
Windows® Web Server 2008 | Windows Web Server 2008 |
Windows Server® 2008 Standard 64bit version | Windows Server 2008 Standard (x64) |
Windows Server® 2008 Standard without Hyper-V 64bit version | Windows Server 2008 Standard without Hyper-V (x64) |
Windows Server® 2008 Enterprise 64bit version | Windows Server 2008 Enterprise (x64) |
Windows Server® 2008 Enterprise without Hyper-V 64bit version | Windows Server 2008 Enterprise without Hyper-V (x64) |
Windows Server® 2008 Datacenter 64bit version | Windows Server 2008 Datacenter (x64) |
Windows Server® 2008 Datacenter without Hyper-V 64bit version | Windows Server 2008 Datacenter without Hyper-V (x64) |
Windows® Web Server 2008 64bit version | Windows Web Server 2008 (x64) |
All software units compose 1 piece of information.
No. | Item | Item data format | Item type | Remarks |
|---|---|---|---|---|
0 | Client key (required) | “Identification name of client” | String | Only key to identify client. |
1 | File name (lowest limit required) | “File name” | String | File name and directory name to be searched. |
2 | File size | “File size” | Number | Unit: Byte |
3 | Update date | “YYYYMMDDhhmm” | Number | Date of file update (YYYYMMDDhhmm) Half-with 12bit. |
4 | Program name | “Dictionary code” | String | Software code of software dictionary. Data saved only when in use. |
All software units compose 1 piece of information.
No. | Item | Item data format | Item type | Remarks |
|---|---|---|---|---|
0 | Client key (required) | “Identification name of client” | String | Only key to identify client. |
1 | Procedure name(lowest limit required) | “Program name” | String | Name of procedure of software existing in “Addition and cancellation of procedure”. |
No. | Item | Item data format | Item type | Remarks |
|---|---|---|---|---|
0 | Client key (required) | “Identification name of client” | String | Only key to identify client. |
1 | Search key (lowest limit required) | “Registry key” | String | Key of retrieval object. |
2 | Name of search key | “Name of registry key” | String | Name of key of retrieval object. |
3 | Value of search key name | “Value of name of registry key” | String | Value of name of retrieval object key. |
All client units compose 1 piece of information. Any information in 1-10 can be stored in user information.
No. | Item | Item data format | Item type | Remarks |
|---|---|---|---|---|
0 | Client key (required) | “Identification name of client” | String | Only key to identify client. |
1 | User information 1 | “Item name, content (value)” | "String, String" | Item name, any content. |
2 | User information 2 | “Item name, content (value)” | "String, String" | Same as above |
3 | User information 3 | “Item name, content (value)” | "String, String" | Same as above |
4 | User information 4 | “Item name, content (value)” | "String, String" | Same as above |
5 | User information 5 | “Item name, content (value)” | "String, String" | Same as above |
6 | User information 6 | “Item name, content (value)” | "String, String" | Same as above |
7 | User information 7 | “Item name, content (value)” | "String, String" | Same as above |
8 | User information 8 | “Item name, content (value)” | "String, String" | Same as above |
9 | User information 9 | “Item name, content (value)” | "String, String" | Same as above |
10 | User information 10 | “Item name, content (value)” | "String, String" | Same as above |
All client units compose 1 piece of information.
No. | Item | Item data format | Item type | Remarks |
|---|---|---|---|---|
0 | Client key(mandatory) | “Identification name of client” | String | Only key to identify client. |
1 | Name of operating file(lowest limit needed) | File name | String | File name of procedure operation. |
2 | ”Reserved area” | - | - | Set null(same as “,,”) |
3 | ”Reserved area” | - | - | Set null(same as “,,”) |
4 | Date of startup(lowest limit needed) | YYYY/MM/DD | Date and Time | Date of procedure startup. |
5 | ”Reserved area” | - | - | Set null(same as “,,”) |
6 | ”Reserved area” | - | - | Set null(same as “,,”) |
7 | ”Reserved area” | - | - | Set null(same as “,,”) |
8 | ”Reserved area” | - | - | Set null(same as “,,”) |
9 | Number of startups(lowest limit needed) | n | Number | Number of procedure startup times. |
10 | ”Reserved area” | - | - | Set null(same as “,,”) |
11 | ”Reserved area” | - | - | Set null(same as “,,”) |
12 | ”Reserved area” | - | - | Set null(same as “,,”) |
13 | ”Reserved area” | - | - | Set null(same as “,,”) |
14 | ”Reserved area” | - | - | Set null(same as “,,”) |
15 | ”Reserved area” | - | - | Set null(same as “,,”) |
16 | ”Reserved area” | - | - | Set null(same as “,,”) |
17 | ”Reserved area” | - | - | Set null(same as “,,”) |
18 | ”Reserved area” | - | - | Set null(same as “,,”) |
19 | ”Reserved area” | - | - | Set null(same as “,,”) |
20 | ”Reserved area” | - | - | Set null(same as “,,”) |
21 | ”Reserved area” | - | - | Set null(same as “,,”) |
22 | ”Reserved area” | - | - | Set null(same as “,,”) |
23 | ”Reserved area” | - | - | Set null(same as “,,”) |
Example)
10001+USER01+PC1,LPLS153.EXE,,,2007/04/01,,,,,1,,,,,,,,,,,,,, 10002+USER02+PC2,LPLS153.EXE,,,2007/04/02,,,,,2,,,,,,,,,,,,,, 10003+USER03+PC3,LPLS153.EXE,,,2007/03/01,,,,,1,,,,,,,,,,,,,, |
Registration to Systemwalker Desktop Patrol
Register the created CSV format file to Systemwalker Desktop Patrol.
Take the following steps.
Set up the file of Inventory information registration.
Registration to CS
Select “Start” - “Procedure” - “Systemwalker Desktop Patrol” - “Environment Setup” - “Link with Other Products - Environment Setup”.
Registration to DS
Double-click “iisSettings.exe” in “DTP installation directory” - “FJSVsbiis” - “bin”.
→The window of “Linkage with other products-environment setup” will be displayed.
Enter the following information, Click the “OK” button.
In addition, refer to “12.2.1 Inventory Information Collection with Systemwalker Centric Manager” for other information.
Select “Yes” or “No” from the single choice button of “Initiation as resident process”.
→When “Yes” is selected
The Inventory information will be automatically collect according to polling interval. But the process will stop on logout. Restart of “ITBudgetMGR (INV)” service is needed after settings change and logout.
→When “No” is selected
Use command prompt to execute the following command for the file of Inventory information export. Please input the parameter of “CSV”.
DTP Installation directory\FJSVsbiis\bin\InvSend.exe CSV |
Select “CSV” in drop-down list of “Linkage product”.
Enter path of the CSV format file created in the textbox of “Inventory information storage path”(need to specify file name).
For “Specified user ID”, set random information in the hardware information and user information of the collected Inventory information.
For “Specified PC name”, set random information in the hardware information and user information of the collected Inventory information.
