Audit a Character Field

2013-01-16 Thread Mayfield, Andy L. 
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


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: Audit a Character Field

2013-01-16 Thread Reiser, John J 
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_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: Audit a Character Field

2013-01-16 Thread John Sundberg 
FDA should be covering that, I think it is a law.

-John


On Wed, Jan 16, 2013 at 3:27 PM, Mayfield, Andy L.
wrote:

> **
>
> 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_




-- 

*John Sundberg*
Kinetic Data, Inc.
"Your Business. Your Process."

*Save The Date! *Second Annual KEG (Kinetic Enthusiasts Group)
Feb. 25th - March 1st in Denver, CO. For more information click here -
KEG

651-556-0930 I john.sundb...@kineticdata.com
www.kineticdata.com I community.kineticdata.com

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: Audit a Character Field

2013-01-16 Thread Mayfield, Andy L. 
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_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: Audit a Character Field

2013-01-16 Thread Mayfield, Andy L. 
LOL  I a little slow today. It took me a minute to get that one.

Everyone please substitute Diary every I typed Dairy. (-:

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 John Sundberg
Sent: Wednesday, January 16, 2013 3:40 PM
To: arslist@ARSLIST.ORG
Subject: Re: Audit a Character Field

**
FDA should be covering that, I think it is a law.

-John

On Wed, Jan 16, 2013 at 3:27 PM, Mayfield, Andy L. 
mailto:almay...@southernco.com>> wrote:
**
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_



--

John Sundberg
Kinetic Data, Inc.
"Your Business. Your Process."

Save The Date! Second Annual KEG (Kinetic Enthusiasts Group)
Feb. 25th - March 1st in Denver, CO. For more information click here - 
KEG<http://www.kineticdata.com/Events/KEG.html>

651-556-0930 I 
john.sundb...@kineticdata.com<mailto:john.sundb...@kineticdata.com>
www.kineticdata.com<http://www.kineticdata.com/> I 
community.kineticdata.com<http://community.kineticdata.com/>


_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"

Re: Audit a Character Field

2013-01-16 Thread Reiser, John J 
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<mailto: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<mailto: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_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: Audit a Character Field

2013-01-16 Thread Ben Chernys 
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$ +  +"user " + $USER$ +  + 

"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:   wSchModify

//   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 2329GMT + 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:

Re: Audit a Character Field

2013-01-17 Thread itsm.support 
Hi,

 

We can enable Audit Option for the respective character field and can track
of the audit logs.

if the Audit trial for the character field is to implement with custom
approach using workflow, then we can have following approach:

Step1: Create a Diary Field on the same form where character field exists.
Step 2: Create a filter with a Run If as (TR.Character_Field != $NULL$ ) and
Execution Option as (Submit, Modify and Merge)
Step 3: Use a Set Fields action and set Diary field = Character_Field

Now the Diary field will keep track of the changes to the Character field.

HTH

 

--

Regards,

Pabitra

 

Vyom Labs Pvt. Ltd.

BSM Solutions & Services || ITIL Consulting & Training

Email: [hidden email]
<http://ars-action-request-system.1093659.n2.nabble.com/user/SendEmail.jtp?t
ype=node&node=7583733&i=0>   || Web Site: www.vyomlabs.com Follow Vyom Labs
http://twitter.com/#!/vyomlabs <http://twitter.com/#%21/vyomlabs>  ||
http://www.linkedin.com/company/vyom-labs

 

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Mayfield, Andy L.
Sent: Thursday, January 17, 2013 2:58 AM
To: arslist@ARSLIST.ORG
Subject: 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_ 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: Audit a Character Field

2013-01-29 Thread Mayfield, Andy L. 
I finally got around to setting this up and it works great.

Thanks for the info.

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 itsm.support
Sent: Thursday, January 17, 2013 11:26 AM
To: arslist@ARSLIST.ORG
Subject: Re: Audit a Character Field

**
Hi,

We can enable Audit Option for the respective character field and can track of 
the audit logs.

if the Audit trial for the character field is to implement with custom approach 
using workflow, then we can have following approach:

Step1: Create a Diary Field on the same form where character field exists.
Step 2: Create a filter with a Run If as (TR.Character_Field != $NULL$ ) and 
Execution Option as (Submit, Modify and Merge)
Step 3: Use a Set Fields action and set Diary field = Character_Field

Now the Diary field will keep track of the changes to the Character field.

HTH

--
Regards,
Pabitra

Vyom Labs Pvt. Ltd.
BSM Solutions & Services || ITIL Consulting & Training
Email: [hidden 
email]<http://ars-action-request-system.1093659.n2.nabble.com/user/SendEmail.jtp?type=node&node=7583733&i=0>
  || Web Site: www.vyomlabs.com<http://www.vyomlabs.com> Follow Vyom Labs 
http://twitter.com/#!/vyomlabs<http://twitter.com/#%21/vyomlabs> || 
http://www.linkedin.com/company/vyom-labs

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Mayfield, Andy L.
Sent: Thursday, January 17, 2013 2:58 AM
To: arslist@ARSLIST.ORG
Subject: 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_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"