Hi as sage does not have an audit trail/logger, any recommendations either as to solutions you have developed yourself or off the shelf solutions ? Thanks!
Notice of Maintenance on October 9th. Click here for further details.
Hi as sage does not have an audit trail/logger, any recommendations either as to solutions you have developed yourself or off the shelf solutions ? Thanks!
Hi Jeffrey DM we use Pacific Technology Audit Logger at a number of sites and I can recommend it. Tracks the fields the user interacts with, their AD account, hostname, IP address, time, date in UTC and more. Really good though unfortunately last I checked it couldn't audit log in or log out times as Sage 300 doesn't generate any activity when logging in or out of the Classic client so its very hard to audit. At one site we created a Startup folder in the Sage 300 menu and selected All Users (Startup is a reserved word in Sage 300 and anything in that folder will be opened automatically upon login - i.e. if you copy Sage 300 screens in there those screens will open automatically. So we created a powershell script that wrote the username, hostname and other details to a SQL database to capture this. If you find a better alternative out there than Pacific Technology Audit Logger please report back and share.
Hi Accsys Consulting A, thanks for sharing. Am looking at alternatives and have not decided on any solution as ye. My peeve if any is that how is it that an ERP system does not come with an audit logging system, but that's a different discussion ...
Hi 413975, I have been informed that they have purchased Extender and do not seem to see that function (log file changes and login activity). How do I enable that function in Extender, thanks
Hi Jeffrey DM what features are you looking for in the Audit Logger. Out of the box you have the User Activity Report which tracks Log In's, Log Out's, and screens that are opened and closed. Pacific Technology Audit Logger has forensic level auditing of transactions across the system including changes to User Accounts and Permissions. With Orchid Extender you can use Python to write a logging script that you need, or you could setup triggers in SQL to log changes at the database level. If you're logging for Workflow/Approvals type Auditing for Procurement or Purchases our clients use the Pacific Technology Purchasing and Payables Workflow modules. Because you mentioned your version doesn't have built in audit trail/logger like the current versions, I mentioned the suggestion of a startup macro you can run to at least capture logins and log-outs, but if you're actually on a current version this is already covered off-the-shelf:
Cheers...Tim
Thanks Tim.Will give it a run out.
Nice! Thanks for the tip, I like this one.
*Community Hub is the new name for Sage City