[rt-users] Sort Order of Custom Fields in rt 3.6.1 -- possible lead?
Ole Craig
ocraig at stillsecure.com
Fri Dec 29 02:16:01 EST 2006
On Wed, 2006-10-04 at 16:51 -0600, Ole Craig wrote:
>
> Guess I'm just lucky... I've got a select-one-value Ticket CF named
> "Severity" which currently has the following possible name values:
>
> '1 - CRITICAL'
> '2 - Major'
> '3 - Minor'
> '4 - Informational'
>
> (sort ordering is 1234 and the value name begins with the appropriate
> digit as well.)
>
> If I sort my "N" highest priority tickets at-a-glance page on that CF
> (and that CF alone, all other sort bars are set to "none") I get a
> random list. At the moment, it looks like this:
>
> 3 - Minor
> 3 - Minor
> 1 - CRITICAL
> 2 - Major
> 2 - Major
> 4 - Informational
> 2 - Major
> 3 - Minor
> [...]
>
> No other order is apparent in the ticket list.
So... after digging through the changelogs for both RT 3.6.3-RCx and
DBIx::Searchbuilder-1.45 and seeing no mention of this bug, I got
frustrated and decided to dig a little. I've been playing with queries
all night, and it looks to me like this bug is exercised when you have
more than one custom field defined for your queue; RT (or SB) passes a
query to mysql that is not sufficiently constrained, so you get ordering
by the SortOrder of all custom fields rather than just the one you
specified.
I stripped an RT search down to just a few fields and sorted on my
custom "severity" field while running mysql with general query logging,
and the query that came through looks like the attached sql-1.txt. When
I ran that by hand it returned the seemingly random order I was seeing
in RT (result-1.txt) but when I added an extra SELECT field
(CustomFieldValues_4.Name) I noticed that the values returned for
CustomFieldValues.Name were from every possible custom field defined for
the queue, not just the Severity CF. (sql-2.txt, result-2.txt).
So I added an extra JOIN and an extra WHERE clause to the original
query, to link CustomFieldValues_4 to the severity CF, and lo and behold
the results came out in correct order! (sql-3.txt, result-3.txt) Lastly,
for the sake of completeness I added the extra JOIN and WHERE clauses to
the second query with the extra SELECT, and this time it displayed only
names from the Severity CF, instead of all possible CFs defined on my
support queue. (sql-4.txt, result-4.txt.)
Unfortunately, I'm not (yet?) intelligent enough to chase this through
the perl, but I'm hopeful this might narrow the problem domain enough
that someone who's familiar with RT and SearchBuilder is able to
recognize what's happening, and suggest a fix for this pernicious bug
that's plagued RT for so long...
--
/Ole Craig
Security Engineer
Team lead, customer support
ocraig at stillsecure.com
303-381-3824 direct
303-381-3802 support
303-381-3880 fax
www.stillsecure.com
-------------- next part --------------
mysql> source /var/tmp/sql-1.txt
+------+-------------+-------+--------+----------------+------------+-------+----------------------------------------------------------+-----------------+---------------+----------+---------------+------------+-----------+----------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------+---------------------+---------+---------------------+----------+
| id | EffectiveId | Queue | Type | IssueStatement | Resolution | Owner | Subject | InitialPriority | FinalPriority | Priority | TimeEstimated | TimeWorked | Status | TimeLeft | Told | Starts | Started | Due | Resolved | LastUpdatedBy | LastUpdated | Creator | Created | Disabled |
+------+-------------+-------+--------+----------------+------------+-------+----------------------------------------------------------+-----------------+---------------+----------+---------------+------------+-----------+----------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------+---------------------+---------+---------------------+----------+
| 2787 | 2787 | 3 | ticket | 0 | 0 | 33 | Re: Traveling | 30 | 0 | 30 | 0 | 0 | developmt | 0 | NULL | 1970-01-01 00:00:00 | 2006-11-02 22:54:40 | 2006-10-29 18:56:06 | 1970-01-01 00:00:00 | 626 | 2006-12-08 20:23:20 | 1008 | 2006-10-22 18:56:06 | 0 |
| 2889 | 2889 | 3 | ticket | 0 | 0 | 73 | SA is not moving machines to VLANs, IAS is working fine. | 30 | 0 | 30 | 0 | 0 | developmt | 0 | 2006-11-08 18:43:37 | 1970-01-01 00:00:00 | 2006-11-03 21:04:45 | 2006-11-11 03:50:14 | 1970-01-01 00:00:00 | 403 | 2006-11-29 20:34:20 | 73 | 2006-11-03 20:50:14 | 0 |
| 2586 | 2586 | 3 | ticket | 0 | 0 | 10 | SA AV test for "Verizon Internet Security Suite?" | 30 | 0 | 30 | 0 | 0 | developmt | 0 | NULL | 1970-01-01 00:00:00 | 2006-10-09 21:34:24 | 2006-10-17 03:10:58 | 1970-01-01 00:00:00 | 403 | 2006-10-19 19:29:33 | 33 | 2006-10-09 21:10:58 | 0 |
| 2949 | 2949 | 3 | ticket | 0 | 0 | 626 | IE7 Error | 30 | 0 | 30 | 0 | 0 | developmt | 0 | 2006-12-05 18:49:05 | 1970-01-01 00:00:00 | 2006-12-05 18:49:03 | 2006-12-06 19:50:37 | 1970-01-01 00:00:00 | 626 | 2006-12-05 18:51:10 | 331 | 2006-11-29 19:50:37 | 0 |
+------+-------------+-------+--------+----------------+------------+-------+----------------------------------------------------------+-----------------+---------------+----------+---------------+------------+-----------+----------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------+---------------------+---------+---------------------+----------+
4 rows in set (0.01 sec)
mysql> tee /var/tmp/result-2.txt
-------------- next part --------------
mysql> source /var/tmp/sql-3.txt
+------+-------------+-------+--------+----------------+------------+-------+----------------------------------------------------------+-----------------+---------------+----------+---------------+------------+-----------+----------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------+---------------------+---------+---------------------+----------+
| id | EffectiveId | Queue | Type | IssueStatement | Resolution | Owner | Subject | InitialPriority | FinalPriority | Priority | TimeEstimated | TimeWorked | Status | TimeLeft | Told | Starts | Started | Due | Resolved | LastUpdatedBy | LastUpdated | Creator | Created | Disabled |
+------+-------------+-------+--------+----------------+------------+-------+----------------------------------------------------------+-----------------+---------------+----------+---------------+------------+-----------+----------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------+---------------------+---------+---------------------+----------+
| 2949 | 2949 | 3 | ticket | 0 | 0 | 626 | IE7 Error | 30 | 0 | 30 | 0 | 0 | developmt | 0 | 2006-12-05 18:49:05 | 1970-01-01 00:00:00 | 2006-12-05 18:49:03 | 2006-12-06 19:50:37 | 1970-01-01 00:00:00 | 626 | 2006-12-05 18:51:10 | 331 | 2006-11-29 19:50:37 | 0 |
| 2787 | 2787 | 3 | ticket | 0 | 0 | 33 | Re: Traveling | 30 | 0 | 30 | 0 | 0 | developmt | 0 | NULL | 1970-01-01 00:00:00 | 2006-11-02 22:54:40 | 2006-10-29 18:56:06 | 1970-01-01 00:00:00 | 626 | 2006-12-08 20:23:20 | 1008 | 2006-10-22 18:56:06 | 0 |
| 2889 | 2889 | 3 | ticket | 0 | 0 | 73 | SA is not moving machines to VLANs, IAS is working fine. | 30 | 0 | 30 | 0 | 0 | developmt | 0 | 2006-11-08 18:43:37 | 1970-01-01 00:00:00 | 2006-11-03 21:04:45 | 2006-11-11 03:50:14 | 1970-01-01 00:00:00 | 403 | 2006-11-29 20:34:20 | 73 | 2006-11-03 20:50:14 | 0 |
| 2586 | 2586 | 3 | ticket | 0 | 0 | 10 | SA AV test for "Verizon Internet Security Suite?" | 30 | 0 | 30 | 0 | 0 | developmt | 0 | NULL | 1970-01-01 00:00:00 | 2006-10-09 21:34:24 | 2006-10-17 03:10:58 | 1970-01-01 00:00:00 | 403 | 2006-10-19 19:29:33 | 33 | 2006-10-09 21:10:58 | 0 |
+------+-------------+-------+--------+----------------+------------+-------+----------------------------------------------------------+-----------------+---------------+----------+---------------+------------+-----------+----------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------+---------------------+---------+---------------------+----------+
4 rows in set (0.00 sec)
mysql> tee /var/tmp/result-4.txt
-------------- next part --------------
mysql> source /var/tmp/sql-4.txt
+--------------+------+-------------+-------+--------+----------------+------------+-------+----------------------------------------------------------+-----------------+---------------+----------+---------------+------------+-----------+----------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------+---------------------+---------+---------------------+----------+
| Name | id | EffectiveId | Queue | Type | IssueStatement | Resolution | Owner | Subject | InitialPriority | FinalPriority | Priority | TimeEstimated | TimeWorked | Status | TimeLeft | Told | Starts | Started | Due | Resolved | LastUpdatedBy | LastUpdated | Creator | Created | Disabled |
+--------------+------+-------------+-------+--------+----------------+------------+-------+----------------------------------------------------------+-----------------+---------------+----------+---------------+------------+-----------+----------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------+---------------------+---------+---------------------+----------+
| 1 - CRITICAL | 2949 | 2949 | 3 | ticket | 0 | 0 | 626 | IE7 Error | 30 | 0 | 30 | 0 | 0 | developmt | 0 | 2006-12-05 18:49:05 | 1970-01-01 00:00:00 | 2006-12-05 18:49:03 | 2006-12-06 19:50:37 | 1970-01-01 00:00:00 | 626 | 2006-12-05 18:51:10 | 331 | 2006-11-29 19:50:37 | 0 |
| 2 - Major | 2889 | 2889 | 3 | ticket | 0 | 0 | 73 | SA is not moving machines to VLANs, IAS is working fine. | 30 | 0 | 30 | 0 | 0 | developmt | 0 | 2006-11-08 18:43:37 | 1970-01-01 00:00:00 | 2006-11-03 21:04:45 | 2006-11-11 03:50:14 | 1970-01-01 00:00:00 | 403 | 2006-11-29 20:34:20 | 73 | 2006-11-03 20:50:14 | 0 |
| 2 - Major | 2787 | 2787 | 3 | ticket | 0 | 0 | 33 | Re: Traveling | 30 | 0 | 30 | 0 | 0 | developmt | 0 | NULL | 1970-01-01 00:00:00 | 2006-11-02 22:54:40 | 2006-10-29 18:56:06 | 1970-01-01 00:00:00 | 626 | 2006-12-08 20:23:20 | 1008 | 2006-10-22 18:56:06 | 0 |
| 3 - Minor | 2586 | 2586 | 3 | ticket | 0 | 0 | 10 | SA AV test for "Verizon Internet Security Suite?" | 30 | 0 | 30 | 0 | 0 | developmt | 0 | NULL | 1970-01-01 00:00:00 | 2006-10-09 21:34:24 | 2006-10-17 03:10:58 | 1970-01-01 00:00:00 | 403 | 2006-10-19 19:29:33 | 33 | 2006-10-09 21:10:58 | 0 |
+--------------+------+-------------+-------+--------+----------------+------------+-------+----------------------------------------------------------+-----------------+---------------+----------+---------------+------------+-----------+----------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------+---------------------+---------+---------------------+----------+
4 rows in set (0.01 sec)
-------------- next part --------------
SELECT DISTINCT main.* FROM ((((Tickets main
LEFT JOIN ObjectCustomFields ObjectCustomFields_1 ON ((ObjectCustomFields_1.ObjectId = '0'))
OR ( ObjectCustomFields_1.ObjectId = main.Queue))
LEFT JOIN CustomFields CustomFields_2
ON ( CustomFields_2.id = ObjectCustomFields_1.CustomField))
LEFT JOIN ObjectCustomFieldValues ObjectCustomFieldValues_3
ON ((ObjectCustomFieldValues_3.ObjectId = main.id))
AND ( ObjectCustomFieldValues_3.CustomField = CustomFields_2.id)
AND ( (ObjectCustomFieldValues_3.Disabled = '0'))
AND ( (ObjectCustomFieldValues_3.ObjectType = 'RT::Ticket')))
LEFT JOIN CustomFieldValues CustomFieldValues_4
ON ((CustomFieldValues_4.Name = ObjectCustomFieldValues_3.Content))
AND ( CustomFieldValues_4.CustomField = ObjectCustomFieldValues_3.CustomField))
WHERE ((main.EffectiveId = main.id))
AND ((main.Status != 'deleted'))
AND ((main.Type = 'ticket'))
AND ((main.Status = 'developmt'))
ORDER BY CustomFieldValues_4.SortOrder ASC,
ObjectCustomFieldValues_3.Content ASC LIMIT 100
-------------- next part --------------
SELECT DISTINCT CustomFieldValues_4.Name, main.* FROM ((((Tickets main
LEFT JOIN ObjectCustomFields ObjectCustomFields_1 ON ((ObjectCustomFields_1.ObjectId = '0'))
OR ( ObjectCustomFields_1.ObjectId = main.Queue))
LEFT JOIN CustomFields CustomFields_2
ON ( CustomFields_2.id = ObjectCustomFields_1.CustomField))
LEFT JOIN ObjectCustomFieldValues ObjectCustomFieldValues_3
ON ((ObjectCustomFieldValues_3.ObjectId = main.id))
AND ( ObjectCustomFieldValues_3.CustomField = CustomFields_2.id)
AND ( (ObjectCustomFieldValues_3.Disabled = '0'))
AND ( (ObjectCustomFieldValues_3.ObjectType = 'RT::Ticket')))
LEFT JOIN CustomFieldValues CustomFieldValues_4
ON ((CustomFieldValues_4.Name = ObjectCustomFieldValues_3.Content))
AND ( CustomFieldValues_4.CustomField = ObjectCustomFieldValues_3.CustomField))
WHERE ((main.EffectiveId = main.id))
AND ((main.Status != 'deleted'))
AND ((main.Type = 'ticket'))
AND ((main.Status = 'developmt'))
ORDER BY CustomFieldValues_4.SortOrder ASC,
ObjectCustomFieldValues_3.Content ASC LIMIT 100
-------------- next part --------------
SELECT DISTINCT main.* FROM ((((Tickets main
LEFT JOIN ObjectCustomFields ObjectCustomFields_1 ON ((ObjectCustomFields_1.ObjectId = '0'))
OR ( ObjectCustomFields_1.ObjectId = main.Queue))
LEFT JOIN CustomFields CustomFields_2
ON ( CustomFields_2.id = ObjectCustomFields_1.CustomField))
LEFT JOIN ObjectCustomFieldValues ObjectCustomFieldValues_3
ON ((ObjectCustomFieldValues_3.ObjectId = main.id))
AND ( ObjectCustomFieldValues_3.CustomField = CustomFields_2.id)
AND ( (ObjectCustomFieldValues_3.Disabled = '0'))
AND ( (ObjectCustomFieldValues_3.ObjectType = 'RT::Ticket')))
LEFT JOIN CustomFieldValues CustomFieldValues_4
ON ((CustomFieldValues_4.Name = ObjectCustomFieldValues_3.Content))
AND ( CustomFieldValues_4.CustomField = ObjectCustomFieldValues_3.CustomField)
LEFT JOIN CustomFields as CustomFields_5
ON ( CustomFields_5.id = ObjectCustomFields_1.CustomField))
WHERE ((main.EffectiveId = main.id))
AND ((main.Status != 'deleted'))
AND ((main.Type = 'ticket'))
AND ((main.Status = 'developmt'))
AND ((CustomFields_5.Name = 'severity' ))
ORDER BY CustomFieldValues_4.SortOrder ASC,
ObjectCustomFieldValues_3.Content ASC LIMIT 100
-------------- next part --------------
SELECT DISTINCT CustomFieldValues_4.Name, main.* FROM ((((Tickets main
LEFT JOIN ObjectCustomFields ObjectCustomFields_1 ON ((ObjectCustomFields_1.ObjectId = '0'))
OR ( ObjectCustomFields_1.ObjectId = main.Queue))
LEFT JOIN CustomFields CustomFields_2
ON ( CustomFields_2.id = ObjectCustomFields_1.CustomField))
LEFT JOIN ObjectCustomFieldValues ObjectCustomFieldValues_3
ON ((ObjectCustomFieldValues_3.ObjectId = main.id))
AND ( ObjectCustomFieldValues_3.CustomField = CustomFields_2.id)
AND ( (ObjectCustomFieldValues_3.Disabled = '0'))
AND ( (ObjectCustomFieldValues_3.ObjectType = 'RT::Ticket')))
LEFT JOIN CustomFieldValues CustomFieldValues_4
ON ((CustomFieldValues_4.Name = ObjectCustomFieldValues_3.Content))
AND ( CustomFieldValues_4.CustomField = ObjectCustomFieldValues_3.CustomField)
LEFT JOIN CustomFields as CustomFields_5
ON ( CustomFields_5.id = ObjectCustomFields_1.CustomField))
WHERE ((main.EffectiveId = main.id))
AND ((main.Status != 'deleted'))
AND ((main.Type = 'ticket'))
AND ((main.Status = 'developmt'))
AND ((CustomFields_5.Name = 'severity' ))
ORDER BY CustomFieldValues_4.SortOrder ASC,
ObjectCustomFieldValues_3.Content ASC LIMIT 100
-------------- next part --------------
mysql> source /var/tmp/sql-2.txt
+----------------------+------+-------------+-------+--------+----------------+------------+-------+----------------------------------------------------------+-----------------+---------------+----------+---------------+------------+-----------+----------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------+---------------------+---------+---------------------+----------+
| Name | id | EffectiveId | Queue | Type | IssueStatement | Resolution | Owner | Subject | InitialPriority | FinalPriority | Priority | TimeEstimated | TimeWorked | Status | TimeLeft | Told | Starts | Started | Due | Resolved | LastUpdatedBy | LastUpdated | Creator | Created | Disabled |
+----------------------+------+-------------+-------+--------+----------------+------------+-------+----------------------------------------------------------+-----------------+---------------+----------+---------------+------------+-----------+----------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------+---------------------+---------+---------------------+----------+
| NULL | 2949 | 2949 | 3 | ticket | 0 | 0 | 626 | IE7 Error | 30 | 0 | 30 | 0 | 0 | developmt | 0 | 2006-12-05 18:49:05 | 1970-01-01 00:00:00 | 2006-12-05 18:49:03 | 2006-12-06 19:50:37 | 1970-01-01 00:00:00 | 626 | 2006-12-05 18:51:10 | 331 | 2006-11-29 19:50:37 | 0 |
| NULL | 2586 | 2586 | 3 | ticket | 0 | 0 | 10 | SA AV test for "Verizon Internet Security Suite?" | 30 | 0 | 30 | 0 | 0 | developmt | 0 | NULL | 1970-01-01 00:00:00 | 2006-10-09 21:34:24 | 2006-10-17 03:10:58 | 1970-01-01 00:00:00 | 403 | 2006-10-19 19:29:33 | 33 | 2006-10-09 21:10:58 | 0 |
| NULL | 2889 | 2889 | 3 | ticket | 0 | 0 | 73 | SA is not moving machines to VLANs, IAS is working fine. | 30 | 0 | 30 | 0 | 0 | developmt | 0 | 2006-11-08 18:43:37 | 1970-01-01 00:00:00 | 2006-11-03 21:04:45 | 2006-11-11 03:50:14 | 1970-01-01 00:00:00 | 403 | 2006-11-29 20:34:20 | 73 | 2006-11-03 20:50:14 | 0 |
| NULL | 2787 | 2787 | 3 | ticket | 0 | 0 | 33 | Re: Traveling | 30 | 0 | 30 | 0 | 0 | developmt | 0 | NULL | 1970-01-01 00:00:00 | 2006-11-02 22:54:40 | 2006-10-29 18:56:06 | 1970-01-01 00:00:00 | 626 | 2006-12-08 20:23:20 | 1008 | 2006-10-22 18:56:06 | 0 |
| 1 | 2949 | 2949 | 3 | ticket | 0 | 0 | 626 | IE7 Error | 30 | 0 | 30 | 0 | 0 | developmt | 0 | 2006-12-05 18:49:05 | 1970-01-01 00:00:00 | 2006-12-05 18:49:03 | 2006-12-06 19:50:37 | 1970-01-01 00:00:00 | 626 | 2006-12-05 18:51:10 | 331 | 2006-11-29 19:50:37 | 0 |
| 1 | 2787 | 2787 | 3 | ticket | 0 | 0 | 33 | Re: Traveling | 30 | 0 | 30 | 0 | 0 | developmt | 0 | NULL | 1970-01-01 00:00:00 | 2006-11-02 22:54:40 | 2006-10-29 18:56:06 | 1970-01-01 00:00:00 | 626 | 2006-12-08 20:23:20 | 1008 | 2006-10-22 18:56:06 | 0 |
| 1 | 2586 | 2586 | 3 | ticket | 0 | 0 | 10 | SA AV test for "Verizon Internet Security Suite?" | 30 | 0 | 30 | 0 | 0 | developmt | 0 | NULL | 1970-01-01 00:00:00 | 2006-10-09 21:34:24 | 2006-10-17 03:10:58 | 1970-01-01 00:00:00 | 403 | 2006-10-19 19:29:33 | 33 | 2006-10-09 21:10:58 | 0 |
| customer foo | 2889 | 2889 | 3 | ticket | 0 | 0 | 73 | SA is not moving machines to VLANs, IAS is working fine. | 30 | 0 | 30 | 0 | 0 | developmt | 0 | 2006-11-08 18:43:37 | 1970-01-01 00:00:00 | 2006-11-03 21:04:45 | 2006-11-11 03:50:14 | 1970-01-01 00:00:00 | 403 | 2006-11-29 20:34:20 | 73 | 2006-11-03 20:50:14 | 0 |
| Full | 2586 | 2586 | 3 | ticket | 0 | 0 | 10 | SA AV test for "Verizon Internet Security Suite?" | 30 | 0 | 30 | 0 | 0 | developmt | 0 | NULL | 1970-01-01 00:00:00 | 2006-10-09 21:34:24 | 2006-10-17 03:10:58 | 1970-01-01 00:00:00 | 403 | 2006-10-19 19:29:33 | 33 | 2006-10-09 21:10:58 | 0 |
| Full | 2787 | 2787 | 3 | ticket | 0 | 0 | 33 | Re: Traveling | 30 | 0 | 30 | 0 | 0 | developmt | 0 | NULL | 1970-01-01 00:00:00 | 2006-11-02 22:54:40 | 2006-10-29 18:56:06 | 1970-01-01 00:00:00 | 626 | 2006-12-08 20:23:20 | 1008 | 2006-10-22 18:56:06 | 0 |
| Full | 2949 | 2949 | 3 | ticket | 0 | 0 | 626 | IE7 Error | 30 | 0 | 30 | 0 | 0 | developmt | 0 | 2006-12-05 18:49:05 | 1970-01-01 00:00:00 | 2006-12-05 18:49:03 | 2006-12-06 19:50:37 | 1970-01-01 00:00:00 | 626 | 2006-12-05 18:51:10 | 331 | 2006-11-29 19:50:37 | 0 |
| customer bar | 2949 | 2949 | 3 | ticket | 0 | 0 | 626 | IE7 Error | 30 | 0 | 30 | 0 | 0 | developmt | 0 | 2006-12-05 18:49:05 | 1970-01-01 00:00:00 | 2006-12-05 18:49:03 | 2006-12-06 19:50:37 | 1970-01-01 00:00:00 | 626 | 2006-12-05 18:51:10 | 331 | 2006-11-29 19:50:37 | 0 |
| problem | 2949 | 2949 | 3 | ticket | 0 | 0 | 626 | IE7 Error | 30 | 0 | 30 | 0 | 0 | developmt | 0 | 2006-12-05 18:49:05 | 1970-01-01 00:00:00 | 2006-12-05 18:49:03 | 2006-12-06 19:50:37 | 1970-01-01 00:00:00 | 626 | 2006-12-05 18:51:10 | 331 | 2006-11-29 19:50:37 | 0 |
| problem | 2586 | 2586 | 3 | ticket | 0 | 0 | 10 | SA AV test for "Verizon Internet Security Suite?" | 30 | 0 | 30 | 0 | 0 | developmt | 0 | NULL | 1970-01-01 00:00:00 | 2006-10-09 21:34:24 | 2006-10-17 03:10:58 | 1970-01-01 00:00:00 | 403 | 2006-10-19 19:29:33 | 33 | 2006-10-09 21:10:58 | 0 |
| problem | 2889 | 2889 | 3 | ticket | 0 | 0 | 73 | SA is not moving machines to VLANs, IAS is working fine. | 30 | 0 | 30 | 0 | 0 | developmt | 0 | 2006-11-08 18:43:37 | 1970-01-01 00:00:00 | 2006-11-03 21:04:45 | 2006-11-11 03:50:14 | 1970-01-01 00:00:00 | 403 | 2006-11-29 20:34:20 | 73 | 2006-11-03 20:50:14 | 0 |
| problem | 2787 | 2787 | 3 | ticket | 0 | 0 | 33 | Re: Traveling | 30 | 0 | 30 | 0 | 0 | developmt | 0 | NULL | 1970-01-01 00:00:00 | 2006-11-02 22:54:40 | 2006-10-29 18:56:06 | 1970-01-01 00:00:00 | 626 | 2006-12-08 20:23:20 | 1008 | 2006-10-22 18:56:06 | 0 |
| Update (tests/rules) | 2586 | 2586 | 3 | ticket | 0 | 0 | 10 | SA AV test for "Verizon Internet Security Suite?" | 30 | 0 | 30 | 0 | 0 | developmt | 0 | NULL | 1970-01-01 00:00:00 | 2006-10-09 21:34:24 | 2006-10-17 03:10:58 | 1970-01-01 00:00:00 | 403 | 2006-10-19 19:29:33 | 33 | 2006-10-09 21:10:58 | 0 |
| 1 - CRITICAL | 2949 | 2949 | 3 | ticket | 0 | 0 | 626 | IE7 Error | 30 | 0 | 30 | 0 | 0 | developmt | 0 | 2006-12-05 18:49:05 | 1970-01-01 00:00:00 | 2006-12-05 18:49:03 | 2006-12-06 19:50:37 | 1970-01-01 00:00:00 | 626 | 2006-12-05 18:51:10 | 331 | 2006-11-29 19:50:37 | 0 |
| 2 - Major | 2889 | 2889 | 3 | ticket | 0 | 0 | 73 | SA is not moving machines to VLANs, IAS is working fine. | 30 | 0 | 30 | 0 | 0 | developmt | 0 | 2006-11-08 18:43:37 | 1970-01-01 00:00:00 | 2006-11-03 21:04:45 | 2006-11-11 03:50:14 | 1970-01-01 00:00:00 | 403 | 2006-11-29 20:34:20 | 73 | 2006-11-03 20:50:14 | 0 |
| 2 - Major | 2787 | 2787 | 3 | ticket | 0 | 0 | 33 | Re: Traveling | 30 | 0 | 30 | 0 | 0 | developmt | 0 | NULL | 1970-01-01 00:00:00 | 2006-11-02 22:54:40 | 2006-10-29 18:56:06 | 1970-01-01 00:00:00 | 626 | 2006-12-08 20:23:20 | 1008 | 2006-10-22 18:56:06 | 0 |
| SA | 2949 | 2949 | 3 | ticket | 0 | 0 | 626 | IE7 Error | 30 | 0 | 30 | 0 | 0 | developmt | 0 | 2006-12-05 18:49:05 | 1970-01-01 00:00:00 | 2006-12-05 18:49:03 | 2006-12-06 19:50:37 | 1970-01-01 00:00:00 | 626 | 2006-12-05 18:51:10 | 331 | 2006-11-29 19:50:37 | 0 |
| SA | 2586 | 2586 | 3 | ticket | 0 | 0 | 10 | SA AV test for "Verizon Internet Security Suite?" | 30 | 0 | 30 | 0 | 0 | developmt | 0 | NULL | 1970-01-01 00:00:00 | 2006-10-09 21:34:24 | 2006-10-17 03:10:58 | 1970-01-01 00:00:00 | 403 | 2006-10-19 19:29:33 | 33 | 2006-10-09 21:10:58 | 0 |
| SA | 2889 | 2889 | 3 | ticket | 0 | 0 | 73 | SA is not moving machines to VLANs, IAS is working fine. | 30 | 0 | 30 | 0 | 0 | developmt | 0 | 2006-11-08 18:43:37 | 1970-01-01 00:00:00 | 2006-11-03 21:04:45 | 2006-11-11 03:50:14 | 1970-01-01 00:00:00 | 403 | 2006-11-29 20:34:20 | 73 | 2006-11-03 20:50:14 | 0 |
| SA | 2787 | 2787 | 3 | ticket | 0 | 0 | 33 | Re: Traveling | 30 | 0 | 30 | 0 | 0 | developmt | 0 | NULL | 1970-01-01 00:00:00 | 2006-11-02 22:54:40 | 2006-10-29 18:56:06 | 1970-01-01 00:00:00 | 626 | 2006-12-08 20:23:20 | 1008 | 2006-10-22 18:56:06 | 0 |
| 3 - Minor | 2586 | 2586 | 3 | ticket | 0 | 0 | 10 | SA AV test for "Verizon Internet Security Suite?" | 30 | 0 | 30 | 0 | 0 | developmt | 0 | NULL | 1970-01-01 00:00:00 | 2006-10-09 21:34:24 | 2006-10-17 03:10:58 | 1970-01-01 00:00:00 | 403 | 2006-10-19 19:29:33 | 33 | 2006-10-09 21:10:58 | 0 |
+----------------------+------+-------------+-------+--------+----------------+------------+-------+----------------------------------------------------------+-----------------+---------------+----------+---------------+------------+-----------+----------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------+---------------------+---------+---------------------+----------+
25 rows in set (0.02 sec)
mysql> tee /var/tmp/result-3.txt
More information about the rt-users
mailing list