Hi,
Please some one help me in how to fetch user last login details using dql query
Regards,
Mars
You can find the attribute in dm_user table for last login details.
Kiran
Of course I got this attribute namely "last_login_utc_time" but it is not showing correct time I think so.
I think it is showing the time of the Content Server, pls check it once.
You can also turn on the dm_connect event in the audit trail for the type dm_user.
After that you can get some information in the user login history with this query:
select user_name, string_4 as host, string_5 as ip, time_stamp from dm_audittrail where event_name = 'dm_connect' and user_name='<user name>'
