I,'m using DQL to query users last login time, but I saw some users'last login time is "nulldate", however the others' last login time displays correctly. Why and how to fix it?
thanks
Are you sure that those users have actually logged in before? Last login date is not the same as when the user account was created either manually or by LDAP/AD sync.
As we understand, when a user account is created with in Documentum, current system time should be set as last_login_utc_time. How ever, it does not seem to be the case. Can someone please clarify what could be causing this nulldate on the last_login_utc_time?
Do you create your user accts using LDAP/AD or do you create them manually? I just verified on my DEV instance that last_login_utc_time is set when you create user acct manually. I cant verify how this value is set if you use LDAP sync job. Do you have any integrations or applications that create user accounts programmatically?
There is an extensive description of last_login_utc_time in the Documentum Server System Object Reference Manual. There are many parameters which control whether this attributes is updated or not (e.g. if current value is nulldate, DFC session pooling, dm_docbase_config, etc.). I suggest you read it and check what applies to your environment.
