Enable Audit Trial in custom developed programs.

cgdev

New Member
Hi Progress Talkers,

I am currently working on MFG/PRO eB2.1. I am trying to delete the user groups assigned to a user when a user gets resigned/terminated in order to disable to the privliges in MFG/PRO. While doing so I wanted keep an audit trial for the same.

I am unsuccess tried searching MFG/PRO documentation and the source code available from QAD.

I need someone's help in understanding how audit trail works in MFG/PRO and suggest me list of includes/sub programs to use for writing the audit trail records.

It would be very much helpful or provides me a pointer if someone could tell me atleast how it works in pre eB2.1.

I sincerely appreciate your help.
 
Hi
In pre-eB2.1 the system allowed a basic audit trail ( which by the way does not conform to the SOX or FDA standards) for the following tables:

ac_mstr (accounts)
ad_mstr (addresses)
bk_mstr (banks)
cm_mstr (customers)
cu_mstr (currency)
flpw_mstr (field security)
mnd_det (menu security)
mu_mstr (monetary union)
tx2_mstr (GTM tax rates)
usr_mstr (users)
vd_mstr (suppliers)

In eB2.1 there is an optional, separately installed special module called "Enhanced Controls", which allows to track changes made to ANY table it the system. When this module is installed, you can enable/disable audit trails for any MFG/PRO table/field, and these audit trails conform with all industry standards. All changes are kept in a separate (not qad.db) database and are completely user-independent. Only the administrator (if you set up the security properly) can access audit trail reports, which include data stamp before and after the change, as well as changed data field by field.

If this is not an eB2.1, for your purposes you can keep track of changes to usr_mstr, but not as detailed as with "Enhanced Controls".
Hope it helps. if you have any other questions, you can contact me directly at
max.viskov@32soft.com

____________________________________
Max Viskov
Senior Consultant, Implementation Services
MFG/PRO Toronto User Group Board Member
32Soft Inc., an Official QAD Subcontractor
Need GL Report Writer reports on the Web/Excel?
Check 32WebReport at http://www.32soft.com/site/modules/xt_conteudo/index.php?id=9[FONT=&quot][/FONT]
 

cgdev

New Member
Thanks a lot MAX.

The information provided by you was informative as knowledge point of view. Eventhough I had access to menus but It looks like we do not have licences for Enhanced controls module.

I found an work around to create the aud_det records as currently MFG/PRO does for most of the master files.

I am using the routine in my "gpaudpl.p" for creating the aud_det records. Also, there is an include file "gpaudwrt.i" which could be used in maintenance programs(user update allowed).

I would appreciate your thoughts. Hoping that this would not cause any choas.
 
Hi
One of the easiest ways to write custom audit trails is to do it as a trigger in mf.p. This way you can define a trigger something like "on-write ad_mstr" and call your custom audit trail writing program.
If you need more explanation, please let me know
Regards
____________________________________
Max Viskov, max.viskov@32soft.com

Senior Consultant, Implementation Services
MFG/PRO Toronto User Group Board Member
32Soft Inc., an Official QAD Subcontractor
Need GL Report Writer reports on the Web/Excel?
Check 32WebReport at http://www.32soft.com/site/modules/xt_conteudo/index.php?id=9[FONT=&quot][/FONT]
 

wsong

Member
Maybe the database trigger is even easier, which does not need the source code of mf.p.

define a write trigger of the table in database admin which writes to aud_det. so you can use stardard QAD programs to track the change history.

Good Luck


Willy Song


Hi
One of the easiest ways to write custom audit trails is to do it as a trigger in mf.p. This way you can define a trigger something like "on-write ad_mstr" and call your custom audit trail writing program.
If you need more explanation, please let me know
Regards
____________________________________
Max Viskov, max.viskov@32soft.com

Senior Consultant, Implementation Services
MFG/PRO Toronto User Group Board Member
32Soft Inc., an Official QAD Subcontractor
Need GL Report Writer reports on the Web/Excel?
Check 32WebReport at http://www.32soft.com/site/modules/xt_conteudo/index.php?id=9
 

Daved0331

New Member
I use a custom Audit Trail package for Windows-based Progress databases. The package was recently enhanced to also work with Unix-based Progress databases. It allows you to track changes to any Progress table and field. Provides table and field, audit date/time, terminal id/PC name, network user id, application user id, program stack, old/new values and more. Also provides real-time e-mail notification of changes.

Let me know if you want more info...
 
Top