<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.3157" name=GENERATOR></HEAD>
<BODY text=#000000 bgColor=#ffffff>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff
size=2></FONT> </DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><SPAN
class=194472921-31082009></SPAN><FONT face=Arial><FONT color=#0000ff><FONT
size=2>H<SPAN class=194472921-31082009>i Ken,</SPAN></FONT></FONT></FONT></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=194472921-31082009></SPAN></FONT></FONT></FONT> </DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=194472921-31082009> 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!!!</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=194472921-31082009></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=194472921-31082009></SPAN></FONT></FONT></FONT> </DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><BR></DIV>
<DIV></DIV>Scott,<BR><BR>Try the Transaction
Table.<BR><BR>Kenn<BR>LBNL<BR><BR>On 8/31/2009 1:58 PM, Lander, Scott wrote:
<BLOCKQUOTE
cite=mid:39A20BAEB14A6344A0646DD5C8F98D4B0637DF7EEA@RCLTEXCMS02.resource.hearstcorp.com
type="cite">
<META content="MSHTML 6.00.2900.3157" name=GENERATOR>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=335005320-31082009>Ken,</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=335005320-31082009></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=335005320-31082009> 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:</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=335005320-31082009></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=335005320-31082009>+-----+-------------+----------------------------------------------------------+-----------------------------+-----------+---------+---------------------+---------------+---------------------+<BR>|
id | CustomField |
Name
|
Description
| SortOrder | Creator |
Created
| LastUpdatedBy | LastUpdated
|<BR>+-----+-------------+----------------------------------------------------------+-----------------------------+-----------+---------+---------------------+---------------+---------------------+<BR></SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=335005320-31082009>| 321
| 30 |
CPU
|
| 4 |
101 | 2009-08-05 14:44:16
| 101 | 2009-08-24
19:56:54 | </SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=335005320-31082009></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=335005320-31082009>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".</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=335005320-31082009></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=335005320-31082009></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><BR></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr
align=left> </DIV>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:
<BLOCKQUOTE
cite=mid:39A20BAEB14A6344A0646DD5C8F98D4B0637DF7EE5@RCLTEXCMS02.resource.hearstcorp.com
type="cite"><PRE wrap="">Gene,
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.
Scott
</PRE>
<BLOCKQUOTE type="cite">
<BLOCKQUOTE type="cite"><PRE wrap="">Scott, look in the ObjectCustomFieldValues table. There are pointers into it from the OldReference and NewReference
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.
Gene
</PRE></BLOCKQUOTE></BLOCKQUOTE><PRE wrap=""><!---->
Lander, Scott wrote:
</PRE>
<BLOCKQUOTE type="cite"><PRE wrap="">We accidentally changed some values in a Custom Field, and they need to
be set back. I can retrieve the values from our backup, but, the
question came up of if RT keeps the history for them. Poking thru the
database, I see it keeps the history for tickets (table Transactions),
and that it keeps most of the data for Custom Fields in the table
CustomFieldValues. It keeps Creator, Creation Date, Last Updated By
and Last Update Date. But, so far, I haven't found anywhere it keeps
what was changed. IE, category old value, new value, like you find
in the Transactions table.
This would seem to be very useful information to have - especially in
the case of a system audit.
Am I just missing something?
This in on RT 3.8.4, btw.
</PRE></BLOCKQUOTE><PRE wrap=""><!---->
------------------------------------------------------------------------------------
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 (<A class=moz-txt-link-abbreviated href="mailto:cadmin@hearstsc.com" moz-do-not-send="true">cadmin@hearstsc.com</A>) immediately by email and delete the original message.
------------------------------------------------------------------------------------
_______________________________________________
<A class=moz-txt-link-freetext href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users" moz-do-not-send="true">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</A>
Community help: <A class=moz-txt-link-freetext href="http://wiki.bestpractical.com" moz-do-not-send="true">http://wiki.bestpractical.com</A>
Commercial support: <A class=moz-txt-link-abbreviated href="mailto:sales@bestpractical.com" moz-do-not-send="true">sales@bestpractical.com</A>
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at <A class=moz-txt-link-freetext href="http://rtbook.bestpractical.com" moz-do-not-send="true">http://rtbook.bestpractical.com</A>
</PRE></BLOCKQUOTE><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 (<A class=moz-txt-link-abbreviated href="mailto:cadmin@hearstsc.com">cadmin@hearstsc.com</A>) immediately by email and delete the original message.
------------------------------------------------------------------------------------
</PRE><PRE wrap=""><HR width="90%" SIZE=4>
_______________________________________________
<A class=moz-txt-link-freetext href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</A>
Community help: <A class=moz-txt-link-freetext href="http://wiki.bestpractical.com">http://wiki.bestpractical.com</A>
Commercial support: <A class=moz-txt-link-abbreviated href="mailto:sales@bestpractical.com">sales@bestpractical.com</A>
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at <A class=moz-txt-link-freetext href="http://rtbook.bestpractical.com">http://rtbook.bestpractical.com</A></PRE></BLOCKQUOTE><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>