Systemwalker Desktop Patrol Reference Manual

2.2.1 Inventory Information File

The file layout of "Inventory information files" is shown as follows:

File format

• The first line: Download date and time, selected section, section code (Note 1)

• The second line: Item names (Note 2)

  PC Name,User ID,User Name,Section Code,Section Name,OS Name,Full Computer Name,IP Address,MAC Address,Memory Size,Disk Capacity,Free Disk Capacity,Software Dictionary Date/Time,Update Date/Time,Building Name,PC Properties,BIOS Version,Computer Name,Domain Name,CPU Name,CPU Clock Speed,Number of CPU,CPU Details,Swap File Size,Name of Keyboard Type,Installing Language,Mouse Type Name,Mouse Button Number,Manufacturer Name,Model Name,Serial Number,Primary Cache,Secondary Cache,Drive Information (Drive Name, Drive Type, Drive Capacity, Drive Free Capacity, Volume, File System Information),Network Card Information (Network Card, MAC Address),TCP/IP Information (Host Name, IP Address, Subnet Mask, Default Gateway),DNS Server,DHCP Server,OS,OS Build Number,Service Pack,DOS Version,OS User Name,OS OU Name,Product ID of OS,Windows Directory,Windows System Directory,Screen Resolution,Video Adaptor,Video Memory Size,Resolution,Monitor,Screen Saver Name,Screen Refresh Rate,Memory Information (Device Locator, Size),Printer Information (Printer Name, Printer Type),Disk Information (Manufacturer Name, Model Name, Disk Capacity, Disk IF, Description),Login Name,Connected Server Name,Software Dictionary Icon,Virtual PC,Action [Message Sending],Action [Inventory Collection],Action [Security Patch Installation],Action [Security Settings Modification],Action [Power Saving Settings Modification],,,item names of user information (item exists for a few minutes)

• The third line: Basic information on the PC (Note 2)

  • 1st column: PC name

  • 2nd column: User ID

  • 3rd column: User name

  • 4th column: Section code

  • 5th column: Section name

  • 6th column: OS name

  • 7th column: Full computer name

  • 8th column: IP address (Note 3)(Note 4)

  • 9th column: MAC address

  • 10th column: Memory (MB)

  • 11th column: Disk size (MB)

  • 12th column: Available disk space (MB)

  • 13th column: Software dictionary version

  • 14th column: Update date/time

  • 15th column: Building name

  • 16th column: PC property

  • 17th column: BIOS version

  • 18th column: Computer name

  • 19th column: Domain name

  • 20th column: CPU name

  • 21st column: Clock rate (MHz)

  • 22nd column: CPU clock speed

  • 23rd column: CPU details

  • 24th column: Swap file size (KB)

  • 25th column: Keyboard type name

  • 26th column: Installation language

  • 27th column: Mouse type name

  • 28th column: Number of Mouse buttons

  • 29th column: PC manufacturer name

  • 30th column: PC model

  • 31st column: PC serial number

  • 32nd column: L1 cache size (KB)

  • 33rd column: L2 cache size (KB)

  • 34th column: Drive information (drive name, drive type, capacity, available capacity, volume number, file system identification)

  • 35th column: Network card information (network card, MAC address)

  • 36th column: TCP/IP information (host name, IP address, subnet mask, default gateway) (Note 3)

  • 37th column: DNS server (Note 3)

  • 38th column: DHCP server (Note 3)

  • 39th column: OS

  • 40th column: OS building number

  • 41st column: Service Pack

  • 42nd column: DOS version

  • 43rd column: User name

  • 44th column: Company name

  • 45th column: OS product ID

  • 46th column: Windows directory name

  • 47th column: System directory name

  • 48th column: Resolution

  • 49th column: Video adapter

  • 50th column: Image storage size (KB)

  • 51st column: Pixel

  • 52nd column: Monitor name

  • 53rd column: Screen saver name

  • 54th column: Refresh rate (Hz)

  • 55th column: Memory information (device locater, size)

  • 56th column: Printer information (printer name, printer type)

  • 57th column: Disk information (manufacturer name, model name, disk space (KB), disk IF, description)

  • 58th column: logon name

  • 59th column: Connected Server Name (Note 5)

  • 60th column: Software Dictionary Icon (Note 6)

  • 61st column: virtual PC (Note 7)

  • 62nd column: Action [Message Sending] (Note 8)

  • 63rd column: Action [Inventory Collection] (Note 8)

  • 64th column: Action [Security Patch Installation] (Note 8)

  • 65th column: Action [Security Settings Modification] (Note 8)

  • 66th column: Action [Power Saving Settings Modification] (Note 8)

  • 67th column: reserved area

  • 68th column: reserved area

  • 69th column and on: item names of user information (item exists for a few minutes)

Note 1)

When selecting "Management Target" in section, since there is no section code, the column corresponding to the section code is "".

Note 2)

When outputting CSV with the following operation, the output Item is the same as PC information > Inventory information window of main menu.

• When downloading from PC information > Inventory information window of main menu

• Or when /w option is specified in dtpinvdl.exe (export Inventory information)

Note 3)

IP addresses are expressed as follows:

• To display both IPv4 andIPv6 addresses in dual stack environments, separate them with a forward slash (/).

• IPv6 addresses are separated with a semicolon (;).

• Temporary addresses are prefixed with a number sign (#). However, this applies only to inventory information collected by CT.

Note 4)

IP addresses are output according to the display priority specified in Option > Display settings.

Note 5)

• In V13.2 or earlier of CT, the Connected Server Name is "".

• When an IPv6 address is specified for the connection destination server name of CT.

Note 6)

The flags 1, 2 and 3 below are used for displaying the software dictionary icon. Refer to the icon description on the screen for the meaning of the icon.

1:green icon

2:yellow icon

3:red icon

Note 7)

Change to o under virtual PC conditions.

Note 8)

Output in the format of "Status, process indicated date and time, error content".

Status is shown as below:

1: abnormal icon

2: alarm icon

3: icon under processing

4: normal icon

File output example

"04/01/2016 10:00:00","Section A","10001"

"PC Name","User ID","User Name","Section Code","Section Name","OS Name","Full Computer Name","IP Address","MAC Address","Memory Size","Disk Capacity","Free Disk Capacity","Software Dictionary Date/Time","Update Date/Time","Building Name","PC Properties","BIOS Version","Computer Name","DomainName","CPU Name","CPU Clock Speed","Number of CPU","CPU Details","Swap File Size","Name of KeyboardType","Installing Language","Mouse Type Name","Mouse Button Number","Manufacturer Name","Model Name","Serial Number","Primary Cache","Secondary Cache","Drive Information (Drive Name, Drive Type, Drive Capacity, Drive Free Capacity, Volume, File System Information)","Network Card Information (Network Card, MAC Address)","TCP/IP Information (Host Name, IP Address, Subnet Mask, Default Gateway)","DNS Server","DHCP Server","OS","OS Build Number","Service Pack","DOS Version","OS User Name","OS OU Name","Product ID of OS","Windows Directory","Windows System Directory","Screen Resolution","Video Adaptor","Video Memory Size","Resolution","Monitor","Screen Saver Name","Screen Refresh Rate","Memory Information (Device Locator, Size)","Printer Information (Printer Name, Printer Type)","Disk Information (Manufacturer Name, Model Name, Disk Capacity, Disk IF, Description)","Login Name","Connected Server Name","Software Dictionary Icon","Virtual PC","Action [Message Sending]","Action [Inventory Collection]","Action [Security Patch Installation]","Action [Security Settings Modification]","Action [Power Saving Settings Modification]","","","Property ID","Serial Number","Operation Status","Use","Building","Manufacturer","Purchase Order Number","Order Date","Equipment ID","Remarks".

"PC1","11111"," Employee A","10001","Job A","Windows 8.1","PC1","xx.xx.xx.xx","xx:xx:xx:xx:xx:xx","1526","18724","380","03/31/2016 17:00:00","04/01/2016 08:40:00","Other establishment","COMPATIBLE","Default System BIOS,xx/xx/xx","PC1","DOMAINA","Intel(R) Pentium(R) M processor 1.20GHz","1200","1","Family6 Model13 Stepping8","2611252","Japanese PS/2 keyboard (106/109 key Ctrl+alphanumeric)","Japanese","PS/2 exchange mouse","2","FUJITSU","FMV","xxxxx","64","2048","C:,Hard disk drive,19174396,389648,,NTFS","Broadcom 440x 10/100 Integrated Controller,xx:xx:xx:xx:xx:xx","PCA,xx.xx.xx.xx,255.255.255.0,xx.xx.xx.xx","xx.xx.xx.xx;xx.xx.xx.xx","xx.xx.xx.xx","Windows 8.1","9600","","5.0","ABC","","xxxxx-xxxxx-xxxxx-xxxxx","C:\WINDOWS","C:\WINDOWS\system32","1024X768","N/A,Winvnc video hook driver","","4294967296","ABC","","60","DDRII 1,524288,DDRII 2,1048576","Fax,local printer","(standard disk drive),ATA Device,19535040,IDE, disk drive","user1","CS1","1","","","","","","","","","","","","","","","","","",""