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: IEB.IEB_MMS_SERVERS#

Source

View Text - Preformatted


select MMSSVR_ID MMSSVR_ID, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, MMS_SERVER_NAME MMS_SERVER_NAME, ACTIVE_Y_N ACTIVE_Y_N, DESCRIPTION DESCRIPTION, COMMUNICATION_METHOD COMMUNICATION_METHOD, COM_OBJECT_NAME COM_OBJECT_NAME, COM_DNS_NAME COM_DNS_NAME, COM_IP_ADDRESS COM_IP_ADDRESS, COM_PORT_NUMBER COM_PORT_NUMBER, COM_PARAM1 COM_PARAM1, COM_PARAM2 COM_PARAM2, COM_PARAM3 COM_PARAM3, COM_PARAM4 COM_PARAM4, SECURITY_GROUP_ID SECURITY_GROUP_ID from "IEB"."IEB_MMS_SERVERS"

View Text - HTML Formatted

SELECT MMSSVR_ID MMSSVR_ID
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, MMS_SERVER_NAME MMS_SERVER_NAME
, ACTIVE_Y_N ACTIVE_Y_N
, DESCRIPTION DESCRIPTION
, COMMUNICATION_METHOD COMMUNICATION_METHOD
, COM_OBJECT_NAME COM_OBJECT_NAME
, COM_DNS_NAME COM_DNS_NAME
, COM_IP_ADDRESS COM_IP_ADDRESS
, COM_PORT_NUMBER COM_PORT_NUMBER
, COM_PARAM1 COM_PARAM1
, COM_PARAM2 COM_PARAM2
, COM_PARAM3 COM_PARAM3
, COM_PARAM4 COM_PARAM4
, SECURITY_GROUP_ID SECURITY_GROUP_ID
FROM "IEB"."IEB_MMS_SERVERS"