<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Re: [rt-users] History of Custom Field Values kept anywhere?</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.3157" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=538411813-01092009>Drew,</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=538411813-01092009></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=538411813-01092009> You are correct. I am not (at this time)
interested in the change of the value of a custom field within a
ticket. It is the name of the field, as changed from the
configuration menu of the UI, that I am interested
in tracking. And, as you point out, there are history
links for many similar fields. This seems like a logical field to
keep track of also.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=538411813-01092009></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=538411813-01092009> Or, perhaps, I am using the field
incorrectly, so, maybe this should be a non-issue?</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=538411813-01092009></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=538411813-01092009> My use is that I have some 80 sites,
across a half dozen business units that a ticket might come from.
So, on ticket creation the user selects from a custom field (a drop down menu in
the UI) his business unit, and then his location. And, also, as a
second CF, his application and problem. Is this an unusual way
of doing it? Is there a better way?</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=538411813-01092009></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=538411813-01092009> Anyways, someone changed the
application menu by mistake. We have recovered the contents
from backup, so not a big deal as far as data is concerned. But, the
question is; shouldn't this data be tracked? And, it appears that it
is, partially. Who changed it, and when is clearly recorded
(for the last change, only). Just not what they changed it
from, or to. </SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=538411813-01092009></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=538411813-01092009> Anything relating to changing
a ticket, or user, is tracked with the transaction table.
Either the changes in the internal (predefined) data could go there, also, or,
into a separate table. For most installations, I would think this
data is relatively static - IE, we don't add new sites all that often - but, it
does happen. And, new applications are relatively common to
us.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=538411813-01092009></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=538411813-01092009></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=538411813-01092009>Thanks</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=538411813-01092009></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=538411813-01092009>Scott</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=538411813-01092009></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=538411813-01092009></SPAN></FONT> </DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT face=Arial
color=#0000ff size=2></FONT><BR> </DIV>
<DIV></DIV><FONT size=4><FONT face="Calibri, Verdana, Helvetica, Arial"><SPAN
style="FONT-SIZE: 11pt">I think the issue is a matter of understanding.
From reading his messages I get the impression that someone has, in the
UI, changed the Name of the custom field.<BR><BR>I don’t know where this
information could be kept, although I am seeing a History link for Users which
logs password changes and information changes. Perhaps this could be
extended for custom fields also?<BR><BR><BR>On 8/31/09 6:48 PM, "Ken Crocker"
<kfcrocker@lbl.gov> wrote:<BR><BR></SPAN></FONT></FONT>
<BLOCKQUOTE><FONT size=4><FONT face="Calibri, Verdana, Helvetica, Arial"><SPAN
style="FONT-SIZE: 11pt">Scott,<BR><BR>That can't be. I use the transaction
record to trigger several scrips that look at the changes in a CF. Try
transactions with Type = "CustomField", Field = the number of the CF and
old/new values.<BR><BR>Kenn<BR>LBNL<BR><BR>On 8/31/2009 2:32 PM, Lander, Scott
wrote: <BR></SPAN></FONT></FONT>
<BLOCKQUOTE><FONT size=4><FONT
face="Calibri, Verdana, Helvetica, Arial"><SPAN
style="FONT-SIZE: 11pt"> <BR> <BR> <BR> <BR></SPAN></FONT><SPAN
style="FONT-SIZE: 11pt"><FONT color=#0000ff><FONT face=Arial>Hi
Ken,<BR></FONT></FONT><FONT
face="Calibri, Verdana, Helvetica, Arial"><BR> <BR> <BR></FONT><FONT
color=#0000ff><FONT face=Arial> Transaction table was my first
guess - but, nope - looks like everything BUT the Custom Fields is kept
there! Right now, I am thinking that for some reason this data
is just not kept - which sort of surprises me! Oh
well - time for a bug report or wish list submission, I
guess!!!<BR></FONT></FONT><FONT
face="Calibri, Verdana, Helvetica, Arial"><BR> <BR> <BR> <BR> <BR><BR> <BR>Scott,<BR> <BR>Try
the Transaction Table.<BR> <BR>Kenn<BR>LBNL<BR> <BR>On 8/31/2009
1:58 PM, Lander, Scott wrote: <BR></FONT></SPAN></FONT>
<BLOCKQUOTE><FONT size=4><SPAN style="FONT-SIZE: 11pt"><FONT
face="Calibri, Verdana, Helvetica, Arial"><BR></FONT><FONT
color=#0000ff><FONT face=Arial>Ken,<BR></FONT></FONT><FONT
face="Calibri, Verdana, Helvetica, Arial"><BR> <BR> <BR></FONT><FONT
color=#0000ff><FONT face=Arial> CustomFieldValues does have the
current values, and documents when they were inserted or modified, but,
NOT the actual changes - IE, no "Old Value / New Value".
For instance, for one of the lines in question,
the table has:<BR></FONT></FONT><FONT
face="Calibri, Verdana, Helvetica, Arial"><BR> <BR> <BR></FONT><FONT
color=#0000ff><FONT
face=Arial>+-----+-------------+----------------------------------------------------------+-----------------------------+-----------+---------+---------------------+---------------+---------------------+<BR>|
id | CustomField | Name
|
Description
|
SortOrder | Creator | Created
|
LastUpdatedBy | LastUpdated
|<BR>+-----+-------------+----------------------------------------------------------+-----------------------------+-----------+---------+---------------------+---------------+---------------------+<BR> <BR></FONT></FONT><FONT
face="Calibri, Verdana, Helvetica, Arial"><BR></FONT><FONT
color=#0000ff><FONT face=Arial>| 321 |
30 | CPU
|
|
4 |
101 | 2009-08-05 14:44:16 |
101 |
2009-08-24 19:56:54 | <BR></FONT></FONT><FONT
face="Calibri, Verdana, Helvetica, Arial"><BR> <BR> <BR></FONT><FONT
color=#0000ff><FONT face=Arial>What I need to find out is what the Name
used to be! It shouldn't be CPU, at one time (last week) it
was something more like "NAS Storage".<BR></FONT></FONT><FONT
face="Calibri, Verdana, Helvetica, Arial"><BR> <BR> <BR> <BR> <BR><BR> <BR> <BR> <BR>Scott,<BR> <BR>That's
because the ObjectCustomFieldValues Table is for changes to a value for an
OBJECT. To see the history for the Custom Fields themselves, try
CustomFieldValues.<BR> <BR> <BR>Kenn<BR>LBNL<BR> <BR>On
8/31/2009 1:45 PM, Lander, Scott wrote: <BR></FONT></SPAN></FONT>
<BLOCKQUOTE><FONT size=4><SPAN style="FONT-SIZE: 11pt"><FONT
face="Calibri, Verdana, Helvetica, Arial"><BR>Gene,<BR><BR>Thanks, but -
as near as I can tell, ObjectCustomFieldValues has references from type
RT::Ticket only. IE, everything in it refers to a
ticket change, not a global custom field
change.<BR><BR>Scott<BR><BR><BR><BR><BR> <BR> <BR></FONT></SPAN></FONT>
<BLOCKQUOTE><FONT size=4><SPAN style="FONT-SIZE: 11pt"><FONT
face="Calibri, Verdana, Helvetica, Arial"><BR></FONT></SPAN></FONT>
<BLOCKQUOTE><FONT size=4><SPAN style="FONT-SIZE: 11pt"><FONT
face="Calibri, Verdana, Helvetica, Arial"><BR>Scott, look in the
ObjectCustomFieldValues table. There are pointers into it from
the OldReference and NewReference<BR>fields in the Transactions
table. I'm using 3.6.3, but I'm guessing that the same will be
true in
3.8.4.<BR><BR>Gene<BR> <BR> <BR></FONT></SPAN></FONT></BLOCKQUOTE><FONT
size=4><SPAN style="FONT-SIZE: 11pt"><FONT
face="Calibri, Verdana, Helvetica, Arial"><BR></FONT></SPAN></FONT></BLOCKQUOTE><FONT
size=4><SPAN style="FONT-SIZE: 11pt"><FONT
face="Calibri, Verdana, Helvetica, Arial"><BR><BR>Lander, Scott
wrote:<BR> <BR> <BR></FONT></SPAN></FONT>
<BLOCKQUOTE><FONT size=4><SPAN style="FONT-SIZE: 11pt"><FONT
face="Calibri, Verdana, Helvetica, Arial"><BR>We accidentally changed
some values in a Custom Field, and they need to<BR>be set back.
I can retrieve the values from our backup, but,
the<BR>question came up of if RT keeps the history for them.
Poking thru the<BR>database, I see it keeps the
history for tickets (table Transactions),<BR>and that it keeps most of
the data for Custom Fields in the table<BR>CustomFieldValues.
It keeps Creator, Creation Date, Last Updated By<BR>and
Last Update Date. But, so far, I haven't found anywhere it
keeps<BR>what was changed. IE, category
old value, new value, like you find<BR>in the Transactions
table.<BR><BR>This would seem to be very useful information to have -
especially in<BR>the case of a system audit.<BR><BR>Am I just missing
something?<BR><BR>This in on RT 3.8.4,
btw.<BR> <BR> <BR></FONT></SPAN></FONT></BLOCKQUOTE><FONT
size=4><SPAN style="FONT-SIZE: 11pt"><FONT
face="Calibri, Verdana, Helvetica, Arial"><BR><BR>------------------------------------------------------------------------------------<BR>This
e-mail message is intended only for the personal use of the recipient(s)
named above. If you are not an intended recipient, you may not review,
copy or distribute this message. If you have received this communication
in error, please notify the Hearst Service Center (cadmin@hearstsc.com)
immediately by email and delete the original
message.<BR>------------------------------------------------------------------------------------<BR><BR>_______________________________________________<BR><A
href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</A><BR><BR>Community
help: <A
href="http://wiki.bestpractical.com">http://wiki.bestpractical.com</A><BR>Commercial
support: sales@bestpractical.com<BR><BR><BR>Discover RT's hidden secrets
with RT Essentials from O'Reilly Media. <BR>Buy a copy at <A
href="http://rtbook.bestpractical.com">http://rtbook.bestpractical.com</A><BR><BR> <BR> <BR> <BR>------------------------------------------------------------------------------------<BR>This
e-mail message is intended only for the personal use of the recipient(s)
named above. If you are not an intended recipient, you may not review,
copy or distribute this message. If you have received this communication
in error, please notify the Hearst Service Center (cadmin@hearstsc.com)
immediately by email and delete the original
message.<BR>------------------------------------------------------------------------------------<BR> <BR> <BR>
<HR align=center width="90%" SIZE=4>
<BR>_______________________________________________<BR><A
href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</A><BR><BR>Community
help: <A
href="http://wiki.bestpractical.com">http://wiki.bestpractical.com</A><BR>Commercial
support: sales@bestpractical.com<BR><BR><BR>Discover RT's hidden secrets
with RT Essentials from O'Reilly Media. <BR>Buy a copy at <A
href="http://rtbook.bestpractical.com">http://rtbook.bestpractical.com</A><BR> <BR> <BR>------------------------------------------------------------------------------------<BR>This
e-mail message is intended only for the personal use of the recipient(s)
named above. If you are not an intended recipient, you may not review,
copy or distribute this message. If you have received this communication
in error, please notify the Hearst Service Center (cadmin@hearstsc.com)
immediately by email and delete the original
message.<BR>------------------------------------------------------------------------------------<BR> <BR> <BR><BR>
<HR align=center width="90%" SIZE=4>
<BR>_______________________________________________<BR><A
href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</A><BR><BR>Community
help: <A
href="http://wiki.bestpractical.com">http://wiki.bestpractical.com</A><BR>Commercial
support: sales@bestpractical.com<BR><BR><BR>Discover RT's hidden secrets
with RT Essentials from O'Reilly Media. <BR>Buy a copy at <A
href="http://rtbook.bestpractical.com">http://rtbook.bestpractical.com</A><BR><BR>
<HR align=center width="95%" SIZE=3>
</FONT></SPAN></FONT></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE><FONT size=4><FONT
face="Consolas, Courier New, Courier"><SPAN
style="FONT-SIZE: 10pt">_______________________________________________<BR><A
href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</A><BR><BR>Community
help: <A
href="http://wiki.bestpractical.com">http://wiki.bestpractical.com</A><BR>Commercial
support: sales@bestpractical.com<BR><BR><BR>Discover RT's hidden secrets with
RT Essentials from O'Reilly Media. <BR>Buy a copy at <A
href="http://rtbook.bestpractical.com">http://rtbook.bestpractical.com</A><BR></SPAN></FONT></FONT></BLOCKQUOTE><FONT
size=4><FONT face="Consolas, Courier New, Courier"><SPAN
style="FONT-SIZE: 10pt"><BR></SPAN></FONT><FONT
face="Calibri, Verdana, Helvetica, Arial"><SPAN style="FONT-SIZE: 11pt">--
<BR>Drew Barnes<BR>Applications Analyst<BR>Network Resources Dept.<BR>Raymond
Walters College<BR></SPAN></FONT></FONT><pre>------------------------------------------------------------------------------------
This e-mail message is intended only for the personal use of the recipient(s) named above. If you are not an intended recipient, you may not review, copy or distribute this message. If you have received this communication in error, please notify the Hearst Service Center (cadmin@hearstsc.com) immediately by email and delete the original message.
------------------------------------------------------------------------------------
</pre></BODY></HTML>