Hi Jim, BSafe's File Audit module will show the field changes with the before and after side by side and highlights which fields were changed so they stand out very clearly. It also has a built in Report Writer that is able to just print the changed fields, of which the output can be PDF, CSV or HTML. The log files provide: Date & Time, User, Library, Object Job ID, Program Used, Action Group & Type, as well as the Field (Names, Type, Length, Value before and after the update). It also has a built in filter to narrow down on any of the above mentioned event info.
BSafe thought of everything when designing this module, and would make this task easy and quick. It immediately works for all files already journaled and has a wizard to start journaling other files. Furthermore, only users you specify would be able to use it.
I can show it to you if you are interested...
Robert Mac Adam | Midland Information Systems, Inc. | (407) 571-3114 | robert@xxxxxxxxxxxxxxxxxx
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of midrange-l-request@xxxxxxxxxxxx
Sent: Sunday, September 13, 2009 1:00 PM
To: midrange-l@xxxxxxxxxxxx
Subject: MIDRANGE-L Digest, Vol 8, Issue 1589
Send MIDRANGE-L mailing list submissions to
midrange-l@xxxxxxxxxxxx
To subscribe or unsubscribe via the World Wide Web, visit
http://lists.midrange.com/mailman/listinfo/midrange-l
or, via email, send a message with subject or body 'help' to
midrange-l-request@xxxxxxxxxxxx
You can reach the person managing the list at
midrange-l-owner@xxxxxxxxxxxx
When replying, please edit your Subject line so it is more specific
than "Re: Contents of MIDRANGE-L digest..."
*** NOTE: When replying to this digest message, PLEASE remove all text unrelated to your reply and change the subject line so it is meaningful.
Today's Topics:
1. RE: Journalling All Files (Mike Cunningham)
----------------------------------------------------------------------
message: 1
date: Sun, 13 Sep 2009 12:20:49 -0400
from: Mike Cunningham <mike.cunningham@xxxxxxx>
subject: RE: Journalling All Files
We have journaled all files except work files since we were first able to on S/38. We do not provide any way for an end user to query the journals, if it is needed we do it for them. Where there are many requests to track who changed something (for us it is changes to students class schedules) we built a log file into the applications and let end user query that file.
You could also look at this product
http://www.kisco.com/ifa/
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Jim Franz
Sent: Saturday, September 12, 2009 4:30 PM
To: MIDRANGE-L@xxxxxxxxxxxx
Subject: Journalling All Files
I've been asked to comment on the feasability of a request to "journal all files" for security and record change audits. This is a system I'm very familiar with, and already has some journalling and trigger based auditing. I've just never had a management request to journal "everything". (New owners-and prob in Fortune 100) I should add this is a very customized software package, call it a "mrp/job shop", 500-700 users, and does answer to corp, government, and military auditors.
Anyone out there journalling "all", and what the best way to provide a user interface to querying the receivors to (example) list who changed a certain field over the last year.
Do temporary work files count?
Jim Franz
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
http://archive.midrange.com/midrange-l.
------------------------------
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) digest list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
http://archive.midrange.com/midrange-l.
End of MIDRANGE-L Digest, Vol 8, Issue 1589
*******************************************
midrange.com
