[rt-users] RT 3.6.4, user list too long when resolving multiple tickets

Christopher Kunz (Filoo GmbH) chris at de-punkt.de
Mon Feb 2 10:13:52 EST 2009


Emmanuel Lacour schrieb:
> 
> select * from ACL where RightName='OwnTicket';
> 


mysql> select * from ACL where RightName='OwnTicket';
+------+---------------+-------------+-----------+------------+----------+-------------+---------------+
| id   | PrincipalType | PrincipalId | RightName | ObjectType | ObjectId
| DelegatedBy | DelegatedFrom |
+------+---------------+-------------+-----------+------------+----------+-------------+---------------+
|   19 | Group         |        8881 | OwnTicket | RT::Queue  |        3
|           0 |             0 |
|  843 | Group         |        7616 | OwnTicket | RT::Queue  |        4
|           0 |             0 |
|   35 | Group         |        8880 | OwnTicket | RT::Queue  |        4
|           0 |             0 |
|  853 | Group         |      264326 | OwnTicket | RT::Queue  |        4
|           0 |             0 |
|   67 | Group         |        5252 | OwnTicket | RT::Queue  |        5
|           0 |             0 |
|   66 | Group         |        8881 | OwnTicket | RT::Queue  |        5
|           0 |             0 |
|  105 | Group         |        8879 | OwnTicket | RT::Queue  |        6
|           0 |             0 |
|  106 | Group         |        8882 | OwnTicket | RT::Queue  |        6
|           0 |             0 |
|  143 | Group         |        8879 | OwnTicket | RT::Queue  |        7
|           0 |             0 |
|  144 | Group         |        8882 | OwnTicket | RT::Queue  |        7
|           0 |             0 |
|  181 | Group         |        8879 | OwnTicket | RT::Queue  |        8
|           0 |             0 |
|  182 | Group         |        8882 | OwnTicket | RT::Queue  |        8
|           0 |             0 |
|  205 | Group         |        8881 | OwnTicket | RT::Queue  |        9
|           0 |             0 |
| 1204 | Group         |        7616 | OwnTicket | RT::Queue  |       10
|           0 |             0 |
|  232 | Group         |        8178 | OwnTicket | RT::Queue  |       10
|           0 |             0 |
|  231 | Group         |        8880 | OwnTicket | RT::Queue  |       10
|           0 |             0 |
|  264 | Group         |        7616 | OwnTicket | RT::Queue  |       11
|           0 |             0 |
|  263 | Group         |        8881 | OwnTicket | RT::Queue  |       11
|           0 |             0 |
|  298 | Group         |        8178 | OwnTicket | RT::Queue  |       13
|           0 |             0 |
|  297 | Group         |        8880 | OwnTicket | RT::Queue  |       13
|           0 |             0 |
|  358 | Group         |        4054 | OwnTicket | RT::Queue  |       14
|           0 |             0 |
|  377 | Group         |        6780 | OwnTicket | RT::Queue  |       14
|           0 |             0 |
|  396 | Group         |        7086 | OwnTicket | RT::Queue  |       14
|           0 |             0 |
|  329 | Group         |        8880 | OwnTicket | RT::Queue  |       14
|           0 |             0 |
|  412 | Group         |        8881 | OwnTicket | RT::Queue  |       14
|           0 |             0 |
|  338 | Owner         |        8930 | OwnTicket | RT::Queue  |       14
|           0 |             0 |
|  421 | Group         |        8880 | OwnTicket | RT::Queue  |       15
|           0 |             0 |
|  435 | Group         |        8880 | OwnTicket | RT::Queue  |       16
|           0 |             0 |
|  448 | Group         |        8881 | OwnTicket | RT::Queue  |       17
|           0 |             0 |
|  696 | Group         |      101044 | OwnTicket | RT::Queue  |       18
|           0 |             0 |
|  734 | Group         |      205245 | OwnTicket | RT::Queue  |       18
|           0 |             0 |
|  673 | Group         |      101044 | OwnTicket | RT::Queue  |       19
|           0 |             0 |
|  650 | Group         |      101044 | OwnTicket | RT::Queue  |       20
|           0 |             0 |
|  558 | Group         |       97763 | OwnTicket | RT::Queue  |       21
|           0 |             0 |
|  803 | Group         |      101044 | OwnTicket | RT::Queue  |       21
|           0 |             0 |
|  780 | Group         |      205245 | OwnTicket | RT::Queue  |       21
|           0 |             0 |
|  466 | Group         |       97763 | OwnTicket | RT::Queue  |       22
|           0 |             0 |
|  581 | Group         |       97763 | OwnTicket | RT::Queue  |       23
|           0 |             0 |
|  627 | Group         |       97763 | OwnTicket | RT::Queue  |       24
|           0 |             0 |
|  604 | Group         |       97763 | OwnTicket | RT::Queue  |       25
|           0 |             0 |
|  826 | Group         |      101044 | OwnTicket | RT::Queue  |       25
|           0 |             0 |
|  757 | Group         |      205245 | OwnTicket | RT::Queue  |       25
|           0 |             0 |
|  863 | Group         |      264326 | OwnTicket | RT::Queue  |       28
|           0 |             0 |
|  904 | Group         |        8881 | OwnTicket | RT::Queue  |       29
|           0 |             0 |
|  881 | Group         |       53747 | OwnTicket | RT::Queue  |       29
|           0 |             0 |
|  923 | Group         |      268168 | OwnTicket | RT::Queue  |       29
|           0 |             0 |
| 1139 | Group         |        3508 | OwnTicket | RT::Queue  |       30
|           0 |             0 |
| 1000 | Group         |        4054 | OwnTicket | RT::Queue  |       30
|           0 |             0 |
|  954 | Group         |        5054 | OwnTicket | RT::Queue  |       30
|           0 |             0 |
| 1116 | Group         |        7086 | OwnTicket | RT::Queue  |       30
|           0 |             0 |
| 1069 | Group         |        7462 | OwnTicket | RT::Queue  |       30
|           0 |             0 |
|  977 | Group         |        7616 | OwnTicket | RT::Queue  |       30
|           0 |             0 |
| 1093 | Group         |      225814 | OwnTicket | RT::Queue  |       30
|           0 |             0 |
| 1046 | Group         |      289503 | OwnTicket | RT::Queue  |       30
|           0 |             0 |
| 1023 | Group         |      312162 | OwnTicket | RT::Queue  |       30
|           0 |             0 |
| 1268 | Group         |        1642 | OwnTicket | RT::Queue  |       32
|           0 |             0 |
| 1245 | Group         |        4054 | OwnTicket | RT::Queue  |       32
|           0 |             0 |
| 1222 | Group         |        7086 | OwnTicket | RT::Queue  |       32
|           0 |             0 |
| 1163 | Group         |        7616 | OwnTicket | RT::Queue  |       32
|           0 |             0 |
| 1176 | Group         |           3 | OwnTicket | RT::Queue  |       33
|           0 |             0 |
| 1179 | Group         |           5 | OwnTicket | RT::Queue  |       33
|           0 |             0 |
| 1177 | Requestor     |      349496 | OwnTicket | RT::Queue  |       33
|           0 |             0 |
| 1186 | Group         |           4 | OwnTicket | RT::Queue  |       34
|           0 |             0 |
| 1183 | Owner         |      349523 | OwnTicket | RT::Queue  |       34
|           0 |             0 |
| 1191 | Group         |           4 | OwnTicket | RT::Queue  |       35
|           0 |             0 |
|    2 | Group         |          11 | OwnTicket | RT::System |        1
|           0 |             0 |
+------+---------------+-------------+-----------+------------+----------+-------------+---------------+
66 rows in set (0.00 sec)

Regards,

--ck

-- 
         Christopher Kunz | Geschäftsführung | chris at filoo.de
Filoo GmbH | Tilsiter Str. 1 | 33449 Langenberg | HRB4355 AG Gütersloh
           Geschäftsführer: S.Grewing | J.Rehpöhler | C.Kunz
   Hotline: 07000-3378658 |  Fax: 01805-963951172 (jew. 14 ct./Min.)



More information about the rt-users mailing list