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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

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

(0) ShareShare
ReportReport
Posted on by

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
    49,438 User Group Leader on at

    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
    7,162 on at

    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
    on at

    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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans