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

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

Internal, system, tables

View all Lenovo ThinkPad T40p manuals

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

Page 96 highlights

Table 29. Table: Asset.Users (continued) Column Name Type Name ADDRESS_2 VARCHAR TOWN VARCHAR POSTCODE VARCHAR COUNTRY VARCHAR STATE VARCHAR TEL_NO VARCHAR MOB_NO VARCHAR AUTHORITY CHARACTER LOCALE VARCHAR PASSWORD VARCHAR EXPIRED CHARACTER PASSWORD_CHANGED TIMESTAMP LAST_UPDATE TIMESTAMP CREATED TIMESTAMP Table 30. Table: Asset.WST Column Name HWKEY REVISION SECURE POWER_ON_PW HDD_PW FILESHARE SCREENSAVER USER_ACCOUNTS PW_LENGTH PW_AGE ANTIVIRUS FIREWALL Type Name INTEGER INTEGER VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR Length 50 40 10 25 25 25 25 1 30 100 1 Nulls YES YES YES YES YES YES YES YES YES NO NO YES YES NO Length 3 300 300 300 300 1000 300 300 300 300 Nulls NO NO NO YES YES YES YES YES YES YES YES YES Internal system tables The following tables are used only by the System Information Center program; however, you may need to understand their structure when troubleshooting problems with the program. For more information, see Chapter 6, "Problem solving," on page 45. Table 31. Table: Asset.Custom_Query Column Name CUSTOM_QUERYKEY NAME MENU_NAME Type Name INTEGER VARCHAR VARCHAR Length 50 50 Nulls NO NO NO 88

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

29.

Table:

Asset.Users

(continued)

Column

Name

Type

Name

Length

Nulls

ADDRESS_2

VARCHAR

YES

TOWN

VARCHAR

YES

POSTCODE

VARCHAR

YES

COUNTRY

VARCHAR

YES

STATE

VARCHAR

YES

TEL_NO

VARCHAR

YES

MOB_NO

VARCHAR

YES

AUTHORITY

CHARACTER

YES

LOCALE

VARCHAR

YES

PASSWORD

VARCHAR

100

EXPIRED

CHARACTER

PASSWORD_CHANGED

TIMESTAMP

YES

LAST_UPDATE

TIMESTAMP

YES

CREATED

TIMESTAMP

Table

30.

Table:

Asset.WST

Column

Name

Type

Name

Length

Nulls

HWKEY

INTEGER

REVISION

INTEGER

SECURE

VARCHAR

POWER_ON_PW

VARCHAR

300

YES

HDD_PW

VARCHAR

300

YES

FILESHARE

VARCHAR

300

YES

SCREENSAVER

VARCHAR

300

YES

USER_ACCOUNTS

VARCHAR

1000

YES

PW_LENGTH

VARCHAR

300

YES

PW_AGE

VARCHAR

300

YES

ANTIVIRUS

VARCHAR

300

YES

FIREWALL

VARCHAR

300

YES

Internal

system

tables

The

following

tables

are

used

only

the

System

Information

Center

program;

however,

you

may

need

understand

their

structure

when

troubleshooting

problems

with

the

program.

For

information,

see

Chapter

“Problem

solving,”

page

45.

Table

31.

Table:

Asset.Custom_Query

Column

Name

Type

Name

Length

Nulls

CUSTOM_QUERYKEY

INTEGER

NAME

VARCHAR

MENU_NAME

VARCHAR