com.tivoli.twg.inventory
Class TWGSystemLocationTable
java.lang.Object
com.tivoli.twg.engine.TWGObject
com.tivoli.twg.engine.TWGPersistentObject
com.tivoli.twg.engine.TWGDatabaseTable
com.tivoli.twg.inventory.TWGSystemLocationTable
- public class TWGSystemLocationTable
- extends TWGDatabaseTable
SQL database table for System Location information
Primary key - MANAGED_OBJ_ID
TWG_SYSTEM_LOCATION |
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 |
CITY | CHAR(32) | City |
X | X | X | | | | X | X | X | X | X |
STATE | CHAR(32) | State |
X | X | X | | | | X | X | X | X | X |
ZIPCODE | CHAR(16) | Zip code |
X | X | X | | | | X | X | X | X | X |
COUNTRY | CHAR(32) | Country |
X | X | X | | | | X | X | X | X | X |
ROOM_NUMBER | CHAR(32) | Room number |
X | X | X | | | | X | X | X | X | X |
BUILDING | CHAR(32) | Building |
X | X | X | | | | X | X | X | X | X |
FLOOR | CHAR(32) | Floor |
X | X | X | | | | X | X | X | X | X |
LATITUDE | CHAR(32) | Latitude |
X | X | X | | | | X | X | X | X | X |
LONGITUDE | CHAR(32) | Longitude |
X | X | X | | | | X | X | X | X | X |
USER_DATA1 | CHAR(255) | User specific data 1 |
X | X | X | | | | X | X | X | X | X |
USER_DATA2 | CHAR(255) | User specific data 2 |
X | X | X | | | | X | X | X | X | X |
Note: For NT/2000 and 95/98, these fields are populated only if the client manually updates twguser.ini in \TivoliWg\data
Note: For OS/2, these fields are populated only if the client manually updates twguser.ini in \TivoliWg
Note: For AIX, these fields are populated only if the client manually updates TWGUser.properties in /usr/opt/tivoliwg/data
Note: For HPUX, Solaris, Unixware, Linux, these fields are populated only if the client manually updates TWGUser.properties in /opt/tivoliwg/data
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 |
TABLE_NAME
public static final java.lang.String TABLE_NAME
- See Also:
- Constant Field Values
SHORT_TABLE_NAME
public static final java.lang.String SHORT_TABLE_NAME
- See Also:
- Constant Field Values
MANAGED_OBJ_ID
public static final java.lang.String MANAGED_OBJ_ID
- See Also:
- Constant Field Values
CITY
public static final java.lang.String CITY
- See Also:
- Constant Field Values
STATE
public static final java.lang.String STATE
- See Also:
- Constant Field Values
ZIPCODE
public static final java.lang.String ZIPCODE
- See Also:
- Constant Field Values
COUNTRY
public static final java.lang.String COUNTRY
- See Also:
- Constant Field Values
ROOM_NUMBER
public static final java.lang.String ROOM_NUMBER
- See Also:
- Constant Field Values
BUILDING
public static final java.lang.String BUILDING
- See Also:
- Constant Field Values
FLOOR
public static final java.lang.String FLOOR
- See Also:
- Constant Field Values
LATITUDE
public static final java.lang.String LATITUDE
- See Also:
- Constant Field Values
LONGITUDE
public static final java.lang.String LONGITUDE
- See Also:
- Constant Field Values
USER_DATA1
public static final java.lang.String USER_DATA1
- See Also:
- Constant Field Values
USER_DATA2
public static final java.lang.String USER_DATA2
- See Also:
- Constant Field Values
TABLE_VERSION
public static final java.lang.String TABLE_VERSION
- See Also:
- Constant Field Values
TWGSystemLocationTable
public TWGSystemLocationTable()
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