create view  e2e_wrm_wrmurlv AS
SELECT e2e_wrm_countersource.hostname, e2e_wrm_countersource.sourcename, e2e_wrm_weblogurl.url,
wrmidentifier_2.name AS transactionname,
e2e_wrm_wrmtype.name AS type, wrmidentifier_1.name AS identifier,
e2e_wrm_wrmstat.name AS status FROM  e2e_wrm_wrmstat
RIGHT OUTER JOIN  e2e_wrm_wrmreport
INNER JOIN  e2e_wrm_countersource ON e2e_wrm_wrmreport.sourceid = e2e_wrm_countersource.sourceid
INNER JOIN  e2e_wrm_weblogurl ON e2e_wrm_wrmreport.urlid = e2e_wrm_weblogurl.urlid
ON e2e_wrm_wrmstat.statusid = e2e_wrm_wrmreport.newsumstatid
LEFT OUTER JOIN  e2e_wrm_wrmidentifier wrmidentifier_1
ON e2e_wrm_wrmreport.identifierid = wrmidentifier_1.identifierid
LEFT OUTER JOIN  e2e_wrm_wrmtype ON e2e_wrm_wrmreport.typeid = e2e_wrm_wrmtype.typeid
LEFT OUTER JOIN  e2e_wrm_wrmidentifier wrmidentifier_2 ON e2e_wrm_wrmreport.transactionid = wrmidentifier_2.identifierid
GROUP BY e2e_wrm_weblogurl.url, e2e_wrm_countersource.hostname, e2e_wrm_countersource.sourcename, WRMIdentifier_2.name,wrmidentifier_1.name, e2e_wrm_wrmtype.name, e2e_wrm_wrmstat.name


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