[dbo].[e2e_wrm_wrmreportwnotrollv]
create view "e2e_wrm_wrmreportwnotrollv" AS
SELECT "e2e_wrm_wrmreport"."sourceid", DATEADD([hour], (1 - DATEPART(weekday, timestart)) * 24, timestart) AS w, "e2e_wrm_wrmreport"."identifierid", "e2e_wrm_wrmreport"."typeid", "e2e_wrm_wrmreport"."urlid"
FROM "e2e_wrm_wrmreport"
WHERE (timefactor = 2) AND (IsSent = 0 OR IsSent IS NULL) AND (typeid = 1 OR typeid = 2)
GROUP BY sourceid, DATEADD([hour], (1 - DATEPART(weekday, timestart)) * 24, timestart), identifierid, typeid, urlid
GO
GRANT SELECT ON [dbo].[e2e_wrm_wrmreportwnotrollv] TO [apmadmin]
GO
