Lenovo ThinkPad R40 IBM System Information Center Administrator's Guide
Lenovo ThinkPad R40 Manual
View all Lenovo ThinkPad R40 manuals
Add to My Manuals
Save this manual to your list of manuals |
Lenovo ThinkPad R40 manual content summary:
- Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 1
IBM System Information Center Administrator's Guide - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 2
- Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 3
IBM System Information Center Administrator's Guide - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 4
, read the information in Appendix C, "Notices," on page 95. First Edition (October 2004) © Copyright International Business Machines Corporation 2004. All rights reserved. US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp. - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 5
45 Using log files to solve a problem 45 Viewing the server status to solve a problem . . . 46 Improving server performance to solve a problem 46 What you need before calling IBM 47 Setting up the Trusted Sites zone 47 Chapter 7. Getting help and support . . 49 Using the documentation and help - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 6
iv - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 7
can perform v Performing advanced functions v Solving problems v Getting support This guide also supplements the System Information Center help system, which provides step-by-step instructions on how to perform specific tasks within the program. This guide is organized as follows: Chapter 1, "About - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 8
about the System Information Center program from the following web site: http://www-3.ibm.com/pc/support/site.wss/document.do?Indocid=MIGR-56187 This IBM System Information Center Administrator's Guide might be updated periodically. The updated versions will be made available at this Web site. vi - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 9
can be manually entered for non user productivity. The client agent also gathers a rich set of hardware information, including client network name, serial and model number, processor type and speed, device drivers, BIOS level and settings, network settings, and memory information. © Copyright IBM - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 10
Or, it can be temporarily used when a User uploads asset information to the database. The client as the IBM Cloudscape™ database, both of which rely on Java™ SDK. The Microsoft® Windows® Server part of the System Information Center program. IBM System Information Center program Apache Tomcat IBM - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 11
or higher) Web browser. Authorized users can access and update asset information easily and quickly specific address. Exported report information can be made compliant with other SQL-compliant databases such as IBM DB2 user accounts that are allowed to perform those tasks. The Administrator's Guide - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 12
4 - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 13
support through IBM Global Services. For more information, see Chapter 7, "Getting help and support," on page 49. This chapter describes the following information about installing the System Information Center program: v "Installation requirements" v "Installing and configuring a Windows server - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 14
choose to use any other server platform, you can receive fee-based support through IBM Global Services. For more information, see Chapter 7, "Getting help and support," on page 49. Installing Windows 2000 Server Install the Windows 2000 Server operating system on the computer you intend to use as - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 15
to acquire and install updated device drivers. Ensure that all devices are working correctly. When the installation is complete, continue with "Obtaining Windows Server 2003 critical updates and service packs" on page 7. Obtaining Windows Server 2003 critical updates and service packs Go to http - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 16
customized ISIC.PROPERTIES file, you have the option later of manually changing this file if changes in your environment require it. to the InstallShield Wizard for IBM System Information Center program″ window opens. 3. Click Next. The Apache Tomcat 4.1.30 Required window opens. Note: The - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 17
problems: The e-mail address of the administrator for reporting problems. 3. Click Next. The Ready to Install window opens. 4. Click Next. The Setup Status window created that account, you can manually add a User account or change the authority of a User account. A User can create their own account - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 18
: The e-mail address of the administrator for reporting problems. 4. Click Next. The Action Authority Settings window opens. 5. With the Action Authority Settings window you can associate specific tasks with specific user accounts. Mark an appropriate user account (as described in the following list - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 19
time the asset is registered. v The User Demographics Form includes information specific to the user. Mark the check box for all fields required at the time the asset is registered. 12. Click Next. The Security Settings window opens. 13. In the Security Settings window, you can choose to have the - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 20
file" on page 37. 14. Click Next. The Ready to Install window opens. 15. Click Next. The Setup Status window opens and the progress indicator have created that account, you can manually add a User account or change the authority of a User account. A User can create their own account by registering - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 21
2. Refer to the Apache Tomcat Web site for detailed instructions on configuring Tomcat to secure your server with SSL. Chapter 2. Installing the System Information Center program on a server 13 - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 22
14 - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 23
the System Information Center program on a server," on page 5. Review the information in this chapter carefully before you install the client IBM computers, see "Components" on page 1. Client computers must meet the following minimum requirements: v Either Microsoft Windows 2000 or Microsoft Windows - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 24
licenses, warranty service, and support for non-IBM products must be acquired from the third party, not IBM. IBM makes no representations or warranties regarding non-IBM products. Considerations for scans is uploaded to the database where the existing information is updated. For details about 16 - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 25
little to no direct user intervention is required. For details about configuring the client agent to perform an unattended (or silent) install, see "Performing an unattended installation" on page 18. Limitations The client agent uses a specific scheduler provided by IBM. The client agent and - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 26
user ID and password, then click Submit. The System Information Center program is displayed. 3. In the System Information Center menu bar, click Assets. 4. Click Download Agent Installer. The File Download window opens. 5. Follow the instructions and prompts for specific demographic information about - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 27
. The Properties window is displayed. b. In the Target field, add the following to the end of the command: /s /v"/qn ISIGURL=http://servername" (where servername is the network name or IP address of the server the System Information Center is installed on. 5. Instruct your users to map a drive - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 28
Note: Make sure you include the double-quotes and do not include a / at the end of the servername. 20 - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 29
specific user functions, see the IBM System Information Center help system. Understanding user accounts and functions The User, Super-User, and Administrator accounts are the three types of user only as a guide since they indicate only the default authority levels. User account authority may - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 30
advanced searches for specific asset data v Updating additional asset information Can perform all of the tasks of the User and Super-User and has privileges , adding members to a group, solving problems, and approving asset requests. Unlike the User and Super-User, is not limited to just viewing and - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 31
and Password; then click Submit. The System Information Center program is displayed. 2. Mark the New User check box. 3. Click Submit. The Add User window opens. 4. Complete the fields by typing the appropriate information, ensuring that all required fields are complete. 5. Click Submit. The Register - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 32
2. In the System Information Center menu bar, click Users. 3. Click All Users. 4. Mark the check box next to the user account you would like to alter. 5. In the System Information Center menu bar, click Users. 6. Click Edit. The ″Change details″ window opens. 7. Using the drop-down menu, select the - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 33
included. This process is useful for getting a large number of disconnected clients loaded network Registering an asset requires filling out specific demographic information that is used to supplement the following procedure: 1. At the Logon window, type your User ID and Password. 2. Click Submit. - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 34
user accounts are established, users can begin performing functions that coincide with their type of user account. For detailed instructions on how to perform specific functions, see the IBM manually to the database. v Viewing asset information: You can choose to view asset information for a specific - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 35
once or to occur at set intervals. Tasks can also be run manually. Tasks, which can only be created through the server, are simply of an e-mail, which sends an attached report to a target user or group of users. This task assumes that you have e-mail functionality enabled. The IBM Corp. 2004 27 - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 36
to upload asset information, generate and attach reports, and to only target specific user accounts. Creating an e-mail task To create an e-mail task, complete the following procedure: 1. At the Logon window, type your User ID and Password. Click Submit. The System Information Center program is - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 37
users″ field: Target users are identified in Step 14. Type a menu description in the ″Menu description for selected users″ field: This is the description of the menu name for selected users. 14. Select target users: Target users use as scheduled, click Yes. The window fields expand. Go to the next - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 38
to export as a file ″ drop-down menu select an option. 14. Click Submit. Editing a task When you edit a task, you manually: v Selecting it from the Tasks menu v Editing the task To run an individual task from the Tasks menu, complete the following procedure: 1. At the Logon window, type your User - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 39
it to run sooner, if the task is not scheduled, or if the task is inactive), complete the following procedure: 1. At the Logon window, type your User ID and Password. Click Submit. The System Information Center program is displayed. 2. In the System Information Center menu bar, click Tasks and then - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 40
the Task Scheduler will have to be started manually as described in the procedure for starting the Task run the Task Scheduler: 1. At the Logon window, type your User ID and Password. Click Submit. The System modified that help you generate information specific to your enterprise environment. This - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 41
instructs how to generate a common report: All Assets Provides summaries of PC and non-PC assets, assets in transfer, and assets not inventoried within 90 days. Data Maintenance Provides specific key information about asset and user : 1. At the Logon window, type your User ID and Password. Click - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 42
each of which has a series of columns that contain specific asset and user information. Using the System Information Center program's GUI, you custom report, complete the following procedure: 1. At the Logon window, type your User ID and Password. Click Submit. The System Information Center program - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 43
and select Add Query Column. Then click on the column that contains the specific user or asset information you want to add to the common report. Note: The run manually after they are created. To generate a custom report, complete the following procedure: 1. At the Logon window, type your User ID - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 44
either send an e-mail to all users or to a single user. Sending an e-mail to all users To send an e-mail that contains specific asset or user-related information for a specific task to all users, complete the following procedure: 1. At the Logon window, type your User ID and Password. Click Submit - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 45
the database, complete the following procedure: 1. At the Logon window, type your User ID and Password. Click Submit. The System Information Center . The configuration of each section dictates the performance of a certain part of the System Information Center program. Within each section are a - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 46
your SMTP server. Web site Settings This is a way to reference specific URLs and e-mail addresses in your environment. Information in these fields You can assign a user account for the following items: v Update user passwords v Update user details v Change asset owner v Add or delete a user v Add or - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 47
unit (minutes, hours, or days) used when task schedules are created or edited. Password Settings You can define how to manage and create user account passwords that are required to access the System Information Center program by modifying the following items: v Password Control Settings: - Encrypt - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 48
- Title: Title of the user. - Town: Town where the user lives. - User ID: User ID of the user. Security Settings With these settings you can use the System Information Center program to verify security settings on all client computers. You can check to see if specific Microsoft settings are used on - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 49
a .CSV file, complete the following procedure: 1. At the Logon window, type your User ID and Password. Click Submit. The System Information Center program is on page 28 The CSV file can then be imported into another database such as IBM DB2. An example of how this would be done using DB2 is shown in - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 50
MYUSERS USER db2admin USING password -- Clear the table DELETE FROM MY.USERS WHERE execute the IMPORT.BAT file, which, in turn, executes the DB2 importing script - IMPORT functions, see the IBM System Information Center and server status to help diagnose a problem. v Interrupting the Task Scheduler: In - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 51
v Uploading files to the server: You can upload files to a pre-configured folder on the server. The folder, as well as the password required to perform the action, is configured in the ISIC.PROPERTIES file. v Processing configured files: You can use a predefined task to process .EG2 files located in - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 52
44 - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 53
in the System Information Center program to troubleshoot problems you encounter. v If you want to troubleshoot transactions (for example, adding or retiring an asset), complete the following procedure to view the Transaction Logs: 1. At the Logon window, type your User ID and Password. Click Submit - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 54
If you want to troubleshoot tasks, complete the following procedure to view the Task Logs: 1. At the Logon window, type your User ID and Password. Click log file in "What you need before calling IBM" on page 47. Viewing the server status to solve a problem You can view the status of the server to - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 55
an e-mail and send it to your internal service representative or to an IBM representative. Setting up the Trusted Sites zone If you encounter problems loading the System Information Center administrator's console Web pages while running Windows XP with Service Pack 2, you may need to add your System - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 56
48 - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 57
Chapter 7. Getting help and support The System Information Center program is supported by IBM. If you have a problem with the System Information Center program or have questions about a specific feature, a variety of sources are available to help you including documentation, an integrated help - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 58
Web site. You can contact an System Information Center technical expert through the e-mail service provided on the System Information Center Web site. To access the Web site, go to: http://www3.ibm.com/pc/support/site.wss/document.do?Indocid=MIGR-56187 To obtain the telephone number for your country - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 59
Possible Values Value Definition The field contains one or more parameters used to accomplish a specific task within the category. The field is used to describe precisely what function the field Additional information" on page vi DO NOT EDIT THE FOLLOWING LINES: © Copyright IBM Corp. 2004 51 - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 60
Field Description Possible Values Value Definition smtp.server The address of the SMTP server you are using for e-mail. User-defined User-defined smtp.authentication=false Modifiable Field Field Description Possible Values Value Definition smtp.authentication The SMTP server must authenticate the - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 61
Default filename used when a report is mailed out. The report will be exported into a CSV file with this filename and attached to the e-mail. User-defined User-defined; must not be blank and must only contain characters valid for a filename. file.email.mime.type Represents the mime type for the file - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 62
e-mail address of the administrator for reporting problems. User-defined User-defined upload.process.xml = Modifiable Field not want to process any data from client uploads, such as in a troubleshooting situation. upload.process.xml.max.queue = Modifiable Field Field Description Possible Values - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 63
Values Value Definition If the value is ″1″, the processing of the XML will be queued as a background task and will be processed as the server gets to it. If the value is ″0″, the XML from the upload request will not be processed. The XML file may be stored in the FILESTORE - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 64
on the System Information Center server where .EG2 files can be copied for processing by the ″Process Files in Configured Folder″ task. User-defined User-defined; must be the full path to an existing directory accessible from the System Information Center server. eg2.file.delete = Modifiable Field - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 65
remotely send manually collected .EG2 files to the server for processing. This could also point to the folder that contains the ISIC.PROPERTIES file so the administrator can upload an updated properties file, then remotely restart the server so the changes can take affect. User-defined User-defined - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 66
number of working threads that can be used by the System Information Center program. User-defined integer User-defined queue.max.length Defines the maximum number of processes (upload requests, XML file query.processed.incorrectly= query.asset.count= query.pc.asset.count= query.ibm.pc.asset.count= 58 - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 67
.password.auth=A Modifiable Field Field Description Possible Values Value Definition update.password Grant the minimal user account authority level for updating user passwords. U / S / A ″U″ is ″user,″ ″S″ is ″super-user,″ ″A″ is ″administrator″ Appendix A. Modifying the ISIC.PROPERTIES file 59 - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 68
=S Modifiable Field Field Description Possible Values update.details Grant the minimal user account authority level for updating user details. U / S / A ″U″ is ″user,″ ″S″ is ″super-user,″ ″A″ is ″administrator″ change.asset.owner Grant the minimal user account authority level for changing an asset - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 69
Field Description Possible Values Value Definition asset.revisions Maximum number of asset revisions to store for each uploaded asset. User-defined User-defined asset.keep.baseline=true Modifiable Field Field Description Possible Values Value Definition asset.keep.baseline True / False Category - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 70
of assets in the queue beyond which the server declines the upload without registering the upload attempt in the application log. User-Defined User-Defined scheduled.launch.on.startup= Modifiable Field Field Description Possible Values Value Definition scheduled.launch.on.startup Whether to enable - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 71
number of processes (such as a task, upload, or an email) that will be processed; beyond that number they will be stored. User-Defined User-Defined task.process.files.max.queue.length= Modifiable Field Field Description Possible Values Value Definition task.process.files.max.queue.length When the - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 72
.timeout.period=186 Modifiable Field Field Description Possible Values Value Definition password.timeout After how many days passwords expire. User-defined User-defined password.period= Modifiable Field Field Description password.period Maximum number of days before a password can be reused. 64 - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 73
characters. password.min.length= Modifiable Field Field Description Possible Values Value Definition password.min.length Minimum length of a password. User-defined User-defined password.max.length= Modifiable Field password.min.length Appendix A. Modifying the ISIC.PROPERTIES file 65 - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 74
Definition password.max.previous.chars Maximum number of sequential password characters that can be reused in a new password. User-defined User-defined Category Description: Form Settings asset.assettag.required= Modifiable Field Field Description Possible Values Value Definition asset.assettag - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 75
Field Description Possible Values Value Definition asset.owner.required= Modifiable Field Field Description Possible Values Value Definition asset.department.required= Modifiable Field Field Description Possible Values Value Definition asset.floor.required= Modifiable Field Field Description - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 76
Field Description Possible Values Value Definition asset.status.required= Modifiable Field Field Description Possible Values Value Definition asset.manufacturer.required= Modifiable Field Field Description Possible Values Value Definition asset.model.required= Modifiable Field Field Description - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 77
is not required to be completed in order for an asset to be successfully added to the database. user.title.required Whether the Title field is required to be completed in order for a user to be successfully added to the database. True/False If ″True,″ the Title field is required to be - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 78
if ″False,″ the UserID field is not required to be completed in order for a user to be successfully added to the database. user.address.required Whether the Address field is required to be completed in order for a user to be successfully added to the database. True/False If ″True,″ the Address field - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 79
Office Phone Number field is not required to be completed in order for a user to be successfully added to the database. user.mobno.required Whether the Mobile Phone Number field is required to be completed in order for a user to be successfully added to the database. True/False If ″True,″ the Mobile - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 80
if ″False,″ the Location field is not required to be completed in order for a user to be successfully added to the database. user.password.required Whether the Password field is required to be completed in order for a user to be successfully added to the database. True/False If ″True,″ the Password - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 81
is password-protected. hdd.password.required During a security audit task the IBM System Information Center program checks and verifies that the hard disk drive task the System Information Center program checks and verifies that Windows screen savers on all client computers are password-protected. 1 - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 82
set on all client computers. win.min.pw.length Minimum password length for Windows account. User-defined/0 User-defined; ″0″ means any length is acceptable. win.min.pw.age Maximum password length for Windows account. User-defined/0 User-defined; ″0″ means any age is acceptable. win.gina.version 74 - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 83
Field If your security protocol requires a GINA other than default Windows GINA (such as IBM Client Security), then set to check for the other security (must appear in Windows Control Panel Add/Remove Programs list) is installed on all client computers. User-defined/blank User-defined; if ″blank - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 84
and verifies that the version number of the required antivirus application (must appear in Windows Control Panel Add/Remove Programs list) is installed on all client computers. User-defined/blank User-defined; if ″blank,″ during a security audit task the System Information Center program does not - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 85
and verifies that the version number of the required firewall application (must appear in Windows Control Panel Add/Remove Programs list) is installed on all client computers. User-defined/blank User-defined; if ″blank,″ during a security audit task the System Information Center program does not - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 86
78 - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 87
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 - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 88
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 - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 89
Table 4. Table: Asset.Drivers (continued) Column Name Type Name FILE_SIZE INTEGER Length Nulls YES Table 5. Table: Asset.Email_Template Column Name EMAILKEY LOCALE NAME DESCRIPTION EMAIL_FROM TITLE CONTENT CREATOR CREATED - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 90
Table 9. Table: Asset.HW_Security (continued) Column Name Type Name REVISION INTEGER POWER_ON_PW_STATUS VARCHAR KEYBOARD_PW_STATUS VARCHAR ADMIN_PASSWORD_STATUS VARCHAR FRONT_PANEL_RESET_STATUS VARCHAR Table 10. Table: Asset.IBM_Rapid_Restore Column Name Type Name HWKEY INTEGER - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 91
Table 13. Table: Asset.Lotus_Notes (continued) Column Name Type Name LAST_USER VARCHAR ID_FILE VARCHAR SERVER VARCHAR Table 14. Table: Asset.Memory Column Name HWKEY REVISION TYPE LOAD TOTAL FREE USED Type Name INTEGER INTEGER VARCHAR VARCHAR BIGINT BIGINT BIGINT Table 15. Table: Asset. - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 92
Table 17. Table: Asset.Op_Sys (continued) Column Name Type Name OS_VENDOR VARCHAR OS_NAME VARCHAR OS_VERSION VARCHAR OS_BUILD VARCHAR OS_CSD VARCHAR DATETIME TIMESTAMP Table 18. Table: Asset.PCI Column Name HWKEY REVISION BUS DEV FUNC SLOT VENDOR_ID VENDOR_NAME DEVICE_ID DEVICE_NAME - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 93
Table 20. Table: Asset.PW_Policy (continued) Column Name Type Name MAX_PW_AGE INTEGER MIN_PW_AGE INTEGER HISTORY_LENGTH INTEGER FORCE_LOGOFF_MINS INTEGER Table 21. Table: Asset.Revisions Column Name HWKEY REVISION PROCESSED DATETIME Type Name INTEGER INTEGER CHARACTER TIMESTAMP Table 22 - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 94
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 - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 95
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 - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 96
Table 29. Table: Asset.Users (continued) Column Name Type Name ADDRESS_2 VARCHAR TOWN VARCHAR POSTCODE 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: - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 97
Table 31. Table: Asset.Custom_Query (continued) Column Name Type Name DESCRIPTION VARCHAR SQL_DATA LONG VARCHAR CREATOR INTEGER CREATED TIMESTAMP Length 120 10 Nulls YES NO YES NO Table 32. Table: Asset.Custom_Query_Group_Access Column Name Type Name CUSTOM_QUERYKEY INTEGER - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 98
QUERYKEY2 Type Name INTEGER VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR INTEGER Table 37. Table: Asset.Passwords Column Name USERKEY PASSWORD UPDATED Type Name INTEGER VARCHAR TIMESTAMP Table 38. Table: Asset.Query Column Name QUERYKEY NAME DESCRIPTION SQL_DATA FONTSIZE AUTHORITY DISPLAY REFRESH - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 99
Table 40. Table: Asset.Query_Col_Info Column Name QUERYKEY NAME DISPLAYCOL DISPLAYDATA ALIAS ACTION1 ACTION2 ACTION3 ACTION_LOGO ACTION_LOGO2 ACTION_LOGO3 ACTION_POPUP ACTION_POPUP2 ACTION_POPUP3 COLOUR ALIGN SUMMARY POPUP DELETEABLE AUTHORITY Type Name INTEGER VARCHAR INTEGER INTEGER VARCHAR - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 100
Table 42. Table: Asset.Task (continued) Column Name Type Name USERLIST VARCHAR QUERY INTEGER MAIL_TEMPLATE INTEGER CREATOR VARCHAR CREATED TIMESTAMP Table 43. Table: Asset.Task_Log Column Name TASKKEY USERKEY USER_LIST COMMENT DATETIME Type Name INTEGER INTEGER VARCHAR VARCHAR - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 101
Table 48. Table: Asset.User_Preference Column Name USERKEY ATTRIBUTE VALUE Type Name INTEGER VARCHAR VARCHAR Table 49. Table: Asset.XML_Lookup Column Name SCHEMA_NAME TABLE_NAME COLUMN_NAME TEXT FILETYPE VERSION XPATH NODETYPE ISKEY PROBE_SET Type Name VARCHAR VARCHAR VARCHAR INTEGER VARCHAR - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 102
94 - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 103
or typographical errors. Changes are support applications where malfunction may result in injury or death to person. The information contained in this document does not affect or change IBM product specifications those Web sites are not part of the materials for this IBM product, and use of those - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 104
data for their specific environment. The following terms are trademarks of International Business Machines Corporation in the United States, other countries, or both: Cloudscape DB2 IBM IBM (logo) Rescue and Recovery Rapid Restore ThinkVantage MS-DOS, Microsoft, and Windows and are trademarks - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 105
installation) 17 System Information Gatherer (unattended) 17 Windows 2000 Server 6 Windows Server 2003 6 InstallShield wizard 8 ISIC.PROPERTIES editing N Notices and trademarks 95 O Obtaining support 50 P problem solving 45 recovering when the IBM System Information Center program is not running - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 106
technical support 49 Windows 2000 Server critical updates 6 installing 6 service packs 6 Windows Server 2003 critical updates 7 installing 6 service packs by starting the Task Scheduler 31 running a task manually 30 sending a specialized e-mail 36 working with reports 32 working with tasks - Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 107
- Lenovo ThinkPad R40 | IBM System Information Center Administrator's Guide - Page 108
Printed in USA
IBM
System
Information
Center
Administrator’s
Guide
±²³