Re: [rt-users] Attachments missing in RESOLVE email

2009-08-31 Thread Miroslav Horvath

Ken, I'm interresting for the code you've mentioned. Could you or somebody
else write me here that code or some similar, which will steal the
attachment from last comment and then I can use it in Resolve template, so
the Attachments which were put into ticket under Resolved phase will be
available in the email from Resolved Template ?



Ken Crocker wrote:
 
 Kevin,
 
 Correct. In fact, I put replied to an email like this awhile back with 
 some code we wrote for a new Resolve template that includes code to 
 include the last comment in the Email body.
 
 Kenn
 LBNL
 
 On 8/6/2009 9:46 AM, Kevin Falcone wrote:
 On Sat, Aug 01, 2009 at 12:38:04AM -0700, Miroslav Horvath wrote:
   
 gyus, you've started the discussion about something else. 

 I've noticed, that in the Resolve email the attachments are not sent
 out.
 For example:

 I'm working on some ticket, and found some solution for the issue, that
 some
 .EXE patch must be applied. So I go to ticket, click on RESOLVE and put
 into
 attachment that .EXE patch file. And will write, that issue was resolved
 and
 the user must apply locally the patch which is attached in the
 resolution
 email. 

 But in the resolution email which user received the attachment wasn't.
 Is
 there some workaround how to have attachment in it  ?
 

 Miroslav

 The 'On Resolve' Scrip runs as a separate transaction, it runs during
 the resolve, not during the comment, so there are no attachments to
 send.  You either need to steal some of the code linked from previous
 posts to look for the previous transaction's attachments or disable
 this script and change RT to send Correspondence rather than Comments
 when a ticket is resolved, and then RT-Attach will work

 -kevin
 ___
 http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

 Community help: http://wiki.bestpractical.com
 Commercial support: sa...@bestpractical.com


 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
 Buy a copy at http://rtbook.bestpractical.com

   
 
 ___
 http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
 
 Community help: http://wiki.bestpractical.com
 Commercial support: sa...@bestpractical.com
 
 
 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
 Buy a copy at http://rtbook.bestpractical.com
 

-- 
View this message in context: 
http://www.nabble.com/Re%3A-Attachments-missing-in-RESOLVE-email-tp24739982p25221025.html
Sent from the Request Tracker - User mailing list archive at Nabble.com.

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


[rt-users] History of Custom Field Values kept anywhere?

2009-08-31 Thread Lander, Scott

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.





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 (cad...@hearstsc.com) immediately by 
email and delete the original message.

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] History of Custom Field Values kept anywhere?

2009-08-31 Thread Gene LeDuc
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

Lander, Scott wrote:
  
 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.

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


Re: [rt-users] History of Custom Field Values kept anywhere?

2009-08-31 Thread Lander, Scott
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




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

Lander, Scott wrote:

 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.


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 (cad...@hearstsc.com) immediately by 
email and delete the original message.


___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


Re: [rt-users] History of Custom Field Values kept anywhere?

2009-08-31 Thread Ken Crocker

Scott,

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.



Kenn
LBNL

On 8/31/2009 1:45 PM, Lander, Scott wrote:

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




  

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
  


Lander, Scott wrote:
  

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.




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 (cad...@hearstsc.com) immediately by 
email and delete the original message.


___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


  
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] History of Custom Field Values kept anywhere?

2009-08-31 Thread Lander, Scott
Ken,

   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:

+-+-+--+-+---+-+-+---+-+
| id  | CustomField | Name 
| Description | SortOrder | Creator | Created | 
LastUpdatedBy | LastUpdated |
+-+-+--+-+---+-+-+---+-+
| 321 |  30 | CPU  
| | 4 | 101 | 2009-08-05 14:44:16 | 
  101 | 2009-08-24 19:56:54 |

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.




Scott,

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.


Kenn
LBNL

On 8/31/2009 1:45 PM, Lander, Scott wrote:

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






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



Lander, Scott wrote:


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.




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 
(cad...@hearstsc.commailto:cad...@hearstsc.com) immediately by email and 
delete the original message.


___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.commailto:sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com



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 (cad...@hearstsc.com) immediately by 
email and delete the original message.

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

[rt-users] Asset Tracker: make some custom field global

2009-08-31 Thread Michael Ellis
Except for Name,Type, Description, and Status; everything else in Asset
Tracker is a custom field. We need to make some fields global so that they
are always presented in search results like the default four, and so that
they are presented in the Query Builder without first having to select a
type that has that custom field.

 

Is there a way to do this built in? If not, do Todd or others have a
suggestion for where to begin to add this functionality that I could
approach our programmers with?

 

Thanks,

 

Mike

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] Asset Tracker: make some custom field global

2009-08-31 Thread Todd Chapman
If I recall correctly, this is done the same way all other RT custom
fields are made global. Admin - Global - Custom Fields.

On Mon, Aug 31, 2009 at 5:03 PM, Michael
Ellismichael_el...@umanitoba.ca wrote:
 Except for Name,Type, Description, and Status; everything else in Asset
 Tracker is a custom field. We need to make some fields global so that they
 are always presented in search results like the default four, and so that
 they are presented in the Query Builder without first having to select a
 type that has that custom field.



 Is there a way to do this built in? If not, do Todd or others have a
 suggestion for where to begin to add this functionality that I could
 approach our programmers with?



 Thanks,



 Mike

 ___
 http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

 Community help: http://wiki.bestpractical.com
 Commercial support: sa...@bestpractical.com


 Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
 Buy a copy at http://rtbook.bestpractical.com

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


Re: [rt-users] History of Custom Field Values kept anywhere?

2009-08-31 Thread Ken Crocker

Scott,

Try the Transaction Table.

Kenn
LBNL

On 8/31/2009 1:58 PM, Lander, Scott wrote:

Ken,
 
   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:
 
+-+-+--+-+---+-+-+---+-+
| id  | CustomField | 
Name | 
Description | SortOrder | Creator | 
Created | LastUpdatedBy | LastUpdated |

+-+-+--+-+---+-+-+---+-+
| 321 |  30 | 
CPU  
| | 4 | 101 | 2009-08-05 
14:44:16 |   101 | 2009-08-24 19:56:54 |
 
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.
 
 

 
Scott,


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.



Kenn
LBNL

On 8/31/2009 1:45 PM, Lander, Scott wrote:

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




  

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
  


Lander, Scott wrote:
  

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.




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 (cad...@hearstsc.com) immediately by 
email and delete the original message.


___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


  


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 (cad...@hearstsc.com) immediately by 
email and delete the original message.

  



___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] History of Custom Field Values kept anywhere?

2009-08-31 Thread Lander, Scott


Hi Ken,

   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!!!



Scott,

Try the Transaction Table.

Kenn
LBNL

On 8/31/2009 1:58 PM, Lander, Scott wrote:
Ken,

   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:

+-+-+--+-+---+-+-+---+-+
| id  | CustomField | Name 
| Description | SortOrder | Creator | Created | 
LastUpdatedBy | LastUpdated |
+-+-+--+-+---+-+-+---+-+
| 321 |  30 | CPU  
| | 4 | 101 | 2009-08-05 14:44:16 | 
  101 | 2009-08-24 19:56:54 |

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.




Scott,

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.


Kenn
LBNL

On 8/31/2009 1:45 PM, Lander, Scott wrote:

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






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



Lander, Scott wrote:


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.




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 
(cad...@hearstsc.commailto:cad...@hearstsc.com) immediately by email and 
delete the original message.


___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.commailto:sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com




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 
(cad...@hearstsc.commailto:cad...@hearstsc.com) immediately by email and 
delete the original message.





___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.commailto:sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

This e-mail message is intended only for the personal use of the 

Re: [rt-users] Asset Tracker: make some custom field global

2009-08-31 Thread Michael Ellis
Thanks. I don't know how I missed that.

Can you think of a way to edit the default format so that it includes a CF 
SerialNumber in every asset query result? I was looking in...

/opt/rt3/share/html/AssetTracker/Search/Results.html
and /opt/rt3/share/html/AssetTracker/Search/Build.html

... thinking that I might append $format with the what I need, but am not sure 
if this is the best way to go.

-Mike



-Original Message-
From: Todd Chapman [mailto:t...@chaka.net] 
Sent: August-31-09 4:20 PM
To: Michael Ellis
Cc: rt Users
Subject: Re: [rt-users] Asset Tracker: make some custom field global

If I recall correctly, this is done the same way all other RT custom
fields are made global. Admin - Global - Custom Fields.

On Mon, Aug 31, 2009 at 5:03 PM, Michael
Ellismichael_el...@umanitoba.ca wrote:
 Except for Name,Type, Description, and Status; everything else in Asset
 Tracker is a custom field. We need to make some fields global so that they
 are always presented in search results like the default four, and so that
 they are presented in the Query Builder without first having to select a
 type that has that custom field.



 Is there a way to do this built in? If not, do Todd or others have a
 suggestion for where to begin to add this functionality that I could
 approach our programmers with?



 Thanks,



 Mike

 ___
 http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

 Community help: http://wiki.bestpractical.com
 Commercial support: sa...@bestpractical.com


 Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
 Buy a copy at http://rtbook.bestpractical.com



___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


Re: [rt-users] History of Custom Field Values kept anywhere?

2009-08-31 Thread Ken Crocker

Scott,

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.


Kenn
LBNL

On 8/31/2009 2:32 PM, Lander, Scott wrote:
 


Hi Ken,
 
   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!!!
 
 


Scott,

Try the Transaction Table.

Kenn
LBNL

On 8/31/2009 1:58 PM, Lander, Scott wrote:

Ken,
 
   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:
 
+-+-+--+-+---+-+-+---+-+
| id  | CustomField | 
Name | 
Description | SortOrder | Creator | 
Created | LastUpdatedBy | LastUpdated |

+-+-+--+-+---+-+-+---+-+
| 321 |  30 | 
CPU  
| | 4 | 101 | 2009-08-05 
14:44:16 |   101 | 2009-08-24 19:56:54 |
 
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.
 
 

 
Scott,


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.



Kenn
LBNL

On 8/31/2009 1:45 PM, Lander, Scott wrote:

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




  

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
  


Lander, Scott wrote:
  

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.




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 (cad...@hearstsc.com) immediately by 
email and delete the original message.


___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


  


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 (cad...@hearstsc.com) immediately by 
email and delete the original message.

  



___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT 

Re: [rt-users] Asset Tracker: make some custom field global

2009-08-31 Thread Michael Ellis
Oh and it's the first thing, too. I'm sorry for not noticing that. I forget 
than when you re-open something in vim it brings you to where you last were, 
NOT the top of the file.

Apologies all,

Mike

-Original Message-
From: Todd Chapman [mailto:t...@chaka.net] 
Sent: August-31-09 4:49 PM
To: Michael Ellis
Cc: rt Users
Subject: Re: [rt-users] Asset Tracker: make some custom field global

That's configurable in AT_Config.pm.

On Mon, Aug 31, 2009 at 5:44 PM, Michael
Ellismichael_el...@umanitoba.ca wrote:
 Thanks. I don't know how I missed that.

 Can you think of a way to edit the default format so that it includes a CF 
 SerialNumber in every asset query result? I was looking in...

 /opt/rt3/share/html/AssetTracker/Search/Results.html
 and /opt/rt3/share/html/AssetTracker/Search/Build.html

 ... thinking that I might append $format with the what I need, but am not 
 sure if this is the best way to go.

 -Mike



 -Original Message-
 From: Todd Chapman [mailto:t...@chaka.net]
 Sent: August-31-09 4:20 PM
 To: Michael Ellis
 Cc: rt Users
 Subject: Re: [rt-users] Asset Tracker: make some custom field global

 If I recall correctly, this is done the same way all other RT custom
 fields are made global. Admin - Global - Custom Fields.

 On Mon, Aug 31, 2009 at 5:03 PM, Michael
 Ellismichael_el...@umanitoba.ca wrote:
 Except for Name,Type, Description, and Status; everything else in Asset
 Tracker is a custom field. We need to make some fields global so that they
 are always presented in search results like the default four, and so that
 they are presented in the Query Builder without first having to select a
 type that has that custom field.



 Is there a way to do this built in? If not, do Todd or others have a
 suggestion for where to begin to add this functionality that I could
 approach our programmers with?



 Thanks,



 Mike

 ___
 http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

 Community help: http://wiki.bestpractical.com
 Commercial support: sa...@bestpractical.com


 Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
 Buy a copy at http://rtbook.bestpractical.com






___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com