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

I have the same question (0)

All responses (11)

Answers (2)

Suggested answer

Ramit Paul 22,797 Most Valuable Professional on at

Like (0)

Report

Hi Kartik,

Yes, D365 has the function to check user log.

Check Sys admin- inquires and reports - data cache - user log

Was this reply helpful? Yes No
Verified answer

Gunjan Bhattachayya 35,423 on at

Like (1)

Report

Hi Kartik,

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

Please check here for more details.

Was this reply helpful? Yes No
Kartik Sharma 130 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Ramit Paul 22,797 Most Valuable Professional on at

Like (1)

Report

Hi,

have you checked the reports from database in sys admin like data base log and then history?

Was this reply helpful? Yes No
Kartik Sharma 130 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Kartik Sharma 130 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,423 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

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

Was this reply helpful? Yes No
TsutomuYanagida on at

Like (1)

Report

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

Was this reply helpful? Yes No
Kartik Sharma 130 on at

Like (0)

Report

Hello Ludwig,

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

Kartik

Was this reply helpful? Yes No