[rt-users] Create a team lead view/dashboard to see several user's open tickets

2016-11-03 Thread Kevin Long 

Is it possible to create a dashboard where a team manager can see the top 10 
tickets for each user on his team, i.e.:


Manager Dashboard

Manager's top 10 tickets
.
.
.
.

Jane Doe’s Top 10 tickets
.
.
.
.
John Smith’s Top 10 Tickets
.
.
.
.


Thank you,

Kevin Long
-
RT 4.4 and RTIR training sessions, and a new workshop day! 
https://bestpractical.com/training
* Los Angeles - January 9-11 2017

Re: [rt-users] Search Assets by People gives "No assets matching search criteria found."

2016-11-03 Thread Tom Robinson 
Hi Martin,

Thanks. Looks like I need to do the upgrade. Wasn't planning on that!

Kind regards,
Tom


Tom Robinson
IT Manager/System Administrator

MoTeC Pty Ltd

121 Merrindale Drive
Croydon South
3136 Victoria
Australia

T: +61 3 9761 5050
F: +61 3 9761 5051
E: tom.robin...@motec.com.au

On 03/11/16 21:30, Martin Wheldon wrote:
> Hi Tom,
> 
> Just tried this on my RT 4.4.1 install and it works fine, this is probably 
> this bug?
> 
> From the release notes of RT 4.4.1
> * Fix searching for people associated with Assets (I#31546)
> 
> Best Regards
> 
> Martin
> 
> On 2016-11-03 00:01, Tom Robinson wrote:
>> Sorry, forgot to mentions I'm using RT4 version 4.4.0
>>
>>
>> On 03/11/16 10:37, Tom Robinson wrote:
>>> Hi,
>>>
>>> I'm trying to search my Assets database by People (Owner, Contact or Held 
>>> By) but always get "No
>>> assets matching search criteria found.".
>>>
>>> I think there may be an issue with the created query as I'm seeing an error 
>>> in the logs. Anyone know
>>> what is causing this?
>>>
>>> Kind regards,
>>> Tom
>>>
>>>
>>> ==> httpd/error_log <==
>>> [2409] [Wed Nov  2 23:36:26 2016] [warning]: Use of uninitialized value 
>>> $args{"GroupsAlias"} in hash
>>> element at /usr/local/rt4/lib/RT/SearchBuilder/Role/Roles.pm line 153.
>>> (/usr/local/rt4/lib/RT/SearchBuilder/Role/Roles.pm:153)
>>>
>>> ==> messages <==
>>> Nov  3 10:36:26 marshal RT: [2409] Use of uninitialized value 
>>> $args{"GroupsAlias"} in hash element
>>> at /usr/local/rt4/lib/RT/SearchBuilder/Role/Roles.pm line 153.
>>>
>>> ==> httpd/error_log <==
>>> [2409] [Wed Nov  2 23:36:26 2016] [warning]: Use of uninitialized value 
>>> $args{"ALIAS1"} in
>>> concatenation (.) or string at 
>>> /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 1086.
>>> (/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm:1086)
>>>
>>> ==> messages <==
>>> Nov  3 10:36:26 marshal RT: [2409] Use of uninitialized value 
>>> $args{"ALIAS1"} in concatenation (.)
>>> or string at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 1086.
>>>
>>> ==> httpd/error_log <==
>>> [2409] [Wed Nov  2 23:36:26 2016] [warning]: Use of uninitialized value in 
>>> string eq at
>>> /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 1282.
>>> (/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm:1282)
>>>
>>> ==> messages <==
>>> Nov  3 10:36:26 marshal RT: [2409] Use of uninitialized value in string eq 
>>> at
>>> /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 1282.
>>>
>>> ==> httpd/error_log <==
>>> [2409] [Wed Nov  2 23:36:26 2016] [warning]: DBD::mysql::st execute failed: 
>>> You have an error in
>>> your SQL syntax; check the manual that corresponds to your MySQL server 
>>> version for the right syntax
>>> to use near ') JOIN Groups Groups_1  ON ( Groups_1.Domain = 
>>> 'RT::Asset-Role' ) AND ( Groups_1' at
>>> line 1 at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 586.
>>> (/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm:586)
>>>
>>> ==> messages <==
>>> Nov  3 10:36:26 marshal RT: [2409] DBD::mysql::st execute failed: You have 
>>> an error in your SQL
>>> syntax; check the manual that corresponds to your MySQL server version for 
>>> the right syntax to use
>>> near ') JOIN Groups Groups_1  ON ( Groups_1.Domain = 'RT::Asset-Role' ) AND 
>>> ( Groups_1' at line 1 at
>>> /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 586.
>>>
>>> ==> httpd/error_log <==
>>> [2409] [Wed Nov  2 23:36:26 2016] [warning]: RT::Handle=HASH(0x8a09ae8) 
>>> couldn't execute the query
>>> 'SELECT COUNT(DISTINCT main.id) FROM Assets main JOIN CachedGroupMembers 
>>> CachedGroupMembers_3  ON (
>>> CachedGroupMembers_3.Disabled = '0' ) AND ( CachedGroupMembers_3.GroupId = 
>>> .id ) JOIN Groups
>>> Groups_1  ON ( Groups_1.Domain = 'RT::Asset-Role' ) AND ( Groups_1.Name = 
>>> 'Owner' ) AND (
>>> Groups_1.Instance = main.id ) JOIN CachedGroupMembers CachedGroupMembers_2  
>>> ON (
>>> CachedGroupMembers_2.Disabled = '0' ) AND ( CachedGroupMembers_2.GroupId = 
>>> Groups_1.id )  WHERE ( (
>>> CachedGroupMembers_2.MemberId = '22' )  OR  ( CachedGroupMembers_3.MemberId 
>>> = '0' ) ) AND
>>> (main.Catalog = '4') AND (main.Status != 'deleted') ' at
>>> /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 599.
>>> 
>>> DBIx::SearchBuilder::Handle::SimpleQuery(RT::Handle=HASH(0x8a09ae8), 
>>> "SELECT COUNT(DISTINCT
>>> main.id) FROM Assets main JOIN CachedGr"...) called at 
>>> /usr/local/share/perl5/DBIx/SearchBuilder.pm
>>> line 295
>>> DBIx::SearchBuilder::_DoCount(RT::Assets=HASH(0xa8943c0)) called at
>>> /usr/local/rt4/lib/RT/SearchBuilder.pm line 993
>>> RT::SearchBuilder::_DoCount(RT::Assets=HASH(0xa8943c0)) called at
>>> /usr/local/rt4/lib/RT/Assets.pm line 293
>>> RT::Assets::_DoCount(RT::Assets=HASH(0xa8943c0)) called at
>>> /usr/local/share/perl5/DBIx/SearchBuilder.pm line 1471
>>> DBIx::SearchBuilder::Count(RT::Assets=HASH(0xa8943c0)) called at
>>>

[rt-users] [rt-announce] Request Tracker Training in LA, Update!

2016-11-03 Thread Keri Akmezikyan 
Join us for our first 2017 RT training, in Los Angeles! We'll be there January 
9-11. The first two days are our comprehensive training, and the third day is 
the new workshop day. Come learn about RT (and RTIR!) from the people who make 
it! 

Day one focuses on the usage of RT for non-programmer admins and users. We walk 
through a common helpdesk config including rights management, workflow 
construction, notifications and the basics of Lifecycles. Day two begins with 
server side administration of Request Tracker. We'll cover deploying and 
upgrading the software, as well as how to extend it. Day two will also cover 
basics of RT for Incident Response. And, of course, we'll be highlighting new 
features in the latest releases, RT 4.4 and RTIR 4, throughout.

Brand new for for this training: a third workshop day! You've been asking for 
it and we're listening. For our third day BPS engineers will go through the 
process of creating a new extension for RT live. You're encouraged to come 
prepared with ideas so you can follow along to make your own! The engineers 
will also be prepared to answer questions related to your own instances of RT. 
They'll happily cover rights and administration via the web interface, config 
questions, scrips and template coding and setup, and custom code. If you have 
questions about the agenda not covered here, please contact us for 
clarification.

For a wholly comprehensive experience, we highly recommend attending all three 
days at USD $1,990. If you don't need the workshop day, a seat is USD $1,495 
for the first and second days. If you've attended training before, or are 
highly experienced with RT, you can purchase a seat for just the workshop day, 
at $495. Please note that the third day will not cover broad areas like the 
first 2 days. Each day includes class materials, breakfast, and snacks. You can 
purchase a seat with a credit card at bestpractical.com/training#NextTraining. 
If you wish to pay via check or wire transfer, please drop us a note at 
training.bestpractical.com. If you are a support customer, from an academic 
institution, or wish to send more than 3 people please contact us first for 
eligible discounts.


Please contact us with questions or comments! Thank you for supporting Request 
tracker!


-The BPS Team
___
rt-announce mailing list
rt-annou...@lists.bestpractical.com
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-announce
-
RT 4.4 and RTIR training sessions, and a new workshop day! 
https://bestpractical.com/training
* Los Angeles - Q1 2017

Re: [rt-users] Migrating tickets from 4.0.24 to 4.4.1 (a new instance)

2016-11-03 Thread Lori Welch 
I have recently did this.
I went from 3.6.5 to 4.4.1
I used this website as a tutorial.
http://www.math.ias.edu/~tarzadon/pages/posts/migrating-rt-3.6.4-to-rt-4.0-88.php
I also used phpMyAdmin.

-
RT 4.4 and RTIR training sessions, and a new workshop day! 
https://bestpractical.com/training
* Los Angeles - Q1 2017

Re: [rt-users] Search Assets by People gives "No assets matching search criteria found."

2016-11-03 Thread Martin Wheldon 

Hi Tom,

Just tried this on my RT 4.4.1 install and it works fine, this is 
probably this bug?


From the release notes of RT 4.4.1
* Fix searching for people associated with Assets (I#31546)

Best Regards

Martin

On 2016-11-03 00:01, Tom Robinson wrote:

Sorry, forgot to mentions I'm using RT4 version 4.4.0


On 03/11/16 10:37, Tom Robinson wrote:

Hi,

I'm trying to search my Assets database by People (Owner, Contact or 
Held By) but always get "No

assets matching search criteria found.".

I think there may be an issue with the created query as I'm seeing an 
error in the logs. Anyone know

what is causing this?

Kind regards,
Tom


==> httpd/error_log <==
[2409] [Wed Nov  2 23:36:26 2016] [warning]: Use of uninitialized 
value $args{"GroupsAlias"} in hash

element at /usr/local/rt4/lib/RT/SearchBuilder/Role/Roles.pm line 153.
(/usr/local/rt4/lib/RT/SearchBuilder/Role/Roles.pm:153)

==> messages <==
Nov  3 10:36:26 marshal RT: [2409] Use of uninitialized value 
$args{"GroupsAlias"} in hash element

at /usr/local/rt4/lib/RT/SearchBuilder/Role/Roles.pm line 153.

==> httpd/error_log <==
[2409] [Wed Nov  2 23:36:26 2016] [warning]: Use of uninitialized 
value $args{"ALIAS1"} in
concatenation (.) or string at 
/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 1086.

(/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm:1086)

==> messages <==
Nov  3 10:36:26 marshal RT: [2409] Use of uninitialized value 
$args{"ALIAS1"} in concatenation (.)
or string at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 
1086.


==> httpd/error_log <==
[2409] [Wed Nov  2 23:36:26 2016] [warning]: Use of uninitialized 
value in string eq at

/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 1282.
(/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm:1282)

==> messages <==
Nov  3 10:36:26 marshal RT: [2409] Use of uninitialized value in 
string eq at

/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 1282.

==> httpd/error_log <==
[2409] [Wed Nov  2 23:36:26 2016] [warning]: DBD::mysql::st execute 
failed: You have an error in
your SQL syntax; check the manual that corresponds to your MySQL 
server version for the right syntax
to use near ') JOIN Groups Groups_1  ON ( Groups_1.Domain = 
'RT::Asset-Role' ) AND ( Groups_1' at
line 1 at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 
586.

(/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm:586)

==> messages <==
Nov  3 10:36:26 marshal RT: [2409] DBD::mysql::st execute failed: You 
have an error in your SQL
syntax; check the manual that corresponds to your MySQL server version 
for the right syntax to use
near ') JOIN Groups Groups_1  ON ( Groups_1.Domain = 'RT::Asset-Role' 
) AND ( Groups_1' at line 1 at

/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 586.

==> httpd/error_log <==
[2409] [Wed Nov  2 23:36:26 2016] [warning]: 
RT::Handle=HASH(0x8a09ae8) couldn't execute the query
'SELECT COUNT(DISTINCT main.id) FROM Assets main JOIN 
CachedGroupMembers CachedGroupMembers_3  ON (
CachedGroupMembers_3.Disabled = '0' ) AND ( 
CachedGroupMembers_3.GroupId = .id ) JOIN Groups
Groups_1  ON ( Groups_1.Domain = 'RT::Asset-Role' ) AND ( 
Groups_1.Name = 'Owner' ) AND (
Groups_1.Instance = main.id ) JOIN CachedGroupMembers 
CachedGroupMembers_2  ON (
CachedGroupMembers_2.Disabled = '0' ) AND ( 
CachedGroupMembers_2.GroupId = Groups_1.id )  WHERE ( (
CachedGroupMembers_2.MemberId = '22' )  OR  ( 
CachedGroupMembers_3.MemberId = '0' ) ) AND

(main.Catalog = '4') AND (main.Status != 'deleted') ' at
/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 599.

DBIx::SearchBuilder::Handle::SimpleQuery(RT::Handle=HASH(0x8a09ae8), 
"SELECT COUNT(DISTINCT
main.id) FROM Assets main JOIN CachedGr"...) called at 
/usr/local/share/perl5/DBIx/SearchBuilder.pm

line 295
DBIx::SearchBuilder::_DoCount(RT::Assets=HASH(0xa8943c0)) 
called at

/usr/local/rt4/lib/RT/SearchBuilder.pm line 993
RT::SearchBuilder::_DoCount(RT::Assets=HASH(0xa8943c0)) called 
at

/usr/local/rt4/lib/RT/Assets.pm line 293
RT::Assets::_DoCount(RT::Assets=HASH(0xa8943c0)) called at
/usr/local/share/perl5/DBIx/SearchBuilder.pm line 1471
DBIx::SearchBuilder::Count(RT::Assets=HASH(0xa8943c0)) called 
at

/var/www/rt4/Asset/Search/index.html line 57
HTML::Mason::Commands::__ANON__("!CF.{Asset Number}", "", 
"CF.{OS}", "", "CF.{Express

Service Code}", "", "Status", "", "CF.{Asset Number}", ...) called at
/usr/local/share/perl5/HTML/Mason/Component.pm line 135

HTML::Mason::Component::run(HTML::Mason::Component::FileBased=HASH(0xa667330), 
"!CF.{Asset
Number}", "", "CF.{OS}", "", "CF.{Express Service Code}", "", 
"Status", "", ...) called at

/usr/local/share/perl5/HTML/Mason/Request.pm line 1302
eval {...} called at 
/usr/local/share/perl5/HTML/Mason/Request.pm line 1292
HTML::Mason::Request::comp(undef, undef, undef, "!CF.{Asset 
Number}", "", "CF.{OS}", "",
"CF.{Express Service Code}", "", ...) called at

Re: [rt-users] Enable devel-mode on existing RT instance?

2016-11-03 Thread Joop van de Wege 
On November 2, 2016 9:33:32 PM GMT+01:00, Landon Stewart 
 wrote:
>On Nov 2, 2016, at 10:45 AM, Alex Hall
>> wrote:
>
>Hi all,
>I'm getting an error in an overlay, but nothing is logged. I know I can
>use
>./configure --devel-mode
>to help, though whether that will show additional information for
>errors like this I'm not sure. Either way, how do I enable it on an
>existing installation of RT? Do I go back to the unpacked source and
>re-run the configure script, or is there more to it? Thanks.
>
>Update your RT_SiteConfig.pm with the following and then restart
>apache:
>Set($DevelMode, '1');
>
That too but DevelMode needs a few extra non standard Perl packages. Rerun 
configure with the development switch added and then run make testdeps to see 
what will be installed, then run make fixdeps.

Joop

-
RT 4.4 and RTIR training sessions, and a new workshop day! 
https://bestpractical.com/training
* Los Angeles - Q1 2017