[rt-users] Display number of tickets to each queue in last 12 months

2014-10-08 Thread scott.dalzell
What is the best way to display the number of tickets each queue has received over the past 12months? i would like to add it to the homepage so we and easily monitor which queues are reciving a lot of tickets thank you Scott -- View this message in context: http://requesttracker.8502.n7.nabbl

Re: [rt-users] Adding New Status option

2014-05-01 Thread scott.dalzell
I removed the approvals section from my SiteConfig and it has started working. thanks for the help Scott -- View this message in context: http://requesttracker.8502.n7.nabble.com/Adding-New-Status-option-tp57285p57291.html Sent from the Request Tracker - User mailing list archive at Nabble.co

[rt-users] Adding New Status option

2014-04-30 Thread scott.dalzell
I am currently using RT4.0.12 and i am looking to add in a new status option for tickets ('Testing'). In my RT_SiteConfig.pm i added the following (copied from RT_Config) and then added in the Testing Status as shown below but the option fails to show. if i have set it up correctly i should only

[rt-users] custom condition when requestor replies/comments to ticket

2014-03-21 Thread scott.dalzell
I am looking to create a custom condition that will be triggered if the requestor of a ticket replies or comments on the ticket after it has been created this is to be used on Several of our queues so the group responsable for the queue can be notified to respond. This is important as the the me

Re: [rt-users] Scrip

2014-03-07 Thread scott.dalzell
so you just want the scrip to run the first time a user replies to a ticket i think it would be much easyer to have the scrip run each time a user comments/replys to a ticket and have something allone the lines of this *sudo code* if(requestor == no one){ find last person to update ticket delete

[rt-users] Cannot save Article searchs for system use

2014-02-03 Thread scott.dalzell
i am currently using RT4.0.12 and i am trying to create a dashboard to display all new Articles that have been created in the last 2 weeks the first hurdle i have come across is that i can not save any Article searches into anything other that 'My Searches' this means that even if i create a suita

[rt-users] Creating Custom Dashboard - 'New Articles'

2014-01-31 Thread scott.dalzell
Hi im looking to create a new dashboard for users that will display all the new articles that have been created/updated in the last month or so. i have created dashboards for tickets before but never Articles so im struggling with the search terms required as the simple search seams geared towar

Re: [rt-users] Let customers see tickets in selfservice interface

2014-01-09 Thread scott.dalzell
i would create a group (Group_CompanyA) and then create a generic user for that group that everyone in companyA could use. i would then assign Group_CompanyA to the queue (CompanyA) under the 'group rights' tab. giving the group at least 'view queue' create ticket, and reply to ticket rights Tha

Re: [rt-users] Searched for 3 hours - how do you view all tickets in a queue?

2014-01-09 Thread scott.dalzell
I dont know what access level your admin has given you as a user but there are afew ways to view All the tickets in a queue *Edit Queue search to show all* 1/ Select queue (e.g. General) 2/ select 'edit search' tab 3/ In the 'Sorting' tab increase the rows per page to unlimited 4/ click update for

[rt-users] Installing Apache2.2.26 as a Win7 Service under Cygwin

2014-01-09 Thread scott.dalzell
I am currently having some issues with Apache that I’m trying to install/run as a service on Windows 7. I want to set it up as a Windows Service so that if it ever fails over it will restart it's self i have installed Apache2.2.26 and configured the http.conf file (port , server name, modules etc

Re: [rt-users] How can i search the contents of a transaction when creating a new ticket

2013-11-13 Thread scott.dalzell
solved my own problem. first it searches for the requestors email address or reference number matches a certain value if it does it will then chop up the standard emails contents to get the users email address it will then remove the old requestor and add the new requestor

[rt-users] How can i search the contents of a transaction when creating a new ticket

2013-11-13 Thread scott.dalzell
Is there a way to search the contents of a transaction on ticket creator so i can find an email address within the transaction and then use that email address as the requestor of the new ticket i have been able to setup a small scrip that will switch between 2 hard coded requestors but i just dont

[rt-users] Modify CF dropdown list from external DB based off of another CFs value

2013-08-14 Thread scott.dalzell
I have 2 ticket CFs (Version_No and Product) i currently have a perl script to update the Version_No CF drop down list from an external database with a manually set Where value set in the code. (This all works fine for controlling the drop down list values to show only the version numbers for the

Re: [rt-users] Unowned Tickets Table on Homepage not updating correctly

2013-08-12 Thread scott.dalzell
This setting nailed the issue on the head. ill post here again if i notice any issues from setting Set($UseSQLForACLChecks,1) in the RT_SiteConfig file but all appears well thank you everyone for your help Scott -- View this message in context: http://requesttracker.8502.n7.nabble.com/Unowne

Re: [rt-users] Unowned Tickets Table on Homepage not updating correctly

2013-08-12 Thread scott.dalzell
Thank you for the quick response The Rows per box was set to 10 so i have increased it to 100 and it revieled the 2 missing tickets. I take it RT counts tickets that the user doesnt have permission to view in this Rows per box count as well ye thank you again -- View this message in context

[rt-users] Unowned Tickets Table on Homepage not updating correctly

2013-08-12 Thread scott.dalzell
Hi i am running an RT system setup so that our support team monitors 5 queues and our multiple resellers also have a queue each to run there support services One of the support users has reported an issue with the "10 newest unowned tickets" table on the homepage not displaying the full list of t

Re: [rt-users] Error when sending or reciving mail (fork::abort: address space needed by xxx)

2013-07-25 Thread scott.dalzell
Rebasing and tunning has done the trick and it is all running fine now i used the following link to help me rebase http://cygwin.wikia.com/wiki/Rebaseall thanks guys for all your support Scott -- View this message in context: http://requesttracker.8502.n7.nabble.com/Error-when-sending-or-rec

Re: [rt-users] Error when sending or reciving mail (fork::abort: address space needed by xxx)

2013-07-24 Thread scott.dalzell
Thanks Thomas I think this has put me on the right track. i found and tweeked the mysqltuner.pl to run on mysql database (needed the host ip address to login into mysql) This suggested that i increase afew max table/cache values to optimize my database. i then Optimized all my databases and incr

[rt-users] Error when sending or reciving mail (fork::abort: address space needed by xxx)

2013-07-23 Thread scott.dalzell
Hi Guy i am running RT4.0.12 using a mysql 5.6.10 under cygwin 2.774 and i am having a major issue When i try and and reply to a ticket or create a ticket via email i get the following in the error.log ---log file--- [Tue Jul 23 16:51:49 2013] [error] (11)Resource temporarily unavailable: fork:

Re: [rt-users] How to update CF via scripted mySQL commands

2013-07-22 Thread scott.dalzell
Thanks for pointing that out. i think ill try to do the API route as i cant afford to corrupt the database. Can the RT API be used to modify a database that is not being used by RT Just that my final goal is to modify a field in our Bugzilla database (also MYsql) when an RT CF is given a bug numb

Re: [rt-users] How to update CF via scripted mySQL commands

2013-07-19 Thread scott.dalzell
i have got abit further with this issue and i have got a perl script that does what i need it to do and edit the mysl database, however when i add this code into RT as a scrip i get the following error in the error.log. [Fri Jul 19 12:38:40 2013] [error]: Scrip 491 Prepare failed: Global symbol "@

[rt-users] How to update CF via scripted mySQL commands

2013-07-18 Thread scott.dalzell
Hey guys What i am trying to do is link 1 ticket CF (Bug_No) to another Ticket CF (Ticket_No) by writing a script that will update the CF (Ticket_No) via the mysql database when the CF (Bug_No) is updated The reason i need it done in this manor is becasue this is a trial before doing the same thi

Re: [rt-users] RT4 - Email Errors generated even when sent 'successfully'

2013-07-17 Thread scott.dalzell
i have now resolved my issue i have been running some tests on the msmtp_Wrapper file and found that the error disapeared if i reduced the file down to one email address (see below) # *msmtp_Wrapper - stripped down to 1 email address* #

[rt-users] RT4 - Email Errors generated even when sent 'successfully'

2013-07-10 Thread scott.dalzell
I was wondering if anyone could help me with this issue. I have setup RT4.0.12, using a Mysql 5.6.11.0 database under Cygwin The issue is my RT system is having a good old moan whenever an email is sent. it is adding errors onto the RT ticket and the error log, however, all the emails are reachin

Re: [rt-users] Linking a Transaction CF value to a Ticket CF value

2013-07-10 Thread scott.dalzell
Due to time constrains i have had to take a simpler approach to this issue and go back to working with ticket obj instead of catching the details dueing the transaction which i understand better at this point in time i have created a new ticket CF ('Alert_Support_Notes') to store the users comment

Re: [rt-users] Linking a Transaction CF value to a Ticket CF value

2013-07-08 Thread scott.dalzell
Ah ok i see where the syntax error is coming from and your right its because of a missing bracket. I have now ran the trigger by replying to a ticket and setting the 'Alert_Support_T CF to 'Alert' and it produced the following error *Error Log* Stack: [/opt/rt4/sbin/../lib/RT/Interface/Email.p

Re: [rt-users] Adding Customfields to QuickCreate Portlet

2013-07-05 Thread scott.dalzell
That would me great if you could thank you -- View this message in context: http://requesttracker.8502.n7.nabble.com/Adding-Customfields-to-QuickCreate-Portlet-tp54565p54578.html Sent from the Request Tracker - User mailing list archive at Nabble.com.

Re: [rt-users] Adding Customfields to QuickCreate Portlet

2013-07-04 Thread scott.dalzell
Sorry the reply ate my code but here is the problem part > Alert_Support: > > > > -- View this message in context: http://requesttracker.8502.n7.nabble.com/Adding-Customfields-to-QuickCreate-Portlet-tp54565p54567.html Sent from the Request Tracker - User mailing list archive at

[rt-users] Adding Customfields to QuickCreate Portlet

2013-07-04 Thread scott.dalzell
Hi I am now trying to add a global ticket CF to the homepage QuickCreate Portlet i have have followed the wiki (below) and my custom field will not appear when i view the QuickTicket Poerlet (http://requesttracker.wikia.com/wiki/QuickTicket#Add_custom_fields_to_portlet) below are why current Qu

Re: [rt-users] Linking a Transaction CF value to a Ticket CF value

2013-07-04 Thread scott.dalzell
The "if ( $type eq 'Create' ) {" & "elsif ( $type eq 'CustomField' ) {" section dont work correctly as there not returning the corect values out regardless if Alert_Support_T is set to 'Alert' or 'null' The 'Create' section always returns 1 and continualy sends emails and the 'custonfield' sectio

Re: [rt-users] How do you check the value of a Transaction CustomField

2013-07-04 Thread scott.dalzell
ah ok so that method wont work what method can be used for Transaction CFs? -- View this message in context: http://requesttracker.8502.n7.nabble.com/How-do-you-check-the-value-of-a-Transaction-CustomField-tp54509p54558.html Sent from the Request Tracker - User mailing list archive at Nabble.c

[rt-users] Linking a Transaction CF value to a Ticket CF value

2013-07-03 Thread scott.dalzell
I currently have 2 customfields assosated with my tickets. Both will be used to highlight a ticket to our support team when set to 'Alert'. Currently the CF on the ticket is used to updates the required tables and notify support etc but having a CF on the Transaction would make it easyer for the u

Re: [rt-users] How do you check the value of a Transaction CustomField

2013-07-03 Thread scott.dalzell
Just a note the above works for the Ticket Custom Field if i change the $cf->LoadByName(Queue => $trans->QueueObj->id,Name => "Alert_Support_T"); to cf->LoadByName(Queue => $ticket->QueueObj->id,Name => "Alert_Support"); -- View this message in context: http://requesttracker.8502.n7.nabble

Re: [rt-users] How do you check the value of a Transaction CustomField

2013-07-03 Thread scott.dalzell
Thank you for your quick response Ok so i am now trying to create a custom condition for my script to detect if the Transaction Custom Field ("Alert_Support_T") has been set to "Alert" the CF however it is not triggering when i set the CF in the transaction to alert any ideals where im going wro

[rt-users] How do you check the value of a Transaction CustomField

2013-07-02 Thread scott.dalzell
Hi How do you check the value of a Transaction CustomField? im looking to create a script that will check a CF on the ticket transaction and if it equals "Alert" it will set a Ticket CF to the same value. This is to allow our in the field support teams to more easily highlight tickets to our ma

[rt-users] 1 email address to control tickets on 2 different RT Servers

2013-05-30 Thread scott.dalzell
We currently have 2 RT servers on site, one running RT3 (ticket numbers 1-11,000) and another running RT4 (ticket numbers 15000+). We are planning to phase out the RT3 machine but in the mean time I want both RT machines to be accessed via the same email address as to hide this phase out from our