How to check user's last login details?

Question

Hi, 
 Is there any table where user's last login details to webportal is stored?

Barry Jackson · Answer

Hi, 
 select * from DialogJournal where ApplicationName = 'Web Portal Runtime' order by MessageDate desc 
 By default, only failed logins will be recorded. 
 If you want to record successful logins you have to enable the config parm: Common\Journal\LoginAudit 
 Note: This will enable login logging for ALL applications - including the jobserver services. 
 HTH, Barry. 
 P.S. This assumes you are on V7 or above.

Barry Jackson · Answer

Hi, Looking at my 714 system I don't see 'web portal runtime' ..... I see a string containing 'ITShop' So I would adjust the query to: select * from dialogjournal where applicationname like '%itshop%' and messagestring like '%%' where is the id of the user you are looking to trace. HTH, Barry.

How to check user's last login details?

Top Replies