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

Table, Table, Asset.User_Accounts, continued, Asset.User_Info, Asset.Users

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

Table 27. Table: Asset.User_Accounts (continued) Column Name Type Name DISABLED VARCHAR PW_NOT_REQUIRED VARCHAR CANNOT_CHANGE_PW VARCHAR LOCKED_OUT VARCHAR PW_NEVER_EXPIRES VARCHAR PW_EXPIRED VARCHAR Table 28. Table: Asset.User_Info Column Name USERKEY CUSTOM1 CUSTOM2 CUSTOM3 CUSTOM4 CUSTOM5 CUSTOM6 CUSTOM7 CUSTOM8 CUSTOM9 Type Name INTEGER VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR Table 29. Table: Asset.Users Column Name USERKEY USERID EMAIL TITLE FORENAME SURNAME INITIALS NICKNAME COMPANY LOCATION DEPARTMENT FLOOR ROOM TEAM ORG EMPLOYEEID MAILPOINT ADDRESS_1 Type Name INTEGER VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR Length 7 5 5 5 5 5 Nulls YES YES YES YES YES YES Length 250 250 250 250 250 250 250 250 250 Nulls NO YES YES YES YES YES YES YES YES YES Length 70 70 5 30 30 30 30 40 60 60 40 40 60 60 30 10 50 Nulls NO NO NO YES YES YES YES YES YES YES YES YES YES YES YES YES YES YES Appendix B. Using database information 87

  • 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
27.
Table:
Asset.User_Accounts
(continued)
Column
Name
Type
Name
Length
Nulls
DISABLED
VARCHAR
7
YES
PW_NOT_REQUIRED
VARCHAR
5
YES
CANNOT_CHANGE_PW
VARCHAR
5
YES
LOCKED_OUT
VARCHAR
5
YES
PW_NEVER_EXPIRES
VARCHAR
5
YES
PW_EXPIRED
VARCHAR
5
YES
Table
28.
Table:
Asset.User_Info
Column
Name
Type
Name
Length
Nulls
USERKEY
INTEGER
NO
CUSTOM1
VARCHAR
250
YES
CUSTOM2
VARCHAR
250
YES
CUSTOM3
VARCHAR
250
YES
CUSTOM4
VARCHAR
250
YES
CUSTOM5
VARCHAR
250
YES
CUSTOM6
VARCHAR
250
YES
CUSTOM7
VARCHAR
250
YES
CUSTOM8
VARCHAR
250
YES
CUSTOM9
VARCHAR
250
YES
Table
29.
Table:
Asset.Users
Column
Name
Type
Name
Length
Nulls
USERKEY
INTEGER
NO
USERID
VARCHAR
70
NO
EMAIL
VARCHAR
70
NO
TITLE
VARCHAR
5
YES
FORENAME
VARCHAR
30
YES
SURNAME
VARCHAR
30
YES
INITIALS
VARCHAR
30
YES
NICKNAME
VARCHAR
30
YES
COMPANY
VARCHAR
40
YES
LOCATION
VARCHAR
60
YES
DEPARTMENT
VARCHAR
60
YES
FLOOR
VARCHAR
40
YES
ROOM
VARCHAR
40
YES
TEAM
VARCHAR
60
YES
ORG
VARCHAR
60
YES
EMPLOYEEID
VARCHAR
30
YES
MAILPOINT
VARCHAR
10
YES
ADDRESS_1
VARCHAR
50
YES
Appendix
B.
Using
database
information
87