Hi all,

Has anyone got a decent audit analysis script/report?

I was looking for something that would show all records for a given key and also that would show records where a field changed to a given value.

Regards

Phil

You can put the report in an ASCII file and view it with an editor. Or more end-user (unix system), create a filter-device (with ttstpconv) which executes a shell, in that shell you can filter the lines with a grep order like:
cat $1 | fgrep -f /cgl/filtre.txt > /tmp/filtrecgl

Regards

I have only done this subject theoretically, but I do remember there are two sessions (in BAAN IVc3) for printing audit logs:

- Print Range of Audit Files (ttaad4461m000)
- Print Range of Audit Files (Multi Lines) (ttaad4463m000)

I was wondering if these would cover your requirement.

Alternatively, if you wish to develop everything from scratch, the BAAN Tools on-line help gives very detailed information about the formats of the sequence files in which the audit data is stored, with the help of which it should be possible to create customized shell or 'awk' scripts.

Thanks Richard and Shah_bs,

Originally I was printing to file and doing a grep - however my tdsls401 is creating 2 audit files a day!!! That poses the problem of time and diskspace.

Neither of the standard session allow you to define a a value that a field changes too, nor all enteries for a given key.

I guess I will have to write my own - I was hoping not to have to reinvent the wheel so to speak.

Thanks

Phil