user last login details

S.Maruthi
S.Maruthi
edited March 1, 2012 in Documentum #1

Hi,

Please some one help me in how to fetch user last login details using dql query

Regards,

Mars

Tagged:

Comments

  • Thota
    Thota
    edited March 1, 2012 #2

    You can find the attribute in dm_user table for last login details.

    Regards,

    Kiran

  • S.Maruthi
    S.Maruthi
    edited March 1, 2012 #3

    Of course I got this attribute namely "last_login_utc_time" but it is not showing correct time I think so.

  • Thota
    Thota
    edited March 1, 2012 #4

    I think it is showing the time of the Content Server, pls check it once.

  • adalbero
    adalbero
    edited March 1, 2012 #5

    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>'

Categories