Search Event Frames by template

SELECT ef.name, ef.Starttime, ef.endTime
FROM eventframe.eventframe ef
INNER JOIN eventframe.eventframeTemplate eft
ON ef.EventFrameTemplateID=eft.ID
WHERE eft.name='OSIProcedure'
AND ef.StartTime BETWEEN '04-jun-2012' AND '06-jun-2012'
ORDER BY 1;

Returns all event frames derived from a specific template and starting in a certain time range.