com.tivoli.twg.inventory
Class TWGScsiDeviceTable

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.TWGScsiDeviceTable

public class TWGScsiDeviceTable
extends TWGDatabaseTable

SQL database table for SCSI Device information

Primary key - MANAGED_OBJ_ID, SCSI_ADAPTER_INDEX, SCSI_DEVICE_INDEX

TWG_SCSI_DEVICE
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
SCSI_ADAPTER_INDEX INT Adapter index X
SCSI_DEVICE_INDEX INT Device index X
PUN INT Physical unit number X
LUN INT Logical unit number X
DEVICE_TYPE CHAR(32) Device Type - FIXED DISK, CD-ROM ENUM1 X
DEVICE_SIZE INT Device size X
VENDOR_ID CHAR(40) Vendor ID X
PRODUCT_ID CHAR(40) Product ID X
PRODUCT_REVISION_LEVEL CHAR(40) Product revision level X
VENDOR_STRING CHAR(255) Vendor name X
VENDOR_DATA CHAR(255) Vendor data X
SERIAL_NUMBER CHAR(40) Serial number X

1 Note: Data values like DEVICE_TYPE_*; see static variables below


Field Summary
static java.lang.String DEVICE_SIZE
           
static java.lang.String DEVICE_TYPE
           
static java.lang.String DEVICE_TYPE_CDROM
           
static java.lang.String DEVICE_TYPE_DASD
           
static java.lang.String DEVICE_TYPE_FIXED
           
static java.lang.String DEVICE_TYPE_MODEM
           
static java.lang.String DEVICE_TYPE_OPTICAL_DISK
           
static java.lang.String DEVICE_TYPE_OTHER
           
static java.lang.String DEVICE_TYPE_PRINTER
           
static java.lang.String DEVICE_TYPE_PROCESSOR
           
static java.lang.String DEVICE_TYPE_SCANNER
           
static java.lang.String DEVICE_TYPE_TAPE
           
static java.lang.String DEVICE_TYPE_UNKNOWN
           
static java.lang.String DEVICE_TYPE_WORM
           
static java.lang.String LUN
           
static java.lang.String MANAGED_OBJ_ID
           
static java.lang.String PRODUCT_ID
           
static java.lang.String PRODUCT_REVISION_LEVEL
           
static java.lang.String PUN
           
static java.lang.String SCSI_ADAPTER_INDEX
           
static java.lang.String SCSI_DEVICE_INDEX
           
static java.lang.String SERIAL_NUMBER
           
static java.lang.String SHORT_PRODUCT_REVISION_LEVEL
           
static java.lang.String TABLE_NAME
           
static java.lang.String TABLE_VERSION
           
static java.lang.String VENDOR_DATA
           
static java.lang.String VENDOR_ID
           
static java.lang.String VENDOR_STRING
           
 
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
TWGScsiDeviceTable()
           
 
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

SCSI_ADAPTER_INDEX

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

SCSI_DEVICE_INDEX

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

PUN

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

LUN

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

DEVICE_TYPE

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

DEVICE_SIZE

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

VENDOR_ID

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

PRODUCT_ID

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

PRODUCT_REVISION_LEVEL

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

SHORT_PRODUCT_REVISION_LEVEL

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

VENDOR_STRING

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

VENDOR_DATA

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

SERIAL_NUMBER

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

DEVICE_TYPE_OTHER

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

DEVICE_TYPE_UNKNOWN

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

DEVICE_TYPE_DASD

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

DEVICE_TYPE_FIXED

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

DEVICE_TYPE_TAPE

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

DEVICE_TYPE_PRINTER

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

DEVICE_TYPE_PROCESSOR

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

DEVICE_TYPE_WORM

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

DEVICE_TYPE_CDROM

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

DEVICE_TYPE_SCANNER

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

DEVICE_TYPE_OPTICAL_DISK

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

DEVICE_TYPE_MODEM

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

TABLE_VERSION

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

TWGScsiDeviceTable

public TWGScsiDeviceTable()
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