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 (ASCII 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. 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 (halfwidth 12 digits). Can specify many. Note For the MAC address at the beginning, specify a value that is different to that of other inventory information that is collected by CSV linkage. |
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 | IPv4: IPv6: Corresponding network card information. Can specify many. Note
|
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. Specify the prefix length of IPv6 addresses. Note
|
43 | Default gateway | "Default gateway,..." | String | Corresponding to network card information. Can specify many. Note
|
44 | DHCP server | "DHCP server" | String | Name of DHCP server. Can specify many. Note
|
45 | DNS server | "DNS server" | String | Name of DNS server. Can specify many. Note
|
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(R) Windows Vista(R) Home Basic | Windows Vista Home Basic |
Microsoft(R) Windows Vista(R) Home Premium | Windows Vista Home Premium |
Microsoft(R) Windows Vista(R) Business | Windows Vista Business |
Microsoft(R) Windows Vista(R) Enterprise | Windows Vista Enterprise |
Microsoft(R) Windows Vista(R) Ultimate | Windows Vista Ultimate |
Microsoft(R) Windows Vista(R) Home Basic 64bit version | Windows Vista Home Basic (x64) |
Microsoft(R) Windows Vista(R) Home Premium 64bit version | Windows Vista Home Premium (x64) |
Microsoft(R) Windows Vista(R) Business 64bit version | Windows Vista Business (x64) |
Microsoft(R) Windows Vista(R) Enterprise 64bit version | Windows Vista Enterprise (x64) |
Microsoft(R) Windows Vista(R) Ultimate 64bit version | Windows Vista Ultimate (x64) |
Windows Server(R) 2008 Standard | Windows Server 2008 Standard |
Windows Server(R) 2008 Standard without Hyper-V | Windows Server 2008 Standard without Hyper-V |
Windows Server(R) 2008 Enterprise | Windows Server 2008 Enterprise |
Windows Server(R) 2008 Enterprise without Hyper-V | Windows Server 2008 Enterprise without Hyper-V |
Windows Server(R) 2008 Datacenter | Windows Server 2008 Datacenter |
Windows Server(R) 2008 Datacenter without Hyper-V | Windows Server 2008 Datacenter without Hyper-V |
Windows(R) Web Server 2008 | Windows Web Server 2008 |
Windows Server(R) 2008 Standard 64bit version | Windows Server 2008 Standard (x64) |
Windows Server(R) 2008 Standard without Hyper-V 64bit version | Windows Server 2008 Standard without Hyper-V (x64) |
Windows Server(R) 2008 Enterprise 64bit version | Windows Server 2008 Enterprise (x64) |
Windows Server(R) 2008 Enterprise without Hyper-V 64bit version | Windows Server 2008 Enterprise without Hyper-V (x64) |
Windows Server(R) 2008 Datacenter 64bit version | Windows Server 2008 Datacenter (x64) |
Windows Server(R) 2008 Datacenter without Hyper-V 64bit version | Windows Server 2008 Datacenter without Hyper-V (x64) |
Windows(R) Web Server 2008 64bit version | Windows Web Server 2008 (x64) |
Windows(R) 7 Starter | Windows 7 Starter |
Windows(R) 7 Home Premium | Windows 7 Home Premium |
Windows(R) 7 Professional | Windows 7 Professional |
Windows(R) 7 Ultimate | Windows 7 Ultimate |
Windows(R) 7 Enterprise | Windows 7 Enterprise |
Windows(R) 7 Home Premium 64bit version | Windows 7 Home Premium (x64) |
Windows(R) 7 Professional 64bit version | Windows 7 Professional (x64) |
Windows(R) 7 Ultimate 64bit version | Windows 7 Ultimate (x64) |
Windows(R) 7 Enterprise 64bit version | Windows 7 Enterprise (x64) |
Windows(R) 8 | Windows 8 |
Windows(R) 8 Pro | Windows 8 Pro |
Windows(R) 8 Enterprise | Windows 8 Enterprise |
Windows(R) 8 64bit version | Windows 8 (x64) |
Windows(R) 8 Pro 64bit version | Windows 8 Pro (x64) |
Windows(R) 8 Enterprise 64bit version | Windows 8 Enterprise (x64) |
Windows(R) 10 Education | Windows 10 Education |
Windows(R) 10 Enterprise LTSB | Windows 10 Enterprise LTSB |
Windows(R) 10 Enterprise | Windows 10 Enterprise |
Windows(R) 10 Home | Windows 10 Home |
Windows(R) 10 Pro | Windows 10 Pro |
Windows(R) 10 Education 64bit version | Windows 10 Education (x64) |
Windows(R) 10 Enterprise LTSB 64bit version | Windows 10 Enterprise LTSB (x64) |
Windows(R) 10 Enterprise 64bit version | Windows 10 Enterprise (x64) |
Windows(R) 10 Home 64bit version | Windows 10 Home (x64) |
Windows(R) 10 Pro 64bit version | Windows 10 Pro (x64) |
Windows Server(R) 2012 Standard | Windows Server 2012 Standard |
Windows Server(R) 2012 Essentials | Windows Server 2012 Essentials |
Windows Server(R) 2012 Foundation | Windows Server 2012 Foundation |
Windows Server(R) 2012 Datacenter | Windows Server 2012 Datacenter |
Windows Server(R) 2016 Datacenter | Windows Server 2016 Datacenter |
Windows Server(R) 2016 Standard | Windows Server 2016 Standard |
Windows Server(R) 2016 Essentials | Windows Server 2016 Essentials |
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 | Program name in Control Panel option Add or Remove Programs or Programs > Programs and Features (depending on the Windows version). |
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, or Apps > Systemwalker Desktop Patrol > Products Link Settings.
Registration to DS
Double-click "iisSettings.exe" in "DTP installation directory\FJSVsbiis\bin".
The window of Products Link Settings will be displayed.
Enter the following information, Click the OK button.
In addition, refer to "14.2.1 Inventory Information Collection with Systemwalker Centric Manager" for other information.
Select Yes or No from the single choice button of Run as service.
When Yes is selected
The Inventory information will be automatically collect according to polling interval.
When No is selected
Use command prompt to execute the following command for the file of Inventory information export. Input the parameter of "CSV".
DTP Installation directory\FJSVsbiis\bin\InvSend.exe CSV |
Select CSV in drop-down list of product.
Enter path of the CSV format file created in the textbox of Inventory information directory (need to specify file name).
For Use the User ID in, set random information in the hardware information and user information of the collected Inventory information.
For Use the PC Name, set random information in the hardware information and user information of the collected Inventory information.
