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
