Hi there,
Recently i got a request from my customer asking me, "Is there got a log or record for Microsoft Dynamics GP activity?" such as creating or deleting company/database, creating or deleting GP user account and etc. If there got any SQL script that able to create a log for this activity, please let me know?
Thank you.
*This post is locked for comments
Hello,
You are totally right regarding the SQL editions.
Please never hesitate to share any further inquiries,
Hi Bill,
Thanks to you too for this info. I will ask the customer again what really the need and also make sure to inform them by select all will make the system to halt and bit slow.
So i will check your reply as an answer also.
Thanks again Bill.
Regards,
Shah
Dear Mahmoud,
Thanks for your reply, when i tried on CDC it's mention that this option only available in SQL Server Enterprise, Developer and Enterprise Evaluations only. My customer is using Standard Edition. So i will skip on CDC.
But for Dynamics GP Activity Tracking, it's really good option but i need to explore more based on customer requested.
Thanks again for this info.
Regards,
Shah.
Hello, we have encountered this a number of times and we have been able to use the Activity Tracking from within GP with great sucess.
Before turning this one feature on, be sure to know the full reason from the client as to what they are looking for. Ask the question, are they questioning the security or are they really wanting to know "of the people security allows in to do something - who is actually doing that task?"
Once we started the tracking the client realized that the people doing the work were in fact those that were set up in security to do so and then after about two months, had us turn off the Tracking.
The reason for turning it off - as Mahmoud states - it is a minor resource killer. If you have lots of disk space and lots of memory, then it would not be as noticeable.
When you configure the Activity Tracking - be sure to be somewhat selective - you can select everything for everyone and then it will grind the system to a halt.
Ask the question, are they questioning the security or are they really wanting to know who is actually doing that task?
Hello Shah,
Dynamics GP has what's called "Activity tracking" which is considered as an option for your case. Keep in mind that activating that will include all the master files; items, customers, vendors ...etc. This in turn imply high load on the server to process and log accordingly. Here is a good reference for Dynamics GP Activity Tracking
Another option is to consider what's called CDC as a database solution for tracking specific tables changes, here is an article on how to consider Audit Requirements for Dynamics GP- CDC
Please let us know if you have any further inquiries,
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (