VERIFIED SOLUTION i

Determining login time of user(s) in Portrait Dialogue

Following query will retrieve 'User Name' and 'Login Datetime'  from Portrait Dialogue system database. The query works on SQL Server as well as on Oracle database.
SELECT SYSTEM_USER_INFO.SUI_USER_NAME, SYSTEM_USER_SESSION.SUS_LOGIN_DATETIME,
SYSTEM_USER_SESSION.SUS_USING_WIN_AUTH FROM SYSTEM_USER_SESSION,SYSTEM_USER_INFO 
WHERE SYSTEM_USER_INFO.SUI_ID = SYSTEM_USER_SESSION.SUS_SUI_ID   
AND SYSTEM_USER_INFO.SUI_USER_NAME <> 'INTERNAL'
UPDATED:  August 8, 2018