We've been auditing specific tables for some time now.

Problem is, no one's being reviewing anything via these files.

The thought is that now non-IT personel will be reviewing these
details.

The file is obviously not easy to read.

Is there some easy way to translate the details of something like:

${BSE}/audit/000/ttaad/aaad300000.000

The file is on Unix, the non-IT people will need to view via wordpad or notepad via a share (no access to Unix file system).

Thanks in advance.

BaanTech

Hello,

The Audit Files are in a specific format which can't be read using any editor. You must write a program to process the audit files and store the audit data in a human readable format.

Refer to Audit Management in U7040F US BaanERP - Tools Technical Manual and the Online-Help

Best Regards

Can't you use the normal Baan sessions for reviewing the data?

Rgrds,
Han

I'm lost as to what you mean by normal Baan sessions.

If I use the Maintain, Print or Display sessions for the tables I only see the current data. The powers that be want a history
of changes (per user or per date etc.) to what they deem as key control sessions.

User history is not active for normal users.

Regards,

BaanTech

Did you try using the ttaad4461m000 - Print Range of Audit Files session? You will find this session under Audit Management menu in Tools.

Ram.

Hello All

Do you all have any ideas to print audit files using 3rd party tool like Crystal or Safari reports writers? at the moment we using ttaad4461m000 but that session not provides the reports the way that we need.

Regards
Srilal.

The audit files contain snapshots of an audited table (and the audited fields within the table) before and after a change (plus detail on who made the change, when, etc.).

To present this data in a "user-friendly" format, you must write some type of report program. If you are content with just highlighting records that were changed, reports using SQL, Crystal or Safari will be fine. I think anything such as "user A changed Field-1 from "A" to "B" will require more involved scripting.

Scott

I'm getting 'User 'bsp' has no permissions at all' when running
ttaad4461m000 for table ttaad231 co. 000. All other settings
are open range.

What am I missing ?

Thanks.

BaanTech

You have to give user 'bsp' at least 'read' access to your audit files. There's a special session for this but you will have to run this as user 'root'.

'bsp' does have read access at the unix file level.

Do I need to run the session as root ?

The read access at UNIX level is irrelevant. You need to run the session Assign Audit Security to Users - ttaad4162m000 as user root. In that session you can assign a baan user certain rights (print, delete, maintain) that will allow you to read and interpret the audit files' contents.

Thanks.

Just finished checking that prior to reading reply.

At one point bsp was setup, but this was removed and
has now been replaced via root login.

Thanks to all.

BaanTech