Skip to Content
author's profile photo Former Member
0
Former Member

MDM Last Login History table?

Posted on Jan 17, 2008 at 09:08 PM 50 Views

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.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 20, 2008 at 12:24 PM
    0

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 21, 2008 at 06:38 AM
    0

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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.