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.

VIEW: ASG.ASG_DEVICE_USERS#

Source

View Text - Preformatted


select DEVICE_USER_ID DEVICE_USER_ID, RESOURCE_ID RESOURCE_ID, MOBILE_APPLICATION_ID MOBILE_APPLICATION_ID, CLIENT_NUMBER CLIENT_NUMBER, CLIENT_NAME CLIENT_NAME, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, ORG_ID ORG_ID, DEVICE_TAG DEVICE_TAG, USER_ID USER_ID, SERVER_ID SERVER_ID, LAST_SYNCH_MODE LAST_SYNCH_MODE, ENABLED ENABLED, UPGRADE UPGRADE, REMOTE_DEVICE_NAME REMOTE_DEVICE_NAME, ADDRESS_DEVICE_TYPE ADDRESS_DEVICE_TYPE, ADDRESS_DEVICE_NAME ADDRESS_DEVICE_NAME, ONAIR_FLAG ONAIR_FLAG, LAST_SYNC_DATE LAST_SYNC_DATE, LAST_WIRELESS_CONTACT_DATE LAST_WIRELESS_CONTACT_DATE, RETRY_DATE RETRY_DATE, BYTES_SENT_WIRELESS BYTES_SENT_WIRELESS, BYTES_RECEIVED_WIRELESS BYTES_RECEIVED_WIRELESS, DEVICE_LOCKED DEVICE_LOCKED, ACCESS_CODE ACCESS_CODE, LANGUAGE LANGUAGE, FLASH_MESSAGE_FLAG FLASH_MESSAGE_FLAG, COOKIE COOKIE, ORGANIZATION_ID ORGANIZATION_ID, NEW_DATA_FLAG NEW_DATA_FLAG, NEW_DATA_DATE NEW_DATA_DATE, SECURITY_GROUP_ID SECURITY_GROUP_ID from "ASG"."ASG_DEVICE_USERS"

View Text - HTML Formatted

SELECT DEVICE_USER_ID DEVICE_USER_ID
, RESOURCE_ID RESOURCE_ID
, MOBILE_APPLICATION_ID MOBILE_APPLICATION_ID
, CLIENT_NUMBER CLIENT_NUMBER
, CLIENT_NAME CLIENT_NAME
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, ORG_ID ORG_ID
, DEVICE_TAG DEVICE_TAG
, USER_ID USER_ID
, SERVER_ID SERVER_ID
, LAST_SYNCH_MODE LAST_SYNCH_MODE
, ENABLED ENABLED
, UPGRADE UPGRADE
, REMOTE_DEVICE_NAME REMOTE_DEVICE_NAME
, ADDRESS_DEVICE_TYPE ADDRESS_DEVICE_TYPE
, ADDRESS_DEVICE_NAME ADDRESS_DEVICE_NAME
, ONAIR_FLAG ONAIR_FLAG
, LAST_SYNC_DATE LAST_SYNC_DATE
, LAST_WIRELESS_CONTACT_DATE LAST_WIRELESS_CONTACT_DATE
, RETRY_DATE RETRY_DATE
, BYTES_SENT_WIRELESS BYTES_SENT_WIRELESS
, BYTES_RECEIVED_WIRELESS BYTES_RECEIVED_WIRELESS
, DEVICE_LOCKED DEVICE_LOCKED
, ACCESS_CODE ACCESS_CODE
, LANGUAGE LANGUAGE
, FLASH_MESSAGE_FLAG FLASH_MESSAGE_FLAG
, COOKIE COOKIE
, ORGANIZATION_ID ORGANIZATION_ID
, NEW_DATA_FLAG NEW_DATA_FLAG
, NEW_DATA_DATE NEW_DATA_DATE
, SECURITY_GROUP_ID SECURITY_GROUP_ID
FROM "ASG"."ASG_DEVICE_USERS"