Auditing Software Recommendations

Welcome to LawsonTalk. We hope you enjoy your visit.

You're currently viewing our forum as a guest. This means you are limited to certain areas of the board and there are some features you can't use. If you join our community, you'll be able to access member-only sections, and use many member-only features such as customizing your profile, sending personal messages, and voting in polls. Registration is simple, fast, and completely free. After registration, please check your e-mail within 24 hours for an message from us, read it, and reply to it.

Join our community!

If you're already a member please log in to your account to access all of our features:

Auditing Software Recommendations
Topic Started: Sep 29 2008, 11:46 AM (483 Views)
SAH	Sep 29 2008, 11:46 AM Post #1
Your Tax Dollars Hard at Work Posts: 378 Group: Members Member #416 Joined: February 7, 2006	We're looking to establish some fine-grained auditing here - at least specifically to try to track who deletes data from specific tables. The weblogs are, how shall I say this - filled with a lot of information :blink: and still doesn't provide a good trail to find this info. IOS provides the same voluminous info, again, without the detail we need. Our oracle logs give great info - except that since it's database auditing, the user ID is always the admin ID (and he doesn't have rights to mess with data on the app side!). I've seen the name Machensoft - and I'm willing to explore any and all suggestions. Your reviews, and if you can, even a ballpark estimate of costs? Thanks



wallaced	Sep 30 2008, 03:26 AM Post #2
Member Posts: 18 Group: Members Member #9,442 Joined: August 14, 2008	I have seen this done at several places using a custom audit table and customizing the application to write to the audit table any time the data was changed. It's a little work, but you can get the audit detail you want this way, including old values versus new values and the ID of the person making the change.



SAH	Sep 30 2008, 09:20 AM Post #3
Your Tax Dollars Hard at Work Posts: 378 Group: Members Member #416 Joined: February 7, 2006	Thanks - however, at this time, we really don't have any resources available here who can dedicate the time to create custom audits (we're like everyone else, buried and getting deeper and deeper!!). That's why I'm hoping maybe a cost effective tool that's already created could work in our situation -



Milo	Oct 2 2008, 06:43 AM Post #4
Rebmem Member Posts: 361 Group: Members Member #424 Joined: February 9, 2006	Quick suggestion - possibly a User Exit for each program you want to monitor. It would look for the Delete command, then log into some sort of standard file. You can customize it as much as you want, since a User Exit isn't affected by Lawson upgrades. To do it 'cost effectively' you do the first until it's perfect & covers all that you want, then you copy/clone the User Exit for each program you need, change it just enough to match the new program, and you're done. Looks like my suggestion has only one stumbling block - where do you get the first User Exit from? Maybe some other LawsonTalk person has a copy of a User Exit that does this, which could be a starting point?



Cindy	Dec 12 2008, 08:44 AM Post #5
Super Member Posts: 154 Group: Members Member #262 Joined: January 13, 2006	SAH Sep 29 2008, 03:46 PM I've seen the name Machensoft - and I'm willing to explore any and all suggestions. Your reviews, and if you can, even a ballpark estimate of costs? Machensoft was a train wreck for us. I really wasn't involved in it at that time, so I hate to comment too much, but suffice to say, it did not perform as advertised. We had to uninstall it, and we refuse to be a guinea pig again. Once there is a solid base of successful implementations, then we may look at them again.


« Previous Topic · Other · Next Topic »