The standard OOTB way is quite simple:
You'll need a display only (change flag off) field to hold the old value (through a set fields). If you want to track changes such as setting a value to NULL, the below qualification is insufficient. Presumably you'll also not want to audit the first (create) change. So, 1) Have a spare DO field of the same type available 2) Filter: run on Modify, and Merge if desired a. Qual: if 'field != 'DB.field' b. Actions: i. set fields DO = DB.field (need a query here) ii. Set fields log field = "date " + $DATE$ + <lf> +"user " + $USER$ + <lf> + "field changed from " + $DO$ + " to " + " $field$ + "." iii. set fields DO = $NULL$ Comments from comments in a user controlled auditing facility (automatic filter generation bit of code) // build a Diary Field audit filter // Nme: wFltrNm 'df' // Sch: wSch Modify // Ord: wOrd // Qual: 'wFid' != 'DB.wFId' // Action Set Field 'wTmpId' = Qry wSch '1' = "$1$" // Action Set Field 'wDryId' = "field wFlbl changed from " + $wTmpId$ + " to " + $wFid$ // Action Set Field 'wTmpId' = $NULL$ Cheers Ben Ben Chernys Senior Software Architect Description: logoSthInc-sm Canada / Deutschland Mobile: +49 171 380 2329 GMT + 1 + [ DST ] Email: Ben.Chernys_AT_softwaretoolhouse.com Web: <http://www.softwaretoolhouse.com/> www.softwaretoolhouse.com We are a BMC Technology Alliance Partner Check out Software Tool House's free Diary Editor and out Freebies Section for a ITSM 7.6.04 and 8.0.0 Fields spreadsheet. Meta-Update, our premium ARS Data tool, lets you automate your imports, migrations, in no time at all, without programming, without staging forms, without merge workflow. <http://www.softwaretoolhouse.com/> http://www.softwaretoolhouse.com/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Reiser, John J Sent: January-16-13 22:51 To: arslist@ARSLIST.ORG Subject: Re: Audit a Character Field ** Andy, Ok Use a filter with a Run If to do TR.Character_Field != $NULL$ Then a Set Fields to the Diary field using Character_Field. That will add the changed value of the Character field to the diary field. Thank you, --- John J. Reiser Remedy Developer/Administrator Senior Software Development Analyst Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mayfield, Andy L. Sent: Wednesday, January 16, 2013 4:42 PM To: arslist@ARSLIST.ORG Subject: EXTERNAL: Re: Audit a Character Field ** I'm sorry. I meant to ask if there was a way to track changes to a Character field, not a Diary. I would like to log all changes made to a Character and have that stored in a Diary field. I would like to know what value was there before and after a change is made as well as who made it. Andy L. Mayfield Alabama Power Company Protection & Control Technician Staff Linc # 10*19140 Cell # 205-288-9140 Office # 205-226-1846 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Reiser, John J Sent: Wednesday, January 16, 2013 3:37 PM To: arslist@ARSLIST.ORG Subject: Re: Audit a Character Field ** Andy, I never tried it but you should be able to turn on the Audit property of a diary field. Though it seems redundant unless you want to review Diary updates in a separate form with each entry a separate record. Thank you, --- John J. Reiser Remedy Developer/Administrator Senior Software Development Analyst Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mayfield, Andy L. Sent: Wednesday, January 16, 2013 4:28 PM To: arslist@ARSLIST.ORG Subject: EXTERNAL: Audit a Character Field ** Is there a way to log changes to a dairy? I would like to log all changes and who made them to a dairy field that I can review. Any ideas on the best way to accomplish this? Thanks, Andy L. Mayfield Alabama Power Company Protection & Control Technician Staff Linc # 10*19140 Cell # 205-288-9140 Office # 205-226-1846 _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
<<image003.jpg>>
smime.p7s
Description: S/MIME cryptographic signature