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

Appendix, Using, database, information

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

Appendix B. Using database information The System Information Center program comes with a built-in database. By default, the IBM Cloudscape database provides several tables that can contain a variety of asset and user information. Understanding the information provided with this database can help you perform advanced functions such as exporting information from the database or creating a custom report. Although you will primarily need to understand tables with asset and user information, internal system table information is also included. This appendix includes the following information: v "Asset and user information tables" v "Internal system tables" on page 88 Asset and user information tables The following information is provided to help you understand the overall structure of the built-in database and to help you understand how information is divided into each table. Table 1. Table: Asset.Asset Column Name HWKEY MAX_REVISION MAX_PROCESSED_REVISION IS_PC_ASSET USERKEY UUID SERIAL_NO MANUFACTURER MODEL COMPUTERNAME CUR_USER ENCLOSURE DATETIME Type Name INTEGER INTEGER INTEGER CHARACTER INTEGER VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR TIMESTAMP Length 1 32 64 64 64 64 64 64 Nulls NO NO NO NO NO YES NO YES YES YES YES YES NO Table 2. Table: Asset.Asset_Info Column Name HWKEY DESCRIPTION COMPANY LOCATION DEPARTMENT FLOOR Type Name INTEGER VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR Length 30 40 60 30 40 Nulls NO YES YES YES YES YES © Copyright IBM Corp. 2004 79

  • 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
Appendix
B.
Using
database
information
The
System
Information
Center
program
comes
with
a
built-in
database.
By
default,
the
IBM
Cloudscape
database
provides
several
tables
that
can
contain
a
variety
of
asset
and
user
information.
Understanding
the
information
provided
with
this
database
can
help
you
perform
advanced
functions
such
as
exporting
information
from
the
database
or
creating
a
custom
report.
Although
you
will
primarily
need
to
understand
tables
with
asset
and
user
information,
internal
system
table
information
is
also
included.
This
appendix
includes
the
following
information:
v
“Asset
and
user
information
tables”
v
“Internal
system
tables”
on
page
88
Asset
and
user
information
tables
The
following
information
is
provided
to
help
you
understand
the
overall
structure
of
the
built-in
database
and
to
help
you
understand
how
information
is
divided
into
each
table.
Table
1.
Table:
Asset.Asset
Column
Name
Type
Name
Length
Nulls
HWKEY
INTEGER
NO
MAX_REVISION
INTEGER
NO
MAX_PROCESSED_REVISION
INTEGER
NO
IS_PC_ASSET
CHARACTER
1
NO
USERKEY
INTEGER
NO
UUID
VARCHAR
32
YES
SERIAL_NO
VARCHAR
64
NO
MANUFACTURER
VARCHAR
64
YES
MODEL
VARCHAR
64
YES
COMPUTERNAME
VARCHAR
64
YES
CUR_USER
VARCHAR
64
YES
ENCLOSURE
VARCHAR
64
YES
DATETIME
TIMESTAMP
NO
Table
2.
Table:
Asset.Asset_Info
Column
Name
Type
Name
Length
Nulls
HWKEY
INTEGER
NO
DESCRIPTION
VARCHAR
30
YES
COMPANY
VARCHAR
40
YES
LOCATION
VARCHAR
60
YES
DEPARTMENT
VARCHAR
30
YES
FLOOR
VARCHAR
40
YES
©
Copyright
IBM
Corp.
2004
79