[Home] [Help]
View: ASG_USER_VERSIONS
View Text
SELECT D.DEVICE_USER_ID
, D.CLIENT_NAME
, D.MOBILE_APPLICATION_ID
, D.USER_ID
, D.RESOURCE_ID
, S.SERVER_ID
, S.SNAP_DATABASE
, P.RELEASE_VERSION
, P.COMPATIBLE_VERSION
FROM ASG_DEVICE_USERS D
, ASG_SYNCH_SERVER S
, ASG_SERVER_PUBS P
, ASG_APPLICATIONS_B A
, ASG_PUBLICATIONS PUB
WHERE D.SERVER_ID = S.SERVER_ID
AND D.MOBILE_APPLICATION_ID = A.MOBILE_APPLICATION_ID
AND P.SERVER_ID = D.SERVER_ID
AND A.APPLICATION_CODE = PUB.NAME
AND P.PUBLICATION_ID = PUB.PUBLICATION_ID
Columns
Name |
DEVICE_USER_ID |
CLIENT_NAME |
MOBILE_APPLICATION_ID |
USER_ID |
RESOURCE_ID |
SERVER_ID |
SNAP_DATABASE |
RELEASE_VERSION |
COMPATIBLE_VERSION |