web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / How to find out the us...
Microsoft Dynamics AX (Archived)

How to find out the user created date & created by in AX 2012

(0) ShareShare
ReportReport
Posted on by Community Member

Hi All,

 

How can i find out the details like created by , created on for a perticular user in AX 2012.

 

From the SYSUSERLOG table , i can find only the date for the first time user logged on to the system.

 

Can any once let me kow,how to find out the created by, created date for a perticluar user?

 

Regards,

Aravind Reddy.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Sohaib Cheema Profile Picture
    Sohaib Cheema 48,972 User Group Leader on at
    RE: How to find out the user created date & created by in AX 2012

    this information can only be found if properties has been enabled on table SysUserInfo

    but since, these properties are off by default you cannot get data for historical records.

    for future purpose you may enable CreatedDateTime,CreatedBy etc.

    as an alternative for time being you can use SYSUSERLOG  to know first login date of user, which can be possibly close to CreatedDateTime (not accurately, but there are chances of being close)

  • Suggested answer
    5400 Profile Picture
    5400 7,162 on at
    RE: How to find out the user created date & created by in AX 2012

    Go to \System Documentation\Tables\UserInfo table you can get in SQl or Job.

    you can check this table it is system table which has created by and created data time field, If it is not serve your purpose, you have to enabled the property as sohaib told or you can setup the data base log functionality for same.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: How to find out the user created date & created by in AX 2012

    Hi,

        Check the properties of the table to enable createdBy, modifiedby...

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Tocauer Profile Picture

Martin Tocauer 4

#2
Community Member Profile Picture

Community Member 2

#2
Nayyar Siddiqi Profile Picture

Nayyar Siddiqi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans