eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: AHM_HST_DB_V

Product:	AHM - Hosting Manager(Obsolete)
Description:	View on which databases hold which SECURITY_GROUP_IDs
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT B.DB_ID
, A.DB_NAME
, A.DB_TYPE
, A.HOSTNAME
, A.MAX_SLOTS
, A.MID_TIER_URL
, A.PORT
, A.SID
, A.HOSTED_DATABASE
, A.INSTANCE_NAME
, B.SLOT_ID
, B.SECURITY_GROUP_ID
, B.SLOT_TYPE_ID
, B.SLOT_STATUS
FROM AHM_SLOT_ALLOCATIONS B
, AHM_HOST_DATABASES_VL A
WHERE A.DB_ID=B.DB_ID

Columns

Name
DB_ID
DB_NAME
DB_TYPE
HOSTNAME
MAX_SLOTS
MID_TIER_URL
PORT
SID
HOSTED_DATABASE
INSTANCE_NAME
SLOT_ID
SECURITY_GROUP_ID
SLOT_TYPE_ID
SLOT_STATUS