[rt-users] Asset tracking, multiple Contacts in same company, Custom fields, RTFM and more
After dealing a bit with RT and checking out quite a lot of posts in this list, i come up with my scenario which would suit me best, perhaps someone out there has done something similar: We need to do support for clients, which have usually more than one contact to communicate with us and more than one system. The systems use to be listed by name and a system id. I'd like to be able to enter assets for each company, showing on the contacts details and also in Ticket, i.e. contact mt sends a request, we'd like to add the information, that this was about System Asystem1, Type MC, Version 3.1, SysID 4567890 Not talking about the parts (and their serials), the system consists of. :-( Found this: http://www.nabble.com/RT-State-of-the-Onion--td8753466.html#a8754502, so we might not be the only one's. In our point of view, it would be enough, if i could enter a company and add the users to the company, which are working for them. If the user is switching company, i can add him to the new company. In this company data set i can create whatever custom field i need. There were also this post: http://www.nabble.com/Re%3A-RT-4-p10795726.html for putting something like this in RT4. Some ppl here on this list seem to fear, that RT would change into an CRM system, but i think, that it would good for the help desk monkey to be able to check, who called on behalf of a given system id before. This information should be identical for all contacts of the clients, because there tend to be more than one guy taking care of the same systems in one site. Would also be great, if we could attach files to the company. So if contact az sends a request for same system, but updated in the meanwhile to software release 3.5, i would like to update the info as well, but only once, of course. By surfing around, i found the RTx Assettracker, but the webpage seems to be down. Anybody out there, who is able to tell: - Is this project still alive? - Will this Rtx run under 3.8.2(found a v1.2.3 tarball)? - Will Assettracker help in accomplishing what i put together before? Or do i need something else? - Is assettracking on the to-do-list for 4.0, i saw in the RT4 thread several people mentioning it, but couldn't find out, whether someone @bestpractical did accept it as a feature for RT4. I understand, that multiple contacts in same company is a real problem currently, but i think, that there must be more companies out there, having the same problem. So anybody got a workflow for this? This is also a problem with custom fields, i can create custom fields for users etc., but would need to enter the same information twice or five times or even more, depending on how many ppl. the client wants to be created in RT. I am also currently looking in this Scrip Ruslan provided to group unpriv users, some time ago, this could help on the tickettracking issue. I also thought about creating a group for each company having more than one contact, but this seems to be no solution, which could be upgrade safe, because i would also clutter the database. And to come down to RTFM: 1. Any documentation about RTFM, which contains more information as the draft .pdf being available from wiki? 2. Am looking for a language file for RTFM/RT, if i search for .po files, i won't find anything, so someone there, who has a pointer for me? 3. When replying to tickets, there will be shown a popupmenu which contains the complete subject of the article. Unfortunately they are quite long , so you won't see the Go button anymore. So, would it be possible to limit the length of the subject line in this popup? Finally: If i create a new ticket, the client field has to be filled in with the emailadress of the client. As far as i know, this is a textentry box at creation time. I'd like to have a searchfield for the users and a go button, so the help desk monkey can enter it right away, not having to save it first and then edit it one more time to add the user. Thanks for your time, reading this quite long one. w_e PS: RT 3.8.2 (and RTFM 2.4.2 is running on Apache/2.2.3 (Debian) PHP/5.2.0-8+etch13 mod_ssl/2.2.3 OpenSSL/0.9.8c mod_perl/2.0.2 Perl/v5.8.8 -- View this message in context: http://www.nabble.com/Asset-tracking%2C-multiple-Contacts-in-same-company%2C-Custom-fields%2C-RTFM-and-more-tp22273450p22273450.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
Re: [rt-users] Error on including RTFM Article in Answer to Ticket
Hi there, after reading the chapter about custom fields in RT Essentials i thought, setting rights on the custom field, like this: everybody show custom field privileged show custom field privileged edit custom field could do the trick, but no way, the error won't go away.:-( Best w_e who else wrote: Hi all, am a newbie with RT and RTFM, but got it up and running for two days now. I figured out a lot of things myself, and besides buying RT Essentials, which will amazon will ship today, and checking out various options in RT, i got a weird Errormessage, where neither Uncle Google finds anything nor Auntie Searchbutton here in the list archives. So, the error message is: Can't call method Id on an undefined value at /opt/rt3/local/plugins/RT-FM/lib/RT/URI/fsck_com_rtfm.pm line 133. What happened before: I configured RTFM, created two classes and a bunch of topics, as well as a wikitext entry user defined field, to be able to enter the long version of the summary. Then i entered some articles to check out the article integration in RT I opened a new ticket and clicked on answer. Then i selected an Entry of RTFM to be included in the answer. Which was shown in the text editor after i made changes to another field and hit the Enterkey. I selected the entry by popuplist, by entering the article number i got the same errormessage Then i clicked on the Update Button and was presented with the error message above. I don't claim that my workflow is correct :-), but i was wondering about this error message. Since no search yielded in any information i hope someone here has an idea about this. RT 3.8.2 (and RTFM 2.4.2 i think it is, latest version) is running on Apache/2.2.3 (Debian) PHP/5.2.0-8+etch13 mod_ssl/2.2.3 OpenSSL/0.9.8c mod_perl/2.0.2 Perl/v5.8.8 My apache error.log says something like this: [warning]: Could not determine a URI scheme for IT/article/3 (/opt/rt3/bin/../lib/RT/URI.pm:139) (in fact i wanted to include article #3 in the email) Everything else is seems to run smooth enough, no hiccups whatsoever, currently :-) It might be a configuration issue, but i haven't any clue, where to check this out. So, if you got a chance to let me know, where i will have to dig deeper into, i'd be glad. I wouldn't mind a pointer how to fix this either. Thank you for your time. Best w_e -- View this message in context: http://www.nabble.com/Error-on-including-RTFM-Article-in-Answer-to-Ticket-tp22247095p22273535.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
Re: [rt-users] Asset tracking, multiple Contacts in same company, Custom fields, RTFM and more
Hi, You could just create a Queue Customers and create a ticket for every customer there and than attach all the info you have to custom fields and attachments. The Companies people could be CCs on this tickets. All you need to do then is create a script that links this ticket to any new ticket that comes into your Queue Support based on the email adress. Could that be an easy solution to your problem? Regards, Julian Am 01.03.09 15:21 schrieb who else unter bogey...@yahoo.com: After dealing a bit with RT and checking out quite a lot of posts in this list, i come up with my scenario which would suit me best, perhaps someone out there has done something similar: We need to do support for clients, which have usually more than one contact to communicate with us and more than one system. The systems use to be listed by name and a system id. I'd like to be able to enter assets for each company, showing on the contacts details and also in Ticket, i.e. contact mt sends a request, we'd like to add the information, that this was about System Asystem1, Type MC, Version 3.1, SysID 4567890 Not talking about the parts (and their serials), the system consists of. :-( Found this: http://www.nabble.com/RT-State-of-the-Onion--td8753466.html#a8754502, so we might not be the only one's. In our point of view, it would be enough, if i could enter a company and add the users to the company, which are working for them. If the user is switching company, i can add him to the new company. In this company data set i can create whatever custom field i need. There were also this post: http://www.nabble.com/Re%3A-RT-4-p10795726.html for putting something like this in RT4. Some ppl here on this list seem to fear, that RT would change into an CRM system, but i think, that it would good for the help desk monkey to be able to check, who called on behalf of a given system id before. This information should be identical for all contacts of the clients, because there tend to be more than one guy taking care of the same systems in one site. Would also be great, if we could attach files to the company. So if contact az sends a request for same system, but updated in the meanwhile to software release 3.5, i would like to update the info as well, but only once, of course. By surfing around, i found the RTx Assettracker, but the webpage seems to be down. Anybody out there, who is able to tell: - Is this project still alive? - Will this Rtx run under 3.8.2(found a v1.2.3 tarball)? - Will Assettracker help in accomplishing what i put together before? Or do i need something else? - Is assettracking on the to-do-list for 4.0, i saw in the RT4 thread several people mentioning it, but couldn't find out, whether someone @bestpractical did accept it as a feature for RT4. I understand, that multiple contacts in same company is a real problem currently, but i think, that there must be more companies out there, having the same problem. So anybody got a workflow for this? This is also a problem with custom fields, i can create custom fields for users etc., but would need to enter the same information twice or five times or even more, depending on how many ppl. the client wants to be created in RT. I am also currently looking in this Scrip Ruslan provided to group unpriv users, some time ago, this could help on the tickettracking issue. I also thought about creating a group for each company having more than one contact, but this seems to be no solution, which could be upgrade safe, because i would also clutter the database. And to come down to RTFM: 1. Any documentation about RTFM, which contains more information as the draft .pdf being available from wiki? 2. Am looking for a language file for RTFM/RT, if i search for .po files, i won't find anything, so someone there, who has a pointer for me? 3. When replying to tickets, there will be shown a popupmenu which contains the complete subject of the article. Unfortunately they are quite long , so you won't see the Go button anymore. So, would it be possible to limit the length of the subject line in this popup? Finally: If i create a new ticket, the client field has to be filled in with the emailadress of the client. As far as i know, this is a textentry box at creation time. I'd like to have a searchfield for the users and a go button, so the help desk monkey can enter it right away, not having to save it first and then edit it one more time to add the user. Thanks for your time, reading this quite long one. w_e PS: RT 3.8.2 (and RTFM 2.4.2 is running on Apache/2.2.3 (Debian) PHP/5.2.0-8+etch13 mod_ssl/2.2.3 OpenSSL/0.9.8c mod_perl/2.0.2 Perl/v5.8.8 ___ 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 tracking, multiple Contacts in same company, Custom fields, RTFM and more
Quoting Julian Hein jh...@netways.de: Hi, You could just create a Queue Customers and create a ticket for every customer there and than attach all the info you have to custom fields and attachments. The Companies people could be CCs on this tickets. All you need to do then is create a script that links this ticket to any new ticket that comes into your Queue Support based on the email adress. Could that be an easy solution to your problem? Regards, Julian In the same vein, you can use the RTx-AssetTracker to group the same information using Asset custom fields and attach the asset to the ticket(s) in question. We are working on doing this with users machines, sofware and other types of assets. You can create different asset type to group similar informations. Cheers, Ken Am 01.03.09 15:21 schrieb who else unter bogey...@yahoo.com: After dealing a bit with RT and checking out quite a lot of posts in this list, i come up with my scenario which would suit me best, perhaps someone out there has done something similar: We need to do support for clients, which have usually more than one contact to communicate with us and more than one system. The systems use to be listed by name and a system id. I'd like to be able to enter assets for each company, showing on the contacts details and also in Ticket, i.e. contact mt sends a request, we'd like to add the information, that this was about System Asystem1, Type MC, Version 3.1, SysID 4567890 Not talking about the parts (and their serials), the system consists of. :-( Found this: http://www.nabble.com/RT-State-of-the-Onion--td8753466.html#a8754502, so we might not be the only one's. In our point of view, it would be enough, if i could enter a company and add the users to the company, which are working for them. If the user is switching company, i can add him to the new company. In this company data set i can create whatever custom field i need. There were also this post: http://www.nabble.com/Re%3A-RT-4-p10795726.html for putting something like this in RT4. Some ppl here on this list seem to fear, that RT would change into an CRM system, but i think, that it would good for the help desk monkey to be able to check, who called on behalf of a given system id before. This information should be identical for all contacts of the clients, because there tend to be more than one guy taking care of the same systems in one site. Would also be great, if we could attach files to the company. So if contact az sends a request for same system, but updated in the meanwhile to software release 3.5, i would like to update the info as well, but only once, of course. By surfing around, i found the RTx Assettracker, but the webpage seems to be down. Anybody out there, who is able to tell: - Is this project still alive? - Will this Rtx run under 3.8.2(found a v1.2.3 tarball)? - Will Assettracker help in accomplishing what i put together before? Or do i need something else? - Is assettracking on the to-do-list for 4.0, i saw in the RT4 thread several people mentioning it, but couldn't find out, whether someone @bestpractical did accept it as a feature for RT4. I understand, that multiple contacts in same company is a real problem currently, but i think, that there must be more companies out there, having the same problem. So anybody got a workflow for this? This is also a problem with custom fields, i can create custom fields for users etc., but would need to enter the same information twice or five times or even more, depending on how many ppl. the client wants to be created in RT. I am also currently looking in this Scrip Ruslan provided to group unpriv users, some time ago, this could help on the tickettracking issue. I also thought about creating a group for each company having more than one contact, but this seems to be no solution, which could be upgrade safe, because i would also clutter the database. And to come down to RTFM: 1. Any documentation about RTFM, which contains more information as the draft .pdf being available from wiki? 2. Am looking for a language file for RTFM/RT, if i search for .po files, i won't find anything, so someone there, who has a pointer for me? 3. When replying to tickets, there will be shown a popupmenu which contains the complete subject of the article. Unfortunately they are quite long , so you won't see the Go button anymore. So, would it be possible to limit the length of the subject line in this popup? Finally: If i create a new ticket, the client field has to be filled in with the emailadress of the client. As far as i know, this is a textentry box at creation time. I'd like to have a searchfield for the users and a go button, so the help desk monkey can enter it right away, not having to save it first and then edit it one more time to add the user. Thanks for your time, reading this quite long one. w_e PS: RT 3.8.2 (and RTFM 2.4.2
Re: [rt-users] Asset tracking, multiple Contacts in same company, Custom fields, RTFM and more
who else wrote: After dealing a bit with RT and checking out quite a lot of posts in this list, i come up with my scenario which would suit me best, perhaps someone out there has done something similar: We need to do support for clients, which have usually more than one contact to communicate with us and more than one system. The systems use to be listed by name and a system id. I'd like to be able to enter assets for each company, showing on the contacts details and also in Ticket, i.e. contact mt sends a request, we'd like to add the information, that this was about System Asystem1, Type MC, Version 3.1, SysID 4567890 For the above idea, you can try this: http://code.google.com/p/asset-tracker-4rt/wiki/HowToLinkTicketToAssetScrip In theory, you add a ticket custom field, and the user can then just stick in the name of an asset and the ticket will be linked to that asset. So far it isn't actually working for me, but I haven't played with it yet to see why not. Asset Tracker does appear to be alive, you can take a look around http://code.google.com/p/asset-tracker-4rt/. It does appear to work under the latest release of RT. You may want to grab the 1.2.4b1 version for the bug fixes it has. Would also be great, if we could attach files to the company. I've been hoping to use RTFM for this, but haven't actually tested out my plan. For now, the plan is to create a 'class' in RTFM for each company, and then upload files into one or more articles. I understand, that multiple contacts in same company is a real problem currently, but i think, that there must be more companies out there, having the same problem. So anybody got a workflow for this? Is there any reason that 'groups' will not work for this? I'm looking into replacing our in-house ticket-system/client database/kitchen-sink system with an RT-based setup. My preliminary plan is to dump all clients and their related users and use the rt tool to create corresponding groups with their users, after creating the custom fields necessary to match to the current set of data we have for each user. Is there a reason that this will not work well in RT? ___ 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 tracking, multiple Contacts in same company, Custom fields, RTFM and more
Hi, Kenneth Marshall-3 wrote: In the same vein, you can use the RTx-AssetTracker to group the same information using Asset custom fields and attach the asset to the ticket(s) in question. We are working on doing this with users machines, sofware and other types of assets. You can create different asset type to group similar informations. Cheers, Ken Sounds like a plan :-) Which version of RTx-AssetTracker are you using? I can only find 1.2.3, not 1.2.4b1; anybody got a download link? If you got a workflow for this, i'd be interested to learn more, since i am a newbie with RT; and try to get too much in too short time into my head :-) Thanks for help! w_e -- View this message in context: http://www.nabble.com/Asset-tracking%2C-multiple-Contacts-in-same-company%2C-Custom-fields%2C-RTFM-and-more-tp22273450p22275144.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
Re: [rt-users] Asset tracking, multiple Contacts in same company, Custom fields, RTFM and more
Hi Ken, thank you for your answer Kevin Phair wrote: For the above idea, you can try this: http://code.google.com/p/asset-tracker-4rt/wiki/HowToLinkTicketToAssetScrip In theory, you add a ticket custom field, and the user can then just stick in the name of an asset and the ticket will be linked to that asset. So far it isn't actually working for me, but I haven't played with it yet to see why not. Asset Tracker does appear to be alive, you can take a look around http://code.google.com/p/asset-tracker-4rt/. It does appear to work under the latest release of RT. You may want to grab the 1.2.4b1 version for the bug fixes it has. Would also be great, if we could attach files to the company. I've been hoping to use RTFM for this, but haven't actually tested out my plan. For now, the plan is to create a 'class' in RTFM for each company, and then upload files into one or more articles. I understand, that multiple contacts in same company is a real problem currently, but i think, that there must be more companies out there, having the same problem. So anybody got a workflow for this? Is there any reason that 'groups' will not work for this? I'm looking into replacing our in-house ticket-system/client database/kitchen-sink system with an RT-based setup. My preliminary plan is to dump all clients and their related users and use the rt tool to create corresponding groups with their users, after creating the custom fields necessary to match to the current set of data we have for each user. Is there a reason that this will not work well in RT? We intend to use RTFM as Knowledgebase; and concerning groups, i will have to dig deeper into it; i am glad, that RT is up and running, clients are able to enter/send tickets, we are able to work on them, that's cool enough, although RTFM needs a bit more tweaking, but it is less documented than RT itself. We also have several different databases and information systems and we want to have everything concerning tech support, assets like systems, machines etc. in one system, instead of having them to lookup emails in CRM or ERP or whatsoever. We will have somewhen an integration with our ERP, so we can check several tickets in ERP and get the according invoice out of the door :-) But we need to move forward with RT first, because clients keep calling all day ... Will talk to our techies tomorrow but first of all, get RTx::AT installed to check out. Best w_e PS: btw, any other extensions i should be aware of, which might help to accomplish the task? -- View this message in context: http://www.nabble.com/Asset-tracking%2C-multiple-Contacts-in-same-company%2C-Custom-fields%2C-RTFM-and-more-tp22273450p22276103.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
Re: [rt-users] Fwd: A little Scrip help
Hi All, I have investigated the possiblility of having the trigger rule out one of these transactions. I have now come up with the below ammendment which I feel should work but we now get a total of 0 emails sent so I feel it is flawed. Any ideas? * CODE:* my $txn = $self-TransactionObj; return 0 unless $txn-Type =~ /^AddLink$/i; return 0 unless $txn-Field =~ /^MergedInto$/i; if ($txn-NewValue =~ $txn-ObjectID) { return 1; } else { return 0; } return 1; *Regards,* *Aaron Guise 027 212 6638 aa...@guise.net.nz * On Sat, Feb 28, 2009 at 6:25 AM, Potla, Ashish Bassaliel c_apo...@qualcomm.com wrote: Hi, When you merge two tickets , I think the condition you have defined is evaluating to a true condition for both the tickets individually. When the action that is 'notify owner' takes place, in both cases the ticket that is retrieved by ID will be the same as the tickets are now merged(Merged tickets have same ID numbers,the one into which you merged a ticket into). Anyways, try tweaking the condition a bit so that when two tickets are merged, the condition evaluates true only to one of them, preferably the one into which a ticket is merged. -Ashish From: rt-users-boun...@lists.bestpractical.com [ rt-users-boun...@lists.bestpractical.com] On Behalf Of Kenneth Crocker [ kfcroc...@lbl.gov] Sent: Friday, February 27, 2009 10:50 PM To: Aaron Guise Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Fwd: A little Scrip help Aaron, Well, I'm at a loss as well. Sorry. Kenn LBNL On 2/26/2009 4:58 PM, Aaron Guise wrote: I thought of this scenario already, but I created the ticket from another external email address which is separate from my work one which RT Responds to. I am the owner of the ticket data is merged with and hence I get one email but I have a feeling it may be emailing twice as there is two tickets which become one and effectively I become the owner of both. But it reports the ID# of the only remaining ticket in both emails. On Fri, Feb 27, 2009 at 12:57 PM, Kenneth Crocker kfcroc...@lbl.gov mailto:kfcroc...@lbl.gov wrote: Aaron, Are the persons getting the Email in more than 1 role? FOr example; If I am the Requestor the Owner and someone merges a ticket into mine am I getting 1 email as requestor and 1 as owner? Just a thought. Kenn LBNL On 2/26/2009 3:17 PM, Aaron Guise wrote: -- Forwarded message -- From: *Aaron Guise* aa...@guise.net.nz mailto:aa...@guise.net.nz mailto:aa...@guise.net.nz mailto:aa...@guise.net.nz Date: Fri, Feb 27, 2009 at 12:17 PM Subject: Re: [rt-users] A little Scrip help To: Kenneth Crocker kfcroc...@lbl.gov mailto:kfcroc...@lbl.gov mailto:kfcroc...@lbl.gov mailto:kfcroc...@lbl.gov Yeah, Have double checked all of those scrips/templates again. The only one that nets an output matching that is the MergeNotifier Template. Looking in the RT interface for the ticket it shows that the same email sent twice one second apart. I even disabled a whole bunch of other scrips which may have sent a duplicate message but still to no avail. This just shouldn't be happening from what I can tell. *Regards,* *Aaron Guise 027 212 6638 aa...@guise.net.nz mailto:aa...@guise.net.nz mailto:aa...@guise.net.nz mailto:aa...@guise.net.nz * On Fri, Feb 27, 2009 at 10:56 AM, Kenneth Crocker kfcroc...@lbl.gov mailto:kfcroc...@lbl.gov mailto:kfcroc...@lbl.gov mailto:kfcroc...@lbl.gov wrote: Aaron, Check to see if there are other scrips that are initiated with an owner change or ticket creation, etc. Is the template wording the same? Perhaps different wording for templates used by different scrips will give you a clue. Kenn LBNL On 2/26/2009 12:46 PM, Aaron Guise wrote: Hi, I have just now amended our RT_SiteConfig with Set($UseTransactionBatch, 1); Unfortunately it still triggered two emails. The scrip itself is set to use transaction batch. I have posted a screenshot here with the whole configuration of that particular scrip. *Regards,* *Aaron Guise 027 212 6638 aa...@guise.net.nz mailto:aa...@guise.net.nz mailto:aa...@guise.net.nz mailto:aa...@guise.net.nz mailto:aa...@guise.net.nz mailto:aa...@guise.net.nz
[rt-users] DB Problems upgrading to RT 3.8.2 from 3.6.5
Hello, I have a (happily) running RT 3.6.5 with approx 300,000 tickets in it and a database of size of around 9 Gig (lots of attachments sadly). I have the application upgraded, but when I try and run the schema upgrade in my test environment it is taking forever (for values of forever which equate to around 6 days anyway): # perl etc/upgrade/schema.mysql-4.0-4.1.pl rt3 root password ~/sql.queries # time `mysql -p rt3 ~/sql.queries` Enter password: real 8727m23.622s user 0m0.012s sys 0m0.004s Does anyone have any suggestions as to how I can make this faster? I have tried to optimise MySQL as much as possible, but I am not a db expert and obviously there is something wrong. Nb. The test environment is actually more powerful than the production one after having shutdown evey VM on the machine and ensured I was only running this for the time it took. -- Cheers, David ___ 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