Home » Lenovo Manuals » Laptops » Lenovo ThinkPad T40p » Manual Viewer

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

Column, Length, Nulls - driver

View all Lenovo ThinkPad T40p manuals

Add to My Manuals
Save this manual to your list of manuals

Page 88 highlights

Table 2. Table: Asset.Asset_Info (continued) Column Name Type Name ROOM VARCHAR ADDRESS_1 VARCHAR ADDRESS_2 VARCHAR TOWN VARCHAR POSTCODE VARCHAR COUNTRY VARCHAR STATE VARCHAR ASSETTAG VARCHAR ASSETTYPE VARCHAR STATUS VARCHAR CUSTOM1 VARCHAR CUSTOM2 VARCHAR CUSTOM3 VARCHAR CUSTOM4 VARCHAR CUSTOM5 VARCHAR CUSTOM6 VARCHAR CUSTOM7 VARCHAR CUSTOM8 VARCHAR CUSTOM9 VARCHAR Table 3. Table: Asset.DASD Column Name HWKEY REVISION DRIVE_LETTER TYPE CAPACITY FREE_SPACE FREE_QUOTA VOLUME_LABEL FILE_SYSTEM Type Name INTEGER INTEGER VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR Table 4. Table: Asset.Drivers Column Name HWKEY REVISION FILENAME DATETIME VERSION VENDOR Type Name INTEGER INTEGER VARCHAR VARCHAR VARCHAR VARCHAR Length 40 50 50 40 10 25 25 30 30 30 250 250 250 250 250 250 250 250 250 Nulls YES YES YES YES YES YES YES YES YES YES YES YES YES YES YES YES YES YES YES Length 15 30 30 30 30 40 30 Nulls NO NO YES YES YES YES YES YES YES Length 120 30 100 100 Nulls NO NO YES YES YES YES 80

Section	Page
Contents	5
About this guide	7
Who should read this guide	8
Additional information	8
Chapter 1. About the System Information Center program	9
Components	9
The System Information Center program	9
The System Information Gatherer program	9
Architecture	10
Features	11
Chapter 2. Installing the System Information Center program on a server	13
Installation requirements	13
Server requirements	13
System Information Center console	14
Installing and configuring a Windows server	14
Installing Windows 2000 Server	14
Obtaining Windows 2000 Server critical updates and service packs	14
Installing Windows Server 2003	14
Obtaining Windows Server 2003 critical updates and service packs	15
Disabling Internet Information Services (IIS)	15
Installing the System Information Center program	15
Quick installation	16
Custom installation	17
Securing your network with Secure Sockets Layer (SSL) security	20
Chapter 3. Installing the System Information Gatherer program	23
Minimum requirements	23
The client computer	23
Prerequisites	23
Considerations for installing the client agent	24
Limitations	25
Performing an attended installation	25
Permanently installing the client agent	25
Installing the client agent from CD	25
Installing the client agent from the System Information Center program GUI	26
Installing the client agent from the Web (IBM computers only)	26
Temporarily using the client agent	26
Performing an unattended installation	26
Setting up an unattended installation from a shortcut	27
Performing an unattended installation from a command line	27
Chapter 4. Using the System Information Center program	29
Understanding user accounts and functions	29
Creating accounts	30
Creating the primary Administrator account	31
Creating user accounts	31
Creating user accounts as an Administrator	31
Creating user accounts by registering an asset	31
Setting user account privileges	32
Registering an asset	32
Registering a remote asset	32
Uploading through the Web interface	33
Using the Process Files task	33
Registering an asset connected to the network	33
Performing other basic functions	34
Chapter 5. Performing System Information Center advanced functions	35
Working with tasks	35
Creating a task	36
Creating an e-mail task	36
Creating a CSV_FILE task	37
Editing a task	38
Running a task	38
Running a task manually	38
Running a task by using the Task Scheduler	39
Working with reports	40
Generating a common report	41
Creating a custom report	42
Generating a custom report	43
Sending a specialized e-mail	44
Sending an e-mail to all users	44
Sending an e-mail to a selected user or users	44
Using the Tasks menu	44
Using the Reports menu	44
Reprocessing the database	45
Working with the ISIC.PROPERTIES file	45
Editing the ISIC.PROPERTIES file	45
Exporting information using the System Information Center program	49
Importing information into a database	49
Performing other advanced functions	50
Chapter 6. Problem solving	53
Recovering when the System Information Center program is not running	53
Using log files to solve a problem	53
Viewing the server status to solve a problem	54
Improving server performance to solve a problem	54
What you need before calling IBM	55
Setting up the Trusted Sites zone	55
Chapter 7. Getting help and support	57
Using the documentation and help system	57
Using the Web	57
Contacting a System Information Center technical expert	58
Obtaining support	58
Appendix A. Modifying the ISIC.PROPERTIES file	59
Template of field information	59
Example: ISIC.PROPERTIES file	59
Appendix B. Using database information	87
Asset and user information tables	87
Internal system tables	96
Appendix C. Notices	103
Trademarks	104

Match case Limit results 1 per page

Table

Table:

Asset.Asset_Info

(continued)

Column

Name

Type

Name

Length

Nulls

ROOM

VARCHAR

YES

ADDRESS_1

VARCHAR

YES

ADDRESS_2

VARCHAR

YES

TOWN

VARCHAR

YES

POSTCODE

VARCHAR

YES

COUNTRY

VARCHAR

YES

STATE

VARCHAR

YES

ASSETTAG

VARCHAR

YES

ASSETTYPE

VARCHAR

YES

STATUS

VARCHAR

YES

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

Table:

Asset.DASD

Column

Name

Type

Name

Length

Nulls

HWKEY

INTEGER

REVISION

INTEGER

DRIVE_LETTER

VARCHAR

YES

TYPE

VARCHAR

YES

CAPACITY

VARCHAR

YES

FREE_SPACE

VARCHAR

YES

FREE_QUOTA

VARCHAR

YES

VOLUME_LABEL

VARCHAR

YES

FILE_SYSTEM

VARCHAR

YES

Table

Table:

Asset.Drivers

Column

Name

Type

Name

Length

Nulls

HWKEY

INTEGER

REVISION

INTEGER

FILENAME

VARCHAR

120

YES

DATETIME

VARCHAR

YES

VERSION

VARCHAR

100

YES

VENDOR

VARCHAR

100

YES