Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
2 rsolanki 1 
/* Login Trail */
2 
SELECT DECODE( lt.ENUM_EVENT,
3 
	   		   1,  'LIMG_LOGON_SUCCESS',
4 
			   -1, 'LIMG_LOGON_FAIL',
5 
			   0,  'LIMG_LOGOFF',
6 
			   2,  'LIMG_SESSION_EXPIRE') AS event_icon,
7 
	   lt.USER_NAME,
8 
	   usr.USER_ID,
9 
	   usr.FULL_NAME,
10 
	   lt.CLIENT_IP,
11 
	   app.APP_ID,
12 
	   app.APPLICATION_NAME,
13 
	   lt.STAMP,
14 
	   lt.COMMENTS
15 
  FROM LOGIN_TRAIL lt,
16 
  	   APPLICATIONS app,
17 
	   USERS usr
18 
 WHERE lt.APP_ID = app.APP_ID (+)
19 
   AND lt.USER_NAME = usr.USER_NAME (+)
20 
ORDER BY lt.STAMP DESC