-- ## 30: APP_SERVER_RESOURCE ## --

SELECT DISTINCT t.id as Ticket, t.summary as Summary, t.milestone as Milestone, t.owner as Owner, t.status as Status
   FROM ticket t
WHERE 
t.summary LIKE '%APP_SERVER_RESOURCE%R0'