Lenovo ThinkPad G40 IBM System Information Center Administrator's Guide
Lenovo ThinkPad G40 Manual
View all Lenovo ThinkPad G40 manuals
Add to My Manuals
Save this manual to your list of manuals |
Lenovo ThinkPad G40 manual content summary:
- Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 1
IBM System Information Center Administrator's Guide - Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 2
- Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 3
IBM System Information Center Administrator's Guide - Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 4
Before using this information and the product it supports, 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 - Lenovo ThinkPad G40 | 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 G40 | IBM System Information Center Administrator's Guide - Page 6
iv - Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 7
and understanding the functions each user account 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 - Lenovo ThinkPad G40 | 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 G40 | IBM System Information Center Administrator's Guide - Page 9
costs, and increase 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 Corp. 2004 1 - Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 10
client agent can be permanently installed on a client computer by downloading it from the Web, from the System Information Center program CD, or from the System Information Center program menu structure. Or, it can be temporarily used when a User uploads asset information to the database. The client - Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 11
users can access and update asset information easily and quickly with a familiar Web interface. v Minimal resource on client computer reports based on the type of asset information you specific address. Exported report information can be made compliant with other SQL-compliant databases such as IBM - Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 12
4 - Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 13
or capability: v At least a 550MHz Intel™ or AMD processor v A minimum of 1 GB of memory v At least 3 GB of hard disk space for the operating system and required applications plus 2 MB per client v A network card that supports TCP/IP In addition, you must have the following items or capability - Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 14
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 the Web application - Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 15
and other hardware devices installed in your computer, you might have 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 - Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 16
file, you have the option later of manually changing this file if changes in your environment Windows Start menu. b. Click Run. c. Type D:\SERVER\ISIC_SETUP.EXE (where D is the letter of your CD drive). 2. The ″Welcome to the InstallShield Wizard for IBM System Information Center program″ window - Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 17
the ″Restart required to complete installation″ window opens. 5. Mark an option button to restart your computer now or restart later. Click Finish. 6. If you have chosen to restart your computer, close any open programs and remove any disks from their drives; your computer will shut down and restart - Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 18
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 schedule. - Check for scheduled tasks every: Type the frequency that the server should check for - Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 19
reused from previous password: Type the maximum number of sequential password characters that can be reused in a new password. (Default is 3.) 10. Click Next. The Form Settings window opens. 11. The Form Settings window displays fields you can select as ″required″ in order for an asset or user to be - Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 20
″Restart required to complete installation″ window opens. 16. Mark an option button to restart your computer now or restart later. Click Finish. 17. If you have chosen to restart your computer, close any open programs and remove any disks from their drives; your computer will shut down and restart - Lenovo ThinkPad G40 | 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 G40 | IBM System Information Center Administrator's Guide - Page 22
14 - Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 23
Microsoft Windows XP operating system v Microsoft Internet Explorer 6.0 (or higher) Web browser v CD drive for installing the client agent using the System Information Center media v Internet connection for downloading and installing the client agent using the Web v A network card that supports TCP - Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 24
might require an unattended installation. Others can install the client agent on IBM and non-IBM computers using the IBM System Information Center CD or the IBM System Information Gatherer CD. The executable is also available to users within your enterprise on the Web whenever they log on to the - Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 25
a user logs into System Information Center, or downloaded from the Web. Installing the client agent from CD To install the client agent, complete the following procedure: 1. Insert the IBM System Information Center CD or the IBM System Information Gatherer CD into the CD drive of the client computer - Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 26
logon page is displayed. 2. Type your 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 on the screen - Lenovo ThinkPad G40 | 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 letter - Lenovo ThinkPad G40 | 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 G40 | 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 G40 | IBM System Information Center Administrator's Guide - Page 30
Adding and changing user asset data v Running the client agent v Submitting asset transfer requests v Downloading reports v Reviewing user asset revisions v Viewing for specific asset data v Updating additional asset information Can perform all of the tasks of the User and Super-User and has - Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 31
following procedure: 1. At the Logon window, type a User ID 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 - Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 32
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 Users. 3. Click All Users. 4. Mark the check box next to the user account you would like to alter - Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 33
Registering an asset requires filling out specific demographic information that is used to have to be permanently installed on the client computer to use this method. After the information is window, type your User ID and Password. 2. Click Submit. The System Information Center program is displayed - Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 34
and System Information Gatherer programs are installed and 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 System Information Center online help system. The - Lenovo ThinkPad G40 | 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 attached report to a target user or group of users. This task assumes that you have e-mail functionality enabled. The administrator can execute tasks IBM Corp. 2004 27 - Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 36
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 displayed. 2. In the System Information Center - Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 37
. Creating a CSV_FILE task To create a CSV_FILE task, 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 click Create New Task - Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 38
executing) an individual task 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 ID and Password. Click Submit. The System Information Center program is displayed. 30 - Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 39
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 click All Tasks. The All - Lenovo ThinkPad G40 | 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 Logon window, type your User ID and Password. Click Submit. The System Information Center program is displayed. 2. that help you generate information specific to your enterprise environment. This - Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 41
information about assets deployed with IBM ThinkVantage products as well as logs of IBM Rescue and Recovery operations. Users Provides information about specific user histories and other user information. Workstation Security Provides specific security information (such as passwords, firewalls - Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 42
and are useful if you need to generate reports that specifically meet the needs of your enterprise environment. You can create 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 - Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 43
a report automatically, custom reports are run manually after they are created. To generate a custom report, 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 - Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 44
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. The System Information Center program is displayed. 2. In the System Information Center - Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 45
window, type your User ID and Password. Click Submit. The System Information Center program is displayed section dictates the performance of a certain part of the System Information Center program. complete the following procedure: 1. Select the My Computer icon on your desktop. 2. Browse to C:\ - Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 46
set by default, but you can change what is selected. 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 delete a group v Customize reports v Search v Manage tasks v Reprocess scanned asset files - Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 47
users to establish their own password after receiving the computer-generated password. - Expire passwords after ___ days: Whether passwords should expire and when. v Password Creation Rules: - Enable tag code defined in your enterprise. - Asset Type: The type of asset. - Department: The department to - Lenovo ThinkPad G40 | 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 G40 | IBM System Information Center Administrator's Guide - Page 49
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 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 G40 | IBM System Information Center Administrator's Guide - Page 50
advanced functions, see the IBM System Information Center online help system. v Checking asset security: You can check security conditions of all client computers. v Viewing logs and server status: You can view application logs and server status to help diagnose a problem. v Interrupting the Task - Lenovo ThinkPad G40 | 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 G40 | IBM System Information Center Administrator's Guide - Page 52
44 - Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 53
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. The System Information Center program is displayed - Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 54
view to simplify printing the log. v 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 Submit. The System Information Center program is displayed. 2. In the System Information Center menu bar click - Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 55
Application Log. A File Download window is displayed. 4. Click Save to save the log to your computer. 5. Attach the log file to 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 - Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 56
48 - Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 57
. Using the Web The System Information Center Web site provides the latest technical information and any downloadable updates that IBM chooses to distribute. To visit the System Information Center Web site, go to: http://www-3.ibm.com/pc/support/site.wss/document.do?Indocid=MIGR-56187 © Copyright - Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 58
1. Go to http://www.ibm.com/pc/support/ 2. Click Support phone list. 3. Click ThinkVantage Technologies. Obtaining support Charges for support for the System Information Center program apply in the following way: Server code installed on IBM or non-IBM computers All telephone support is provided on - Lenovo ThinkPad G40 | 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 G40 | IBM System Information Center Administrator's Guide - Page 60
No If ″Yes,″ e-mail will be enabled; if ″No,″ e-mail will not be enabled smtp.server= Modifiable Field 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 - Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 61
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 http: should be replaced with https:. No other changes should be made to the default value. User-defined User-defined email.from= - Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 62
mail address of the administrator for reporting problems. User-defined User-defined upload.process.xml = Modifiable in a troubleshooting situation. upload.process.xml.max.queue = Modifiable Field Field Description Possible Values Value Definition upload.process.xml.max.queue Maximum number of - Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 63
Value Definition upload.save.eg2file = Modifiable Field Field Description Possible Values Value Definition upload.save.xmlfile = Modifiable Field Field Description Possible Values Value Definition upload.save.syslog = Modifiable Field Field Description Possible Values Value Definition upload.save. - Lenovo ThinkPad G40 | 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 G40 | 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 G40 | IBM System Information Center Administrator's Guide - Page 66
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 processing, tasks, = query.processed.incorrectly= query.asset.count= query.pc.asset.count= query.ibm.pc.asset.count= 58 - Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 67
Field Field Description Possible Values Value Definition max.keys Maximum number of results in a search (Note: setting this higher than 500 is not advised.) User-defined User-defined Category Description: Action Authority Settings update.password.auth=A Modifiable Field Field Description Possible - Lenovo ThinkPad G40 | 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 G40 | IBM System Information Center Administrator's Guide - Page 69
: asset.revisions = Modifiable Field 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 - Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 70
automatic uploads of asset information by the client agent. User-Defined User-Defined scheduled.upload.queue.threshold= Modifiable Field Field Description Possible Values Value Definition scheduled.upload.queue.threshold The maximum number of assets that will be processed before the server - Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 71
Description Possible Values Value Definition task.process.xml.max.queue.length The maximum number of processes (such as a task, upload, or an will be processed; beyond that number they will be stored. User-Defined User-Defined task.process.files.max.queue.length= Modifiable Field Field - Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 72
Definition expire.new.password Whether to require users to establish their own password after receiving the computer-generated password. True/False If ″True,″ users must establish their own password after receiving the computer-generated password; if ″No,″ users do not have to establish their own - Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 73
Possible Values Value Definition User-defined User-defined password.check= Modifiable Field Field Description Possible Values Value Definition password.check Whether to enable password rule checking. True/False If ″True,″ creation of passwords must follow certain rules; if ″False,″ creation of - Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 74
= Modifiable Field Field Description Possible Values Value Definition password.max.matching.sequential.chars Maximum number of sequential password characters that can match. User-defined User-defined password.max.previous.chars= Modifiable Field Field Description Possible Values Value Definition - Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 75
Values Value Definition asset.floor.required= Modifiable Field Field Description Possible Values Value Definition asset.location.required= Modifiable Field Whether the Asset Type field is required to be completed in order for an asset to be successfully added to the database. True/False If ″True - Lenovo ThinkPad G40 | 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 G40 | 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 G40 | 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 G40 | 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 G40 | 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 G40 | IBM System Information Center Administrator's Guide - Page 81
client computers is IBM System Information Center program checks and verifies that the hard disk drive for all client computers hard disk drives on all client computers hard disk drives on all client computers are password-protected. win.file.sharing During a security audit task the IBM computers - Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 82
account password is 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 - Lenovo ThinkPad G40 | 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 G40 | 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 G40 | 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 G40 | IBM System Information Center Administrator's Guide - Page 86
78 - Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 87
default, the IBM Cloudscape database provides several tables that can contain a variety of asset and user information. Understanding .Asset_Info Column Name HWKEY DESCRIPTION COMPANY LOCATION DEPARTMENT FLOOR Type Name INTEGER VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR Length 30 40 60 30 40 - Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 88
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 - Lenovo ThinkPad G40 | 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 Type Name INTEGER CHARACTER VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR - Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 90
VARCHAR DRIVE_MODEL VARCHAR DRIVE_FIRMWARE VARCHAR DRIVE_SERIAL_NO VARCHAR Table 12. Table: Asset.Lockout_Policy Column Name HWKEY REVISION L_THRESHOLD L_DURATION L_RESET Type Name INTEGER INTEGER INTEGER INTEGER INTEGER Table 13. Table: Asset.Lotus_Notes Column Name HWKEY REVISION PATH - Lenovo ThinkPad G40 | 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 G40 | IBM System Information Center Administrator's Guide - Page 92
TIMESTAMP Table 18. Table: Asset.PCI Column Name HWKEY REVISION BUS DEV FUNC SLOT VENDOR_ID VENDOR_NAME DEVICE_ID DEVICE_NAME CLASS SUB_CLASS Type Name INTEGER INTEGER INTEGER INTEGER INTEGER VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR Table 19. Table: Asset.Processor Column Name - Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 93
INTEGER INTEGER VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR Table 24. Table: Asset.Transfers Column Name HWKEY IS_PC_ASSET OLD_USERKEY NEW_USERKEY APPROVED Type Name INTEGER CHARACTER INTEGER INTEGER CHARACTER Length Nulls NO YES YES YES Length 1 Nulls NO NO NO NO Length 100 100 - Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 94
BIGINT CHARACTER BIGINT BIGINT BIGINT BIGINT VARCHAR INTEGER Table 27. Table: Asset.User_Accounts Column Name HWKEY REVISION USERID USERNAME PW_SET PW_AGE USER_PRIVILEGE Type Name INTEGER INTEGER VARCHAR VARCHAR VARCHAR INTEGER VARCHAR Length 30 30 Nulls NO YES NO YES Length 100 100 500 50 20 - Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 95
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 - Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 96
Table 29. Table: Asset.Users (continued) Column Name Type Name ADDRESS_2 VARCHAR TOWN VARCHAR 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 - Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 97
Name CUSTOM_QUERYKEY INTEGER USERKEY INTEGER Length Nulls NO NO Table 34. Table: Asset.Filestore Column Name HWKEY REVISION FILETYPE FILEDATA FILENAME MIMETYPE Type Name INTEGER INTEGER VARCHAR LONG BIT, VARYING VARCHAR VARCHAR Length 25 50 50 Nulls NO NO NO YES YES YES Table 35. Table - Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 98
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 CREATOR CREATED Type Name INTEGER VARCHAR VARCHAR LONG VARCHAR INTEGER CHARACTER - Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 99
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 VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR - Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 100
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 TIMESTAMP Table 44. Table: Asset.Task_Selected Column Name TASKKEY MENU_NAME DESCRIPTION - Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 101
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 VARCHAR VARCHAR VARCHAR CHARACTER INTEGER Length 100 100 Nulls NO NO NO Length 64 64 - Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 102
94 - Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 103
the user's responsibility to evaluate and verify the operation of any non-IBM product, program, or service. IBM might have 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 - Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 104
results may vary. Users of this document should verify the applicable 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 - Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 105
resource on client computer 3 online documentation 3 scheduling tasks 3 tracking asset status 3 tracking software entry-level license tracking 3 files ISIC.PROPERTIES 27, 37, 51 H help system 49 using 49 I IBM support, terms and duration 49 IBM Cloudscape 5 IBM Rescue and Recovery-Rapid Restore 17 - Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 106
user accounts and functions 21 using the Web 49 W Web browsers Microsoft Internet Explorer 6.0 3 Web-based technical support 49 Windows 2000 Server critical updates 6 installing 6 service packs 6 Windows Server 2003 critical updates 7 installing 6 service manually 30 sending a specialized e-mail - Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 107
- Lenovo ThinkPad G40 | IBM System Information Center Administrator's Guide - Page 108
Printed in USA
IBM
System
Information
Center
Administrator’s
Guide
±²³