MDM Last Login History table?

[Former Member]

Hello,

I was wondering if anyone was aware if the last date/time login history of a mdm user to a repository is actually stored in one of the DBMS tables for a repository schema. We are aware of the Audit xml log file that tracks actions of when a user logs into a repository - but we are trying to find out if this is already recored in one of the MDM database tables so we can more easily make use of last login time for custom development.

Thanks.

[Former Member]

Hi David,

You can try out this...... goin the Console client in the system tables check the Login Table. But this you will get records that MDM maintains which corresponds to a currently connected MDM client application, along with the connection time and time since last access, allowing you to monitor connection activity.

Name: The user name.

Host Name: The system on which the MDM client is running.

Application Name: The MDM application (e.g. Client, API, Import Manager).

Connection Time: The date and time the connection was established.

Last Activity Time: The date and time the connection was last accessed.

Hope this helps you ...............

Prasad................

[Former Member]

Hi David,

Not sure but you can try this out "A2i_CM_Audit_Info ".

Go through any log files for "Archive" operation. You should be able to find list of tables over there. Try tables which you feel are relevant to you.

Another thing if you have access to your database server have a look at it to find out the exact table.

Regards,

Amol.