Lenovo ThinkPad T40p IBM System Information Center Administrator's Guide - Page 92

Table, Table, Asset.Op_Sys, continued, Asset.PCI, Asset.Processor, Asset.PW_Policy

Page 92 highlights

Table 17. Table: Asset.Op_Sys (continued) Column Name Type Name OS_VENDOR VARCHAR OS_NAME VARCHAR OS_VERSION VARCHAR OS_BUILD VARCHAR OS_CSD VARCHAR DATETIME TIMESTAMP Table 18. Table: Asset.PCI Column Name HWKEY REVISION BUS DEV FUNC SLOT VENDOR_ID VENDOR_NAME DEVICE_ID DEVICE_NAME CLASS SUB_CLASS Type Name INTEGER INTEGER INTEGER INTEGER INTEGER VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR Table 19. Table: Asset.Processor Column Name HWKEY REVISION SOCKET MANUFACTURER PROCESSORID VERSION SPEED STATUS SERIAL_NO PART_NO Type Name INTEGER INTEGER VARCHAR VARCHAR VARCHAR VARCHAR INTEGER VARCHAR VARCHAR VARCHAR Table 20. Table: Asset.PW_Policy Column Name HWKEY REVISION MIN_LENGTH Type Name INTEGER INTEGER INTEGER Length 50 50 50 15 50 Nulls YES YES YES YES YES NO Length 60 15 100 15 100 15 20 Nulls NO NO YES YES YES YES YES YES YES YES YES YES Length 30 60 30 100 40 30 30 Nulls NO NO YES YES YES YES YES YES YES YES Length Nulls NO NO NO 84

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108

Table
17.
Table:
Asset.Op_Sys
(continued)
Column
Name
Type
Name
Length
Nulls
OS_VENDOR
VARCHAR
50
YES
OS_NAME
VARCHAR
50
YES
OS_VERSION
VARCHAR
50
YES
OS_BUILD
VARCHAR
15
YES
OS_CSD
VARCHAR
50
YES
DATETIME
TIMESTAMP
NO
Table
18.
Table:
Asset.PCI
Column
Name
Type
Name
Length
Nulls
HWKEY
INTEGER
NO
REVISION
INTEGER
NO
BUS
INTEGER
YES
DEV
INTEGER
YES
FUNC
INTEGER
YES
SLOT
VARCHAR
60
YES
VENDOR_ID
VARCHAR
15
YES
VENDOR_NAME
VARCHAR
100
YES
DEVICE_ID
VARCHAR
15
YES
DEVICE_NAME
VARCHAR
100
YES
CLASS
VARCHAR
15
YES
SUB_CLASS
VARCHAR
20
YES
Table
19.
Table:
Asset.Processor
Column
Name
Type
Name
Length
Nulls
HWKEY
INTEGER
NO
REVISION
INTEGER
NO
SOCKET
VARCHAR
30
YES
MANUFACTURER
VARCHAR
60
YES
PROCESSORID
VARCHAR
30
YES
VERSION
VARCHAR
100
YES
SPEED
INTEGER
YES
STATUS
VARCHAR
40
YES
SERIAL_NO
VARCHAR
30
YES
PART_NO
VARCHAR
30
YES
Table
20.
Table:
Asset.PW_Policy
Column
Name
Type
Name
Length
Nulls
HWKEY
INTEGER
NO
REVISION
INTEGER
NO
MIN_LENGTH
INTEGER
NO
84