Lenovo ThinkPad R40 IBM System Information Center Administrator's Guide - Page 96
Internal, system, tables
View all Lenovo ThinkPad R40 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