<?xml version="1.0"?>
<!-- Custom Reports -->
<Reports>
<Group Title="Custom Reports">
<Rep Name="Track File Download History" id="1007">
<Query>SELECT Date_Time.Date, Round(Sum(Hit.BytesOut)/1000000) AS [File Downloads]
FROM (Hit INNER JOIN (Date_Time INNER JOIN xDateFilter ON Date_Time.ID = xDateFilter.ID) ON Hit.DateTimeID = Date_Time.ID) 
INNER JOIN File ON Hit.FileID = File.ID
WHERE (((File.FileName)="/download/filename.zip"))
GROUP BY Date_Time.Date
ORDER BY Date_Time.Date;</Query>
</Rep>
</Group>
</Reports>
