Service Desk Practitioners Forum
cancel

Timestamping in the Activity Log when a field has changed

Highlighted
Maria Swift_1
Respected Contributor.

Timestamping in the Activity Log when a field has changed

Hi all -

We have a requirement to enter a line in our "Activity Log" (64K field) when a notification has been sent or updated. The notification data is a text field in SD that cannot get cleared once the ticket is saved. The field could have information appended to existing or have completely new information entered. When this happens and the ticket is saved we would like an entry in our Activity to say "Notification Sent on Aug 11, 2006 at 12:30pm" or what ever time the ticket is saved. Our question is how can the application determine when the field has changed so that it can make the required entry? We do not want to use both the history log and the Activity Log to piece the information together in order to analyze the sequence of events for Incidents or Changes. Is there an easy way to do this?
Thank you in advance for any advice you have.
Maria
5 REPLIES
George M. Meneg
Acclaimed Contributor.

Re: Timestamping in the Activity Log when a field has changed

Hello Maria,

Have a look at http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=1047709

Assuming that you want to monitor the "notification data" the db rule should be like this:

When service call is created
OR When service call is modified
where notification data (*) is anything
Add timestamp to "Activity Log" (Update Data) Activity Log set to (Concatenate Notification send on $DD$/$MM$/$YYYY$ at $HH$:$MI$%line.separator% With [Activity Log])
menes fhtagn
Maria Swift_1
Respected Contributor.

Re: Timestamping in the Activity Log when a field has changed

Thank you George - we have a field called Activity that copies the data entered in it with a time stamp into the Activity Log and then is cleared when the ticket is saved however we would like to enter a Notification Sent + Time sent statement into the Activity Log when a specific Notification field is filled in or updated. We do not want this field to be cleared nor do we want a statement entered into the Activity Log any time the ticket is saved only when the one Notification field is updated with new information. Does this make sense?
Thanks,
Maria
George M. Meneg
Acclaimed Contributor.

Re: Timestamping in the Activity Log when a field has changed

Hello Maria,

Assuming that the field is named "notification data" the part bellow will do the trick.

"where notification data (*) is anything"

The asterisc denotes that this rule will be evalueated only when notification data is changed. It is a check box on the db rule definition "Evaluate this rule when this field has been changed"
menes fhtagn
Maria Swift_1
Respected Contributor.

Re: Timestamping in the Activity Log when a field has changed

George - you are a great man. I have forwarded your response to our dev team and will find out if this will resolve our issue.
I will let you know and award points asap.
Thank you.
Maria
Maria Swift_1
Respected Contributor.

Re: Timestamping in the Activity Log when a field has changed

George, you saved the day - 10 points for you.
Thank you very much.
Maria