What is the meaning 'Record identification' in audit log

(3) Share

Report

Posted on by J_Lee

1,264

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)

Suggested answer

NikolajSorensen 1,792 on at

Like (0)

Report

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,445 Super User 2025 Season 2 on at

Like (1)

Report

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

Like (0)

Report

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,445 Super User 2025 Season 2 on at

Like (0)

Report

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

Like (0)

Report

Thank for your explanation

Was this reply helpful? Yes No
Verified answer

Mohamed Amine Mahmoudi 26,445 Super User 2025 Season 2 on at

Like (0)

Report

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