AnsweredAssumed Answered

Users Login/Logout History

Question asked by Gamze on Nov 7, 2017
Latest reply on Nov 7, 2017 by gayathrigupta

Dears,

 

I need users access information into the system(last Login / logout time). 

 

When I execute the sql query is below, the results aren't reasonable. Because I see the inactive user but it logged in the system. They can't login the system. 

---

SELECT ls.USER_ID,
csu.user_name

, csu.first_name+' '+csu.last_name Full_Name
, CONVERT(date,ls.created_date) Date_Of_Login
FROM log_sessions ls
INNER JOIN cmn_sec_users csu ON csu.id = ls.user_id
INNER JOIN SRM_RESOURCES res on csu.ID = res.ID

group by csu.user_name
, csu.first_name+' '+csu.last_name
,ls.USER_ID
,CONVERT(date,ls.created_date)
,res.FULL_NAME
order by CONVERT(date,ls.created_date) desc

---

I check this subject "Clarity PPM Login History " . I executed the query. I can't give any result.

 

How can I reach the users login informations?

 

Thanks.

Outcomes