Skip to main content

Notifications

Announcements

🌸You're Invited: Community Spring Festival Awards Celebration 🌸
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / What is the meaning 'R...
Finance | Project Operations, Human Resources, ...
Answered

What is the meaning 'Record identification' in audit log

(3) ShareShare
ReportReport
Posted on by J_Lee 874
In the database log, it has a column called 'Record identification'. May i know what it is?
 
'5637146827, 579'
 
thank a lot
Categories:
Dynamics 365 Finance
Audit log screen.jpg
  • Verified answer
    Mohamed Amine Mahmoudi Profile Picture
    Mohamed Amine Mahmoudi 22,998 Super User 2025 Season 1 on at
    What is the meaning 'Record identification' in audit log
    Hi @J_Lee,
     
    Is your issue fixed? If yes, then please verify the answers that helped.
     
    Best regards,
    Mohamed Amine MAHMOUDI
  • Suggested answer
    J_Lee Profile Picture
    J_Lee 874 on at
    What is the meaning 'Record identification' in audit log
    Thank for your explanation
  • Suggested answer
    Mohamed Amine Mahmoudi Profile Picture
    Mohamed Amine Mahmoudi 22,998 Super User 2025 Season 1 on at
    What is the meaning 'Record identification' in audit log
    Hi @J_Lee,
     
    Because in table browser it displays the reference but in SQL you have to look at the RecId in the DimensionAttribute table.
     
     
    You can look at the contents of the DimensionAttribute table.
     
    Best regards,
    Mohamed Amine MAHMOUDI
  • J_Lee Profile Picture
    J_Lee 874 on at
    What is the meaning 'Record identification' in audit log
    Thank Mohamed.
     
    In the tablebrowser, dimensionAttribute is shown SystemGeneratedAttributeFixedAsset but the database log is shown 54637144579. Please explain
     
    BTW, i enable the database log set up by dimension code. Why does it capture the Fixed Asset creation?
     
     
     
  • Suggested answer
    Mohamed Amine Mahmoudi Profile Picture
    Mohamed Amine Mahmoudi 22,998 Super User 2025 Season 1 on at
    What is the meaning 'Record identification' in audit log
    Hi @J_Lee,
     
    According to the standard, this field contains the values of the two title filed for each table.
    In your case, you used the DimensionAttributeValue table.
    So this field takes the value of DimensionAttribute and DisplayValue.
     
    Best regards,
    Mohamed Amine MAHMOUDI
  • Suggested answer
    NikolajSorensen Profile Picture
    NikolajSorensen 1,772 on at
    What is the meaning 'Record identification' in audit log
    That is the record ID or RecID of the specific record being changed/created.
    Essentially is the background identifier of the record instead of the more user friendly name or description of the record.
     
    The database log unfortunately in some cases, like when tracking dimensions, only show the RecID instead of the name of the record.
    For you to identify which record was changed, you would need to look in the table you are tracking and find the record ID of each record to be able to correspond that with the actual name.
     
    BR
    Nikolaj

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

News and Announcements

🌸You're Invited: Community Spring Festival Awards Celebration 🌸

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Vahid Ghafarpour Profile Picture

Vahid Ghafarpour 130 Super User 2025 Season 1

#2
Jonas "Jones" Melgaard Profile Picture

Jonas "Jones" Melgaard 105 Super User 2025 Season 1

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 98 Super User 2025 Season 1

Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans