![]() ![]() We explain why signed logs are essential for security software, how we’ve built-in secure audit logging in Acra, and how to use it together with other defense-in-depth layers in your systems. It’s up to you how you want to track activity within your GP environment but hopefully this will give you some valuable insight as to how activity tracking works.In this article, we cover cryptographically signed audit logging, aka “secure logging”, when logs are generated in a certain way which prevents tampering messages, removing, adding, or changing the order of log entries. One technique that I have also used is to create an additional log table and then set up triggers on the SY05000 table to populate the log with key activity, specifically modifications to master files. You could put it into a stored procedure to allow you to call it more quickly or publish it through SQL Server Reporting Services. The possibilities for further configuring this are endless. You can hard code this value if you prefer but it would probably be a better practice to simply note it as a comment within the script. Remember, the can only go back as far as the point at which you began tracking activity within Dynamics GP. This allows you to hone in on a specific activity depending on how much you know when starting your investigation.īy default the is set to the current date. Optionally, you can specify a value for and/or leave them as NULL. The script is designed in such a way that the and parameters are always required. WHERE s.date1 BETWEEN AND c.description = BY s.DATE1 WHERE s.date1 BETWEEN AND s.userid = c.description = BY s.DATE1 WHERE s.date1 BETWEEN AND s.userid = BY s.DATE1 INNER JOIN SY01400 m ON m.userid = s.userid ![]() INNER JOIN track_activity_code c on s.inqytype = c.code Once the above script has been executed run the following SELECT to view the data in the table and verify that all records were created. ![]() INSERT INTO track_activity_code VALUES(23, 'user modified setup record') INSERT INTO track_activity_code VALUES(22, 'user deleted setup record') INSERT INTO track_activity_code VALUES(21, 'user added setup record') INSERT INTO track_activity_code VALUES(20, 'user modified transaction record') INSERT INTO track_activity_code VALUES(19, 'user deleted transaction record') INSERT INTO track_activity_code VALUES(18, 'user added transaction record') INSERT INTO track_activity_code VALUES(17, 'user went into report writer') INSERT INTO track_activity_code VALUES(16, 'user went into modifier') INSERT INTO track_activity_code VALUES(15, 'user logged out') INSERT INTO track_activity_code VALUES(14, 'user accessed routines') INSERT INTO track_activity_code VALUES(13, 'user denied file') INSERT INTO track_activity_code VALUES(12, 'user accessed file maintenance') INSERT INTO track_activity_code VALUES(11, 'user added utility record') INSERT INTO track_activity_code VALUES(10, 'user used process server') INSERT INTO track_activity_code VALUES(9, 'user deleted master record') INSERT INTO track_activity_code VALUES(8, 'user modified master record') INSERT INTO track_activity_code VALUES(7, 'user added master record') INSERT INTO track_activity_code VALUES(6, 'user denied report') INSERT INTO track_activity_code VALUES(5, 'user accessed report') INSERT INTO track_activity_code VALUES(4, 'user denied login') INSERT INTO track_activity_code VALUES(3, 'user accessed form') INSERT INTO track_activity_code VALUES(2, 'user logging in') INSERT INTO track_activity_code VALUES(1, 'user failed login') To access the Activity Tracking Setup window click on Dynamics GP - Tools - Setup - System - Activity Tracking as shown below. The application server also suffers as a result of running the activity monitor without narrowing down the parameters and can cause GP to freeze up or, in the worst case, crash altogether.Īs a result, I have created a script to handle querying the tables that store user activity within GP.īefore you can begin viewing user activity you must first configure it from within GP. Unfortunately, the tool for displaying the activity can be sluggish and lead to potential performance issues if not run within a very narrow dataset. Fortunately Dynamics GP offers a tool for allowing you to configure and view user activity on the system. Knowing what your users are doing and what they have done can be the key to solving an array of issues ranging from illegal activity to correcting a simple mistake. Tracking user activity in Dynamics GP is a vital role of any System Administrator. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |