create view  e2e_wrm_wrmgroupsummaryv AS
SELECT e2e_wrm_wrmreport.timestart, e2e_wrm_wrmstat.name AS summarystatus,
e2e_wrm_wrmtype.name AS type, e2e_wrm_weblogurl.url,
e2e_wrm_wrmidentifier.name AS transactionname, e2e_wrm_wrmgroup.name AS groupname,
e2e_wrm_countersource.sourcename, e2e_wrm_countersource.hostname, e2e_wrm_wrmreport.timefactor FROM  e2e_wrm_wrmreport INNER JOIN  e2e_wrm_wrmgroup ON e2e_wrm_wrmreport.groupid = e2e_wrm_wrmgroup.groupid INNER JOIN  e2e_wrm_countersource ON e2e_wrm_wrmreport.sourceid = e2e_wrm_countersource.sourceid LEFT OUTER JOIN  e2e_wrm_wrmidentifier ON e2e_wrm_wrmreport.transactionid = e2e_wrm_wrmidentifier.identifierid LEFT OUTER JOIN  e2e_wrm_wrmtype ON e2e_wrm_wrmreport.typeid = e2e_wrm_wrmtype.typeid LEFT OUTER JOIN  e2e_wrm_wrmstat ON e2e_wrm_wrmreport.newsumstatid = e2e_wrm_wrmstat.statusid LEFT OUTER JOIN  e2e_wrm_weblogurl ON e2e_wrm_wrmreport.urlid = e2e_wrm_weblogurl.urlid WHERE (e2e_wrm_wrmreport.transactionid = 0) AND (e2e_wrm_wrmreport.urlid IS NOT NULL) OR (e2e_wrm_wrmreport.transactionid IS NOT NULL) AND (e2e_wrm_wrmreport.urlid IS NULL)


GO
GRANT SELECT ON  [dbo].[e2e_wrm_wrmgroupsummaryv] TO [apmadmin]
GO