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

Table, Table, Asset.Transfers, continued, Asset.TVT_Schedule, Asset.Uptime, Asset.User_Accounts

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 94 highlights

Table 24. Table: Asset.Transfers (continued) Column Name Type Name COMMENT VARCHAR REASON VARCHAR CREATED TIMESTAMP PROCESSED TIMESTAMP Table 25. Table: Asset.TVT_Schedule Column Name HWKEY REVISION TASK PROGRAM_FILE PARAMETERS FREQUENCY SCH_TIME SCH_DAY Type Name INTEGER INTEGER VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR Table 26. Table: Asset.Uptime Column Name HWKEY REVISION VERSION PLATFORMID INSTALLDATE GHOSTFLAG CURRENTTIME LOG_START_DATE HOURS_SINCE_LOG_DATE UPTIME_SINCE_LOG_DATE UPTIME RATIO RESTART_CYCLE_COUNT Type Name INTEGER INTEGER VARCHAR INTEGER BIGINT CHARACTER BIGINT BIGINT BIGINT BIGINT VARCHAR INTEGER Table 27. Table: Asset.User_Accounts Column Name HWKEY REVISION USERID USERNAME PW_SET PW_AGE USER_PRIVILEGE Type Name INTEGER INTEGER VARCHAR VARCHAR VARCHAR INTEGER VARCHAR Length 30 30 Nulls NO YES NO YES Length 100 100 500 50 20 20 Nulls NO NO YES YES YES YES YES YES Length 10 1 20 Nulls NO NO YES YES YES YES YES YES YES YES YES YES Length 100 100 7 100 Nulls NO NO NO YES YES YES YES 86

  • 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
24.
Table:
Asset.Transfers
(continued)
Column
Name
Type
Name
Length
Nulls
COMMENT
VARCHAR
30
NO
REASON
VARCHAR
30
YES
CREATED
TIMESTAMP
NO
PROCESSED
TIMESTAMP
YES
Table
25.
Table:
Asset.TVT_Schedule
Column
Name
Type
Name
Length
Nulls
HWKEY
INTEGER
NO
REVISION
INTEGER
NO
TASK
VARCHAR
100
YES
PROGRAM_FILE
VARCHAR
100
YES
PARAMETERS
VARCHAR
500
YES
FREQUENCY
VARCHAR
50
YES
SCH_TIME
VARCHAR
20
YES
SCH_DAY
VARCHAR
20
YES
Table
26.
Table:
Asset.Uptime
Column
Name
Type
Name
Length
Nulls
HWKEY
INTEGER
NO
REVISION
INTEGER
NO
VERSION
VARCHAR
10
YES
PLATFORMID
INTEGER
YES
INSTALLDATE
BIGINT
YES
GHOSTFLAG
CHARACTER
1
YES
CURRENTTIME
BIGINT
YES
LOG_START_DATE
BIGINT
YES
HOURS_SINCE_LOG_DATE
BIGINT
YES
UPTIME_SINCE_LOG_DATE
BIGINT
YES
UPTIME
RATIO
VARCHAR
20
YES
RESTART_CYCLE_COUNT
INTEGER
YES
Table
27.
Table:
Asset.User_Accounts
Column
Name
Type
Name
Length
Nulls
HWKEY
INTEGER
NO
REVISION
INTEGER
NO
USERID
VARCHAR
100
NO
USERNAME
VARCHAR
100
YES
PW_SET
VARCHAR
7
YES
PW_AGE
INTEGER
YES
USER_PRIVILEGE
VARCHAR
100
YES
86