com.tivoli.twg.inventory
Class TWGProcessorTable

java.lang.Object
  extended bycom.tivoli.twg.engine.TWGObject
      extended bycom.tivoli.twg.engine.TWGPersistentObject
          extended bycom.tivoli.twg.engine.TWGDatabaseTable
              extended bycom.tivoli.twg.inventory.TWGProcessorTable

public class TWGProcessorTable
extends TWGDatabaseTable

SQL database table for Processor information

Primary key - MANAGED_OBJ_ID, PROCESSOR_INDEX

TWG_PROCESSOR
Field Name Data Type Description NT/2000 95/98 OS/2 Netware AS/400 SNMP AIX HPUX Solaris Unixware Linux
MANAGED_OBJ_ID INT Managed object id X X X X X X X X X X
PROCESSOR_INDEX INT Processor index X X X X X X X X X X
PROCESSOR_TYPE CHAR(32) Processor type - ENUM3 X X X X X X X X X X
FAMILY CHAR(32) Processor family - ENUM4 X X X X X X X X X X
VERSION CHAR(80) Processor version X X X X X X X X X X
MAXIMUM_SPEED INT Maximum speed of installed processor in MHz1 X X X X X X X X
CURRENT_SPEED INT Current speed of installed processor in MHz1 X X X X X X X X
INTERNAL_CACHE CHAR(20) Internal processor cache - ENUM2 X X X X X
EXTERNAL_CACHE CHAR(20) External processor cache - ENUM2 X X X X X
PROCESSOR_SERIAL CHAR(40) Processor serial number5 X X X X X
VIRT_ADDRESS CHAR(2) Virtual CPU Address X X X X X
VIRT_CPUID CHAR(6) CPUID of virtual cpu X X X X X
BASE_CPU CHAR(10) Is this the CPU Base? X X X X X
DEDICATED CHAR(10) Real Dedicated X X X X X

1 Note: Speeds collected are sometimes approximate values
2 Note: Data values like INTERNAL_CACHE_* or EXTERNAL_CACHE_*; see static variables below
3 Note: Data values like PROCESSOR_TYPE_*; see static variables below
4 Note: Data values like FAMILY_*; see static variables below
5 Note: Only available for Pentium processors with BIOS support enabled


Field Summary
static java.lang.String BASE_CPU
           
static java.lang.String CURRENT_SPEED
           
static java.lang.String DEDICATED
           
static java.lang.String EXTERNAL_CACHE
           
static java.lang.String EXTERNAL_CACHE_DISABLED
           
static java.lang.String EXTERNAL_CACHE_ENABLED
           
static java.lang.String EXTERNAL_CACHE_NOT_INSTALLED
           
static java.lang.String EXTERNAL_CACHE_UNKNOWN
           
static java.lang.String FAMILY
           
static java.lang.String FAMILY_68000
           
static java.lang.String FAMILY_68010
           
static java.lang.String FAMILY_68020
           
static java.lang.String FAMILY_68030
           
static java.lang.String FAMILY_68040
           
static java.lang.String FAMILY_68XXX
           
static java.lang.String FAMILY_80286
           
static java.lang.String FAMILY_80287
           
static java.lang.String FAMILY_80386
           
static java.lang.String FAMILY_80387
           
static java.lang.String FAMILY_80486
           
static java.lang.String FAMILY_80487
           
static java.lang.String FAMILY_8086
           
static java.lang.String FAMILY_8087
           
static java.lang.String FAMILY_ALPHA
           
static java.lang.String FAMILY_AMDK5
           
static java.lang.String FAMILY_AMDK6
           
static java.lang.String FAMILY_AMDK7
           
static java.lang.String FAMILY_AMDOPTERON
           
static java.lang.String FAMILY_CELERON
           
static java.lang.String FAMILY_CYRIX
           
static java.lang.String FAMILY_HOBBIT
           
static java.lang.String FAMILY_ITANIUM
           
static java.lang.String FAMILY_ITANIUM2
           
static java.lang.String FAMILY_M1
           
static java.lang.String FAMILY_MIPS
           
static java.lang.String FAMILY_OTHER
           
static java.lang.String FAMILY_PARISC
           
static java.lang.String FAMILY_PENTIUM
           
static java.lang.String FAMILY_PENTIUM4
           
static java.lang.String FAMILY_PENTIUM4XEON
           
static java.lang.String FAMILY_PENTIUMII
           
static java.lang.String FAMILY_PENTIUMIII
           
static java.lang.String FAMILY_PENTIUMIIIXEON
           
static java.lang.String FAMILY_PENTIUMIIXEON
           
static java.lang.String FAMILY_PENTIUMPRO
           
static java.lang.String FAMILY_POWERPC
           
static java.lang.String FAMILY_POWERPC601
           
static java.lang.String FAMILY_POWERPC603
           
static java.lang.String FAMILY_POWERPC603PLUS
           
static java.lang.String FAMILY_POWERPC604
           
static java.lang.String FAMILY_SPARC
           
static java.lang.String FAMILY_UNKNOWN
           
static java.lang.String FAMILY_V30
           
static java.lang.String FAMILY_WEITEK
           
static java.lang.String INTERNAL_CACHE
           
static java.lang.String INTERNAL_CACHE_DISABLED
           
static java.lang.String INTERNAL_CACHE_ENABLED
           
static java.lang.String INTERNAL_CACHE_NOT_INSTALLED
           
static java.lang.String INTERNAL_CACHE_UNKNOWN
           
static java.lang.String MANAGED_OBJ_ID
           
static java.lang.String MAXIMUM_SPEED
           
static java.lang.String PROCESSOR_INDEX
           
static java.lang.String PROCESSOR_SERIAL
           
static java.lang.String PROCESSOR_TYPE
           
static java.lang.String PROCESSOR_TYPE_CPU
           
static java.lang.String PROCESSOR_TYPE_DSP
           
static java.lang.String PROCESSOR_TYPE_MATH
           
static java.lang.String PROCESSOR_TYPE_OTHER
           
static java.lang.String PROCESSOR_TYPE_UNKNOWN
           
static java.lang.String PROCESSOR_TYPE_VIDEO
           
static java.lang.String TABLE_NAME
           
static java.lang.String TABLE_VERSION
           
static java.lang.String VERSION
           
static java.lang.String VIRT_ADDRESS
           
static java.lang.String VIRT_CPUID
           
 
Fields inherited from class com.tivoli.twg.engine.TWGDatabaseTable
CLASSNAME, DbKeyWords, DEFAULT_TABLE_BUNDLE_NAME, validChars
 
Fields inherited from class com.tivoli.twg.engine.TWGPersistentObject
CLASS_NAME, SIZEOF_BYTE, SIZEOF_CHAR, SIZEOF_DOUBLE, SIZEOF_FLOAT, SIZEOF_INT, SIZEOF_LONG, SIZEOF_SHORT
 
Constructor Summary
TWGProcessorTable()
           
 
Method Summary
 void create()
          Abstract method must be overriden by subclass to define the table.
 java.lang.String getTableVersion()
          Abstract method must be overriden by subclass to get the version for table
 
Methods inherited from class com.tivoli.twg.engine.TWGDatabaseTable
deleteManagedObject, deleteTable, findTableByClassName, flatten, getAllFullColumnNames, getAllTrue, getAllTrueForSame, getAnyTrue, getBundleName, getBundleString, getColumn, getColumnByColumnRealName, getColumnLength, getColumnLength, getColumnLengths, getColumns, getColumnType, getColumnType, getColumnTypes, getDatabase, getDefaultValue, getDefaultValue, getDefaultValues, getDisplayColumnName, getDisplayFullColumnNames, getDisplayName, getDisplayValues, getEachTrueForAtLeastOne, getFilterColumns, getFilterPrompt, getFilterSQL, getGraphicName, getKey, getMatchingMoids, getMultiLocaleBundle, getMyClassName, getNumberOfColumns, getRealColumnName, getRealColumnName, getRealColumnNames, getRealName, getShortClassName, getTable, getTableBy, getTableByRealTableName, getTableInfo, getTableMultiLocaleBundle, getTableName, getTables, getTokenColumnNames, getTokenName, insertOrDeleteRow, insertRow, isFilterColumn, isMappedColumn, restoreData, saveData, setShortTableName, toString, TWGInitTable, userTableFixClassName
 
Methods inherited from class com.tivoli.twg.engine.TWGPersistentObject
Destroy, enableAsyncWrites, fromPersistID, initialize, isNewPersistentStore, isSaveRequired, PersistID, restore, restoreAll, save, save, setSaveRequired, terminate, toPersistID
 
Methods inherited from class com.tivoli.twg.engine.TWGObject
AllObjects, AllObjects, Delete, DumpTWGObjects, FindObject, isDeleted, isNewObject, isPersistent, isPersistent, isValid, isValid, ObjectID, setDistinctObjectID, SetObjectID
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait
 

Field Detail

TABLE_NAME

public static final java.lang.String TABLE_NAME
See Also:
Constant Field Values

MANAGED_OBJ_ID

public static final java.lang.String MANAGED_OBJ_ID
See Also:
Constant Field Values

PROCESSOR_INDEX

public static final java.lang.String PROCESSOR_INDEX
See Also:
Constant Field Values

PROCESSOR_TYPE

public static final java.lang.String PROCESSOR_TYPE
See Also:
Constant Field Values

FAMILY

public static final java.lang.String FAMILY
See Also:
Constant Field Values

VERSION

public static final java.lang.String VERSION
See Also:
Constant Field Values

MAXIMUM_SPEED

public static final java.lang.String MAXIMUM_SPEED
See Also:
Constant Field Values

CURRENT_SPEED

public static final java.lang.String CURRENT_SPEED
See Also:
Constant Field Values

INTERNAL_CACHE

public static final java.lang.String INTERNAL_CACHE
See Also:
Constant Field Values

EXTERNAL_CACHE

public static final java.lang.String EXTERNAL_CACHE
See Also:
Constant Field Values

PROCESSOR_SERIAL

public static final java.lang.String PROCESSOR_SERIAL
See Also:
Constant Field Values

VIRT_ADDRESS

public static final java.lang.String VIRT_ADDRESS
See Also:
Constant Field Values

VIRT_CPUID

public static final java.lang.String VIRT_CPUID
See Also:
Constant Field Values

BASE_CPU

public static final java.lang.String BASE_CPU
See Also:
Constant Field Values

DEDICATED

public static final java.lang.String DEDICATED
See Also:
Constant Field Values

PROCESSOR_TYPE_OTHER

public static final java.lang.String PROCESSOR_TYPE_OTHER
See Also:
Constant Field Values

PROCESSOR_TYPE_CPU

public static final java.lang.String PROCESSOR_TYPE_CPU
See Also:
Constant Field Values

PROCESSOR_TYPE_MATH

public static final java.lang.String PROCESSOR_TYPE_MATH
See Also:
Constant Field Values

PROCESSOR_TYPE_DSP

public static final java.lang.String PROCESSOR_TYPE_DSP
See Also:
Constant Field Values

PROCESSOR_TYPE_VIDEO

public static final java.lang.String PROCESSOR_TYPE_VIDEO
See Also:
Constant Field Values

PROCESSOR_TYPE_UNKNOWN

public static final java.lang.String PROCESSOR_TYPE_UNKNOWN
See Also:
Constant Field Values

FAMILY_OTHER

public static final java.lang.String FAMILY_OTHER
See Also:
Constant Field Values

FAMILY_UNKNOWN

public static final java.lang.String FAMILY_UNKNOWN
See Also:
Constant Field Values

FAMILY_8086

public static final java.lang.String FAMILY_8086
See Also:
Constant Field Values

FAMILY_80286

public static final java.lang.String FAMILY_80286
See Also:
Constant Field Values

FAMILY_80386

public static final java.lang.String FAMILY_80386
See Also:
Constant Field Values

FAMILY_80486

public static final java.lang.String FAMILY_80486
See Also:
Constant Field Values

FAMILY_8087

public static final java.lang.String FAMILY_8087
See Also:
Constant Field Values

FAMILY_80287

public static final java.lang.String FAMILY_80287
See Also:
Constant Field Values

FAMILY_80387

public static final java.lang.String FAMILY_80387
See Also:
Constant Field Values

FAMILY_80487

public static final java.lang.String FAMILY_80487
See Also:
Constant Field Values

FAMILY_PENTIUM

public static final java.lang.String FAMILY_PENTIUM
See Also:
Constant Field Values

FAMILY_PENTIUMPRO

public static final java.lang.String FAMILY_PENTIUMPRO
See Also:
Constant Field Values

FAMILY_PENTIUMII

public static final java.lang.String FAMILY_PENTIUMII
See Also:
Constant Field Values

FAMILY_PENTIUMIII

public static final java.lang.String FAMILY_PENTIUMIII
See Also:
Constant Field Values

FAMILY_PENTIUM4

public static final java.lang.String FAMILY_PENTIUM4
See Also:
Constant Field Values

FAMILY_M1

public static final java.lang.String FAMILY_M1
See Also:
Constant Field Values

FAMILY_POWERPC

public static final java.lang.String FAMILY_POWERPC
See Also:
Constant Field Values

FAMILY_POWERPC601

public static final java.lang.String FAMILY_POWERPC601
See Also:
Constant Field Values

FAMILY_POWERPC603

public static final java.lang.String FAMILY_POWERPC603
See Also:
Constant Field Values

FAMILY_POWERPC603PLUS

public static final java.lang.String FAMILY_POWERPC603PLUS
See Also:
Constant Field Values

FAMILY_POWERPC604

public static final java.lang.String FAMILY_POWERPC604
See Also:
Constant Field Values

FAMILY_ALPHA

public static final java.lang.String FAMILY_ALPHA
See Also:
Constant Field Values

FAMILY_MIPS

public static final java.lang.String FAMILY_MIPS
See Also:
Constant Field Values

FAMILY_SPARC

public static final java.lang.String FAMILY_SPARC
See Also:
Constant Field Values

FAMILY_68040

public static final java.lang.String FAMILY_68040
See Also:
Constant Field Values

FAMILY_68XXX

public static final java.lang.String FAMILY_68XXX
See Also:
Constant Field Values

FAMILY_68000

public static final java.lang.String FAMILY_68000
See Also:
Constant Field Values

FAMILY_68010

public static final java.lang.String FAMILY_68010
See Also:
Constant Field Values

FAMILY_68020

public static final java.lang.String FAMILY_68020
See Also:
Constant Field Values

FAMILY_68030

public static final java.lang.String FAMILY_68030
See Also:
Constant Field Values

FAMILY_HOBBIT

public static final java.lang.String FAMILY_HOBBIT
See Also:
Constant Field Values

FAMILY_WEITEK

public static final java.lang.String FAMILY_WEITEK
See Also:
Constant Field Values

FAMILY_PARISC

public static final java.lang.String FAMILY_PARISC
See Also:
Constant Field Values

FAMILY_V30

public static final java.lang.String FAMILY_V30
See Also:
Constant Field Values

FAMILY_CYRIX

public static final java.lang.String FAMILY_CYRIX
See Also:
Constant Field Values

FAMILY_AMDK5

public static final java.lang.String FAMILY_AMDK5
See Also:
Constant Field Values

FAMILY_AMDK6

public static final java.lang.String FAMILY_AMDK6
See Also:
Constant Field Values

FAMILY_PENTIUMIIXEON

public static final java.lang.String FAMILY_PENTIUMIIXEON
See Also:
Constant Field Values

FAMILY_PENTIUMIIIXEON

public static final java.lang.String FAMILY_PENTIUMIIIXEON
See Also:
Constant Field Values

FAMILY_PENTIUM4XEON

public static final java.lang.String FAMILY_PENTIUM4XEON
See Also:
Constant Field Values

FAMILY_CELERON

public static final java.lang.String FAMILY_CELERON
See Also:
Constant Field Values

FAMILY_AMDK7

public static final java.lang.String FAMILY_AMDK7
See Also:
Constant Field Values

FAMILY_ITANIUM

public static final java.lang.String FAMILY_ITANIUM
See Also:
Constant Field Values

FAMILY_ITANIUM2

public static final java.lang.String FAMILY_ITANIUM2
See Also:
Constant Field Values

FAMILY_AMDOPTERON

public static final java.lang.String FAMILY_AMDOPTERON
See Also:
Constant Field Values

INTERNAL_CACHE_DISABLED

public static final java.lang.String INTERNAL_CACHE_DISABLED
See Also:
Constant Field Values

INTERNAL_CACHE_ENABLED

public static final java.lang.String INTERNAL_CACHE_ENABLED
See Also:
Constant Field Values

INTERNAL_CACHE_NOT_INSTALLED

public static final java.lang.String INTERNAL_CACHE_NOT_INSTALLED
See Also:
Constant Field Values

INTERNAL_CACHE_UNKNOWN

public static final java.lang.String INTERNAL_CACHE_UNKNOWN
See Also:
Constant Field Values

EXTERNAL_CACHE_DISABLED

public static final java.lang.String EXTERNAL_CACHE_DISABLED
See Also:
Constant Field Values

EXTERNAL_CACHE_ENABLED

public static final java.lang.String EXTERNAL_CACHE_ENABLED
See Also:
Constant Field Values

EXTERNAL_CACHE_NOT_INSTALLED

public static final java.lang.String EXTERNAL_CACHE_NOT_INSTALLED
See Also:
Constant Field Values

EXTERNAL_CACHE_UNKNOWN

public static final java.lang.String EXTERNAL_CACHE_UNKNOWN
See Also:
Constant Field Values

TABLE_VERSION

public static final java.lang.String TABLE_VERSION
See Also:
Constant Field Values
Constructor Detail

TWGProcessorTable

public TWGProcessorTable()
Method Detail

create

public void create()
            throws TWGDbException
Description copied from class: TWGDatabaseTable
Abstract method must be overriden by subclass to define the table.

Specified by:
create in class TWGDatabaseTable
Throws:
TWGDbException

getTableVersion

public java.lang.String getTableVersion()
Description copied from class: TWGDatabaseTable
Abstract method must be overriden by subclass to get the version for table

Specified by:
getTableVersion in class TWGDatabaseTable
Returns:
the version id for this table