Is there a Way to Get the User Log and what Changes they Have done

(0) Share

Report

Posted on by Kartik Sharma

130

Hello Everyone,

Is there a way to get the user Log or the Page log in which we can see which user did the changes and what?

Appreciate your help in advance.

Thanks!

Kartik

All responses (11)

Answers (2)

Kartik Sharma 130 on at

Like (0)

Report

RE: Is there a Way to Get the User Log and what Changes they Have done

Thank you for your help
Kartik Sharma 130 on at

Like (0)

Report

RE: Is there a Way to Get the User Log and what Changes they Have done

Hello Ludwig,

Thank you for your help. I will be applying and will share my results.

Kartik
TsutomuYanagida on at

Like (1)

Report

RE: Is there a Way to Get the User Log and what Changes they Have done

Please note that there could be performance implications when enabling database logging. You can check at docs.microsoft.com/.../configure-and-manage-database-logging
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

RE: Is there a Way to Get the User Log and what Changes they Have done

Hi Kartik,

The custtable is the right table but you won't find the name custtable in the database log because labels are used instead there.

Please look out for 'Customers'.

This site might help: dynamicsax-fico.com/.../

Best regards,

Ludwig
Gunjan Bhattachayya 35,421 on at

Like (1)

Report

RE: Is there a Way to Get the User Log and what Changes they Have done

Hi Kartik,

Customer master information is stored in CustTable. Name is stored in DirPartyTable. There are some other tables involved for Contacts and addresses etc.

You can start with CustTable and check if the other tables are needed.
Kartik Sharma 130 on at

Like (0)

Report

RE: Is there a Way to Get the User Log and what Changes they Have done

Hello Gunjan,

Thanks for the help, I am looking into this option. By any chance do you know what exact table I can find use for Customer Master which include all the fields.

Thanks!

Kartik
Kartik Sharma 130 on at

Like (0)

Report

RE: Is there a Way to Get the User Log and what Changes they Have done

Hello Ramil,

We don't have setup to create a Log Database for certain tables. As Gunjan suggested I will create a database log for the required table and will see if that work for us.

Thanks!

Kartik
Suggested answer

Ramit Paul 22,572 Most Valuable Professional on at

Like (1)

Report

RE: Is there a Way to Get the User Log and what Changes they Have done

Hi,

have you checked the reports from database in sys admin like data base log and then history?
Kartik Sharma 130 on at

Like (0)

Report

RE: Is there a Way to Get the User Log and what Changes they Have done

Hello Ramil,

Thank you for the reply. In the User Log I can only get the info about there login time, but I require what changes they have done. Because currently we are having challenges where user change something in the Customer Card or item card and we are unable to track who is doing.

Thanks!

Kartik
Verified answer

Gunjan Bhattachayya 35,421 on at

Like (1)

Report

RE: Is there a Way to Get the User Log and what Changes they Have done

Hi Kartik,

You can setup database logging. It has an effect on performance though.

Please check here for more details.