Retrieve Event Frames and attribute values

SELECT ef.Name AS EventFrame, ef.StartTime, ef.EndTime,
efa.Name AS EventFrameAttribute,
efa.Path AS EventFrameAttributePath,
efa.Level AS EventFrameAttributeLevel,
efa.IsConfigurationItem,
cast(efs.Value as String) as AttrValue
FROM EventFrame.EventFrame ef
INNER JOIN EventFrame.EventFrameAttribute efa
ON efa.EventFrameID = ef.ID
INNER JOIN Data.EventFrameSnapshot efs
ON efs.EventFrameAttributeID = efa.ID
WHERE ef.StartTime > N'01-Jul-2012'
AND ef.EndTime < N'02-Jul-2012'
AND efa.EventFrameTemplateAttributeID IS NULL
ORDER BY ef.Name, ef.StartTime, ef.EndTime, efa.Path, efa.Name;

Find Event Frames in a certain time range and show individual attributes and their snapshot values.