Hi,
Is there any table where user's last login details to webportal is stored?
Hi,
Is there any table where user's last login details to webportal is stored?
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.
Can we check last login of specific user?
Can we check last login of specific user?
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 '%<your user id>%'
where <your user id> is the id of the user you are looking to trace.
HTH, Barry.
Hi,
I am not able to see the user id record though I can see that the success login is getting recorded. We are using OAuth/OpenId(role based) module for authentication. And I can see below values in DialogJournal table.
Applicationname : /LM/W3SVC/1/ROOT/IM360-1-131961765361415148
MessageString : #LDS#Login succeeded for module {0}, properties: {1}, identity: {2}, client machine: {3}|OAuth 2.0 / OpenID Connect (role based)||-|10.0.0.10
So what version are you using? In addition, your IDP should know who has logged in, shouldn't he?