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

Table, Table, Asset.Lotus_Notes, continued, Asset.Memory, Asset.Net_Adapters, Asset.Net_Config,

Get Lenovo ThinkPad T40p PDF manuals and user guides View all Lenovo ThinkPad T40p manuals
Add to My Manuals
Save this manual to your list of manuals

Page 91 highlights

Table 13. Table: Asset.Lotus_Notes (continued) Column Name Type Name LAST_USER VARCHAR ID_FILE VARCHAR SERVER VARCHAR Table 14. Table: Asset.Memory Column Name HWKEY REVISION TYPE LOAD TOTAL FREE USED Type Name INTEGER INTEGER VARCHAR VARCHAR BIGINT BIGINT BIGINT Table 15. Table: Asset.Net_Adapters Column Name HWKEY REVISION DEVICE_ID NAME TYPE DESCRIPTION MAC_ADDRESS MANUFACTURER SERVICENAME Type Name INTEGER INTEGER VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR Table 16. Table: Asset.Net_Config Column Name HWKEY REVISION IP_ADDRESS SUBNET DEVICE_ID GATEWAY DHCP Type Name INTEGER INTEGER VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR Table 17. Table: Asset.Op_Sys Column Name HWKEY REVISION Type Name INTEGER INTEGER Length 70 50 50 Nulls YES YES YES Length 10 Nulls NO NO YES YES NO NO YES Length 50 100 50 150 20 50 50 Nulls NO NO YES YES YES YES YES YES YES Length 15 15 50 15 3 Nulls NO NO YES YES YES YES YES Length Nulls NO NO Appendix B. Using database information 83

  • 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
13.
Table:
Asset.Lotus_Notes
(continued)
Column
Name
Type
Name
Length
Nulls
LAST_USER
VARCHAR
70
YES
ID_FILE
VARCHAR
50
YES
SERVER
VARCHAR
50
YES
Table
14.
Table:
Asset.Memory
Column
Name
Type
Name
Length
Nulls
HWKEY
INTEGER
NO
REVISION
INTEGER
NO
TYPE
VARCHAR
10
YES
LOAD
VARCHAR
YES
TOTAL
BIGINT
NO
FREE
BIGINT
NO
USED
BIGINT
YES
Table
15.
Table:
Asset.Net_Adapters
Column
Name
Type
Name
Length
Nulls
HWKEY
INTEGER
NO
REVISION
INTEGER
NO
DEVICE_ID
VARCHAR
50
YES
NAME
VARCHAR
100
YES
TYPE
VARCHAR
50
YES
DESCRIPTION
VARCHAR
150
YES
MAC_ADDRESS
VARCHAR
20
YES
MANUFACTURER
VARCHAR
50
YES
SERVICENAME
VARCHAR
50
YES
Table
16.
Table:
Asset.Net_Config
Column
Name
Type
Name
Length
Nulls
HWKEY
INTEGER
NO
REVISION
INTEGER
NO
IP_ADDRESS
VARCHAR
15
YES
SUBNET
VARCHAR
15
YES
DEVICE_ID
VARCHAR
50
YES
GATEWAY
VARCHAR
15
YES
DHCP
VARCHAR
3
YES
Table
17.
Table:
Asset.Op_Sys
Column
Name
Type
Name
Length
Nulls
HWKEY
INTEGER
NO
REVISION
INTEGER
NO
Appendix
B.
Using
database
information
83