Hi,

Are custom fields(z..) saved in the audit_log?We want to see changes made in custom fields at audit_log table.How can we do that?

Regards,

Hi YAZICI,

The following community port would be helpful.
Audit Log for custom field on CHG

Kind regards,

Kaori

I take Unauthorized Error. I can not open this link Audit Log for custom field on CHG

I take Unauthorized Error. I can not open this link Audit Log for custom field on CHG

Hi Yazici,

Have a look at the tech doc below:

Using the example $NX_ROOT\samples\call_mgt\audlog_site.mod file the 1st attribute in the list is not getting audited. 

Kind Regards,

Brian

Hi Yazici,

Sorry about that.

If you would like to audit a custom field zTest added to the 'chg' table, you need to create a audlog_site.mod file wit the following codes.

BJECT chg {
 TRIGGERS {
 // log field changes for custom attributes
 POST_CI audit_fields_site(persistent_id, audit_userid, chg_ref_num, zTest) 51
 FILTER(EVENT("UPDATE(NX_AUDIT_UPD)") );
 };
};

Also, please review TEC499499 as Brian advised.

Kind regards,

Kaori

Hi Kaori,

I would like to audit a custom field zTest added to the 'cr' and 'cnt' table.I followed the steps in the technical document but could not get results.

I also see that in the new version this feature is being passed through the book."In 12.9 and 14.1 the site audit log function is replaced by simply setting the AUDITLOG flag in WSP Schema Designer:" And we use 14.1. SDM.I followed the steps below but did not write it back to the audit_log list and the change does not appear in the audit_log list.How can we do that?

• Navigate to the cr object.
• Click the string1 field.
• Click Advanced in the Properties section on the right.
• In Site-Defined UI_INFO, type: +AUDITLOG()
• Click Save.

• Navigate to File, Save-and-publish.

Regards,

Hi Yazici,

You need to add "AUDITLOG" in the Site-Defined UI_INFO field instead of "AUDITLOG()".

After I published the schema, I followed the below steps.

1. Created a new Activity Association for ztest01, checked the "Log Me" box.
2. installed the auditlog options, "audit_upd" and "audit_ins", and restarted the SDM service.
3. Created a file auditlog_site.mod with the following content and store it under ..\site\mods folder.

OBJECT cr {
 TRIGGERS {
  // log field changes for custom attributes
  POST_CI audit_fields_site(persistent_id, audit_userid, ref_num, CHANGED_ONLY, ztest01) 51
   FILTER( EVENT("UPDATE(NX_AUDIT_UPD)") );
 };
};

Hope the above helps.

Kind regards,

Kaori

Hi,

I tried, but it did not.Why does not work?

Regards,

Burcu

Hi Yazici,

I recommend you to open a Support Case so that CA support can look into the mod files.

Thank you,

Kaori

Hi Melis,

Also you can coded on any mod files like following;

MODIFY cr POST_CI val_fieldupdate_site(persistent_id, audit_userid, CHANGED_ONLY, zitapproval, zitconfirmcnt, zunitapproval, zunitconfirmcnt,  ZBGI, zBGZ, zpassignee1, zpassignee2, zpassignee3, zpassignee4, zpassignee5, zpassignee6, zpassignee7, zpassignee8, ztarget_date, zlast_finish_date, zrootcause, zsuggestion, affected_resource, zoutage_subcode, zcategory) 111 FILTER(EVENT("UPDATE"));

It's working

Best Regards,

Türker