What is the meaning 'Record identification' in audit log

(3) Share

Report

Posted on by J_Lee

1,342

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

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Suggested answer

NikolajSorensen 1,814 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

Mohamed Amine Mahmoudi 26,803 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
J_Lee 1,342 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Suggested answer

Mohamed Amine Mahmoudi 26,803 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

J_Lee 1,342 on at

Like (0)

Report
Copy link

Link copied!

Thank for your explanation

Was this reply helpful? Yes No
Verified answer

Mohamed Amine Mahmoudi 26,803 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @J_Lee,

Is your issue fixed? If yes, then please verify the answers that helped.

Best regards,

Mohamed Amine MAHMOUDI

Was this reply helpful? Yes No