Job Management Partner 1/Software Distribution Description and Planning Guide
This table stores system information for each client. Each record contains detailed system information for one client (such as CPU type and free hard disk space).
Column name | Oracle | Microsoft SQL Server | Embedded RDB | Description | Key No. | |||
---|---|---|---|---|---|---|---|---|
Data type | Size | Data type | Size | Data type | Size | |||
dm_nodename | VARCHAR2 | 64 | varchar | 64 | MVARCHAR | 64 | Host name of the client | 1 |
dm_sysinfname | RAW | 2 | binary | 1 | SMALLINT | -- | Type of system information | 2 |
dm_exkind | CHAR | 1 | char | 1 | VARCHAR | 1 | Extension type of system information | 3 |
dm_systeminf | VARCHAR2 | 200 | varchar | 200 | MVARCHAR | 200 | Value of system information | -- |
dm_subinf | VARCHAR2 | 200 | varchar | 200 | MVARCHAR | 200 | Subordinate information for system information | -- |
The following table shows the values of the individual columns for each system information item:
System information | dm_sysinfname | dm_exkind | dm_systeminf |
---|---|---|---|
CPU type | 0x01 |
|
See CPU type below. |
Existence of coprocessor | 0x02 | 0x00 |
|
Installed RAM | 0x03 | 0x00 | Decimal value in megabytes |
Workstation type (applicable to UNIX only) | 0x04 | 0x00 | UNIX machine type |
CPU clock speed | 0x05 | 0x00 | CPU clock speed in MHz |
Machine information | 0x06 | 0x01: Manufacturer | PC manufacturer |
0x02: Model | PC model | ||
Number of processors | 0x07 | 0x00 | Number of processors |
WMI | 0x08 | 0x00 | Character string indicating the WMI version (if unavailable, N/A) |
Clock speed of the external CPU | 0x09 | 0x01 | Clock speed of the external CPU in MHz |
OS | 0x10 |
|
See OS below. |
OS version | 0x12 |
|
vvrr
|
OS build number/OS patch | 0x13 | 0x00 |
|
OS license (applicable to UNIX only) | 0x14 | 0x00 |
|
UNIX OS version | 0x15 | 0x39 | UNIX OS version |
Owner | 0x16 | 0x00 | Owner name |
Company name | 0x17 | 0x00 | Company name |
OS sub-version | 0x18 | 0x00 | OS type + OS, as a character string Example of adding a service pack to the version: Windows NT4.0 (Service Pack 1) |
Computer name | 0x19 | 0x00 | Computer name |
OS information | 0x1A | 0x00: Name of OS family | OS type in characters::
|
0x01: Domain type | Domain type in code:
|
||
0x02: Detailed OS type | When the OS is not any of those listed below, the OS type code value that is set by entry type 0x10 is set as 5-byte character string expressed in decimal format.
|
||
0x03: Computer description | Description of the computer expressed as a character string | ||
0x04: Domain/Workgroup | Domain/work group expressed as a character string | ||
0x05: Logon user name | Logon user name expressed as a character string | ||
0x06: Full name of user | Full name of user expressed as a character string | ||
0x07: User description | Description of user expressed as a character string | ||
0x08: Current time zone | Time zone expressed as a numeric value | ||
0x09: Machine UUID | Machine UUID expressed as a character string | ||
0x0A: Machine serial number | Machine serial number expressed as a character string | ||
0x0B: Boot device | Startup device expressed as a character string | ||
0x0D: OS installation date/time | Installation date expressed as a character string | ||
0x0E: Last startup date/time | Last startup date/time expressed as a character string | ||
0x10: Locale | Locale expressed in UINT | ||
0x11: OS language | OS language expressed in UINT | ||
0x12: Windows directory | Windows directory expressed as a character string | ||
0x13: System directory | System directory expressed as a character string | ||
0x14: OS serial number | OS serial number expressed as a character string | ||
0x15: Internet Explorer version | Internet Explorer version expressed as a character string | ||
0x16: Windows Installer | Windows Installer version expressed as a character string (if it has not been installed, N/A is set) | ||
0x17: MBSA | Product version of the MBSA command line interface stored in client-installation-directory\CLIENT\MBSA (mbsacli.exe file) expressed as a character string If no value is stored, the following character string is set:
|
||
0x18: Windows Update Agent | WUA version expressed as a character string (if WUA is not installed, "N/A" is set) | ||
0x19: WSUS computer ID | WSUS computer ID expressed as a character string | ||
IE Patch | 0x1B |
|
IE patch information expressed as a character string. (If there is no registry or the value is blank, character string N/A is set in 0x01 and 0x02.) |
Client version | 0x21 |
|
vvrrss
|
Drives | 0x2F | Drives A-Z | Drive type expressed as one of the following character strings:
|
Free space | 0x31 | Drives A-Z For UNIX V5 or earlier:
|
Decimal value in megabytes |
Usable user memory size | 0x32 | 0x00 | Decimal value in megabytes |
Usable system resource size | 0x33 | 0x00 | Decimal number in kilobytes |
Name of UNIX special file | 0x34 | Corresponds to extended information 0x01 to 0x400x31 | Name of special file |
UNIX mount path name | 0x35 | Corresponds to extended information 0x01 to 0x400x31 | Name of special file |
Memory size | 0x36 | 0x00: Available physical memory | Available physical memory in megabytes |
0x01: Available virtual memory | Available virtual memory in megabytes | ||
0x02: Total capacity of virtual memory | Total capacity of virtual memory in megabytes | ||
0x03: Size of page file | Size of page file in megabytes | ||
Memory slot capacity | 0x37 |
|
Memory slot capacity in megabytes |
Bus type | 0x40 | 0x00: Type of primary bus | Primary bus expressed as a character string |
0x01: Type of secondary bus | Secondary bus expressed as a character string | ||
BIOS | 0x41 | 0x00:BIOS manufacturer | BIOS manufacturer expressed as a character string |
0x01: BIOS release date/time | BIOS release date/time expressed as a character string | ||
0x02: BIOS version | BIOS version expressed as a character string | ||
0x03: BIOS version (SMBIOS) | BIOS version of SMBIOS expressed as a character string | ||
0x04: AMT firmware version | AMT firmware version expressed as a character string | ||
Keyboard | 0x42 |
|
Keyboard expressed as a character string |
Mouse | 0x43 |
|
Mouse expressed as a character string |
Number of mouse buttons | 0x44 |
|
Number of mouse buttons expressed in UCHAR |
Partition size | 0x51 | Drives A-Z | Decimal value in megabytes |
File system | 0x52 | Drives A-Z For UNIX, partition number (0x01-0x2F) |
File system expressed as a character string |
Hard disk interface | 0x53 |
|
Hard disk interface expressed as a character string |
Number of hard disk partitions | 0x54 |
|
Number of hard disk partitions expressed in UINT |
Hard disk capacity | 0x55 |
|
Hard disk capacity in megabytes |
Model of hard disk | 0x56 |
|
Model of hard disk expressed as a character string |
CD-ROM drive | 0x57 |
|
Name of CD-ROM drive expressed as a character string |
BitLocker-based encryption information | 0x58 | Drives A-Z | BitLocker setting information
|
HIBUN FDE-based encryption information | 0x5A | Drives A-Z | HIBUN FDE setting information
|
Video driver | 0x61 | 0x00 | Video driver name |
Video chip | 0x62 | 0x00 | Video chip name |
VRAM | 0x63 | 0x00 | Decimal value in megabytes |
Display | 0x64 | 0x00 | xx yy cc colors:
|
Monitor type | 0x65 |
|
Monitor type expressed as a character string |
Sound card manufacturer | 0x66 |
|
Sound card manufacturer expressed as a character string |
Product name of sound card | 0x67 |
|
Product name of sound card expressed as a character string |
MAC address | 0x81 |
|
MAC address expressed in hexadecimal characters |
Network adapter | 0x82 |
|
Network adapter |
Default router address | 0x83 |
|
Default router address expressed as a character string |
Subnet mask | 0x84 |
|
Subnet mask expressed as a character string |
IP address | 0x85 |
|
IP address expressed as a character string. If there are multiple IP addresses, all addresses are linked together using a single space as the delimiter. |
Primary DNS server address | 0x86 |
|
Primary DNS server address expressed as a character string |
Secondary DNS server address | 0x87 |
|
Secondary DNS server address expressed as a character string |
DHCP | 0x88 |
|
Whether DHCP is enabled or disabled:
|
DHCP server address | 0x89 |
|
DHCP server address expressed as a character string |
Expiration date/time of DHCP lease | 0x8A |
|
Expiration date/time of DHCP lease expressed as a character string |
Acquired date/time of DHCP lease | 0x8B |
|
Acquired date/time of DHCP lease expressed as a character string |
WINS server address | 0x8C |
|
WINS server address expressed as a character string. If there are multiple WINS server addresses, all addresses are linked together using a single space as the delimiter. |
Printer name | 0x90 |
|
Printer name expressed as a character string |
Shared name of printer | 0x91 |
|
Shared name of printer expressed as a character string |
Printer server name | 0x92 |
|
Printer server name expressed as a character string |
Printer sheet size | 0x93 |
|
Printer sheet size expressed as a character string |
Printer driver | 0x94 |
|
Printer driver expressed as a character string |
Printer port | 0x95 |
|
Printer port expressed as a character string |
Printer type | 0x96 |
|
Printer type expressed as a character string |
Security-related | 0xA0 | 0x01: Guest account | Guest account enabling status:
|
0x02: Weak password | Account in which a weak password is set, as a character string. If no weak password exists, the following character string is set:
|
||
0x03: Time-unlimited password | Account in which a time-unlimited password is set, as a character string. If no time-unlimited password exists, the following character string is set:
|
||
0x04: Automatic logon setting | Automatic logon setting:
|
||
0x05: Shared folders | Shared folder availability:
|
||
0x06: Restriction on anonymous connections | Restriction on anonymous connections:
|
||
0x07: Screensaver | Screensaver setting:
|
||
0x08: Password protection for screensaver | Screensaver password protection function setting:
|
||
0x09: Power-on password | Power-on password setting:
|
||
0x0A: Windows Firewall settings | Windows Firewall settings:
|
||
0x0B: Windows automatic updates | Windows automatic updates setting:
|
||
0x0C: Unnecessary services | Whether unnecessary services are running:
|
||
0xA1 | Local account names
|
Local account names | |
0xA2 | Days since the Windows password was last updated
|
Days since the Windows password was last updated | |
Distribution | 0xA3 | 0x00 | Linux distribution name |
Security-related | 0xA5 | 0x01: Turn off monitor (AC) | Time to turn off monitor (AC) (seconds) as a character string:
|
0x02: Turn off monitor (DC) | Time to turn off monitor (DC) (seconds) as a character string:
|
||
0x03: Processor Throttle (AC) | Processor power management status (processor throttle (AC)) as a character string:
|
||
0x04: Processor Throttle (DC) | Processor power management status (processor throttle (DC)) as a character string:
|
||
0x05: Turn off hard disks (AC) | Time to turn off hard disks (AC) (seconds) set as a character string:
|
||
0x06: Turn off hard disks (DC) | Time to turn off hard disks (DC) (seconds) set as a character string:
|
||
0x07: System standby/Sleep (AC) | Time until the computer enters system standby or sleep mode (AC) (seconds) set as a character string:
|
||
0x08: System standby/Sleep (DC) | Time until the computer enters system standby or sleep mode (DC) (seconds) set as a character string:
|
||
0x09: System hibernates (AC) | Time until the computer enters hibernation mode (AC) (seconds) set as a character string:
|
||
0x0A: System hibernates (DC) | Time until the computer enters hibernation mode (DC) (seconds) set as a character string:
|
Code | Description | Code | Description |
---|---|---|---|
646 | Intel 80286 | 902 | Intel 80386 |
1158 | Intel 80486 | 1414 | Intel Pentium series or compatible CPU |
4097 | Alpha | 8193 | MIPS R2000 system |
12289 | PowerPC | 20481 | PA-RISC |
24577 | SPARC | 28672 | Intel Pentium series |
28673 | Intel Pentium | 28674 | Intel Pentium MMX |
28675 | Intel Pentium Pro | 28676 | Intel Pentium II |
28677 | Intel Pentium II Xeon | 28678 | Intel Pentium III |
28679 | Intel Pentium III Xeon | 28680 | Intel Celeron |
28681 | Intel Pentium 4 | 28682 | Pentium III-S |
28683 | Mobile Intel Celeron | 28684 | Mobile Intel Pentium 4 |
28685 | Intel Xeon | 28686 | Intel Xeon MP |
28687 | Mobile Intel Pentium III-M | 28688 | Intel Genuine |
28689 | Mobile Genuine Intel | 28690 | Intel Celeron M |
28691 | Intel Pentium M | 28692 | Intel Pentium D |
28693 | Intel Celeron D | 28694 | Intel Core2 |
28695 | Intel Core | 28696 | Intel Core i7 |
28697 | Intel Atom | 28698 | Intel Pentium Dual |
28699 | Intel Core i3 | 28700 | Intel Core i5 |
32768 | Intel Pentium-compatible CPU | 33025 | AMD K6 |
33026 | AMD K6-2 | 33027 | AMD K6-2 3D Now! |
33028 | AMD K6-III | 33029 | AMD Athlon |
33030 | AMD Duron | 33031 | AMD Athlon MP |
33032 | AMD Athlon XP | 33033 | Mobile AMD Athlon 4 |
33034 | Mobile AMD Duron | 33035 | AMD Duron MP |
33036 | Mobile AMD Athlon XP-M | 33037 | AMD Sempron |
33038 | Mobile AMD Sempron | 33039 | AMD Turion |
33281 | Cyrix MediaGX | 33282 | Cyrix MII |
33283 | Cyrix MediaGXm | 33537 | IDT WinChip |
33793 | RISE mP6 | 34049 | Transmeta Crusoe Processor TM5600 |
36864 | CPU for Windows CE | 37120 | CPU for Windows CE (Hitachi) |
37377 | MIPS R3000 system | 37378 | MIPS R4000 system |
37633 | ARM720 | 40960 | Intel IPF CPU |
40961 | Intel Itanium | 40962 | Intel Itanium 2 |
45056 | AMD64-compatible CPU | 45057 | AMDOpteron |
45058 | AMD Athlon 64 | 45059 | AMD Athlon 64 FX |
45060 | Mobile AMD Athlon 64 | 45061 | AMD Athlon 64 X2 |
45062 | AMD Turion 64 | 45063 | AMD Athlon II |
45064 | AMD Turion II | 45065 | AMD Phenom |
45066 | AMD Phenom II | 45067 | AMD V Series |
45068 | AMD FX | 45069 | AMD A Series |
45070 | AMD C Series | 45071 | AMD E Series |
45311 | AMD | -- | -- |
Code | Description | Code | Description |
---|---|---|---|
1 | MS-DOS+Windows | 2 | Windows NT |
3 | OS/2 | 4 | Windows 95 |
5 | SCO ODT | 6 | Solaris PC |
7 | NEXTSTEP | 8 | Windows 98 |
9 | Windows 2000 | 11 | Windows Me |
12 | Windows XP | 14 | Windows Server 2003 |
15 | Windows Vista | 16 | Windows Server 2008 |
17 | Windows 7 | 18 | Windows Server 2008 R2 |
19 | Windows 8 | 20 | Windows Server 2012 |
131 | HP-UX | 132 | Solaris |
134 | HP Tru64 UNIX | 135 | AIX |
137 | NEWS-OS | 144 | UX/4800 |
145 | Linux | 146 | MP-RAS |
147 | IRIX | -- | -- |
All Rights Reserved. Copyright (C) 2009, 2013, Hitachi, Ltd.
Copyright, patent, trademark, and other intellectual property rights related to the "TMEng.dll" file are owned exclusively by Trend Micro Incorporated.