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.