[dbo].[e2e_wrm_wrmtranrequestv]
create view e2e_wrm_wrmtranrequestv AS
SELECT e2e_wrm_countersource.hostname, e2e_wrm_countersource.sourcename,
wrmidentifier_2.name AS transactionname, e2e_wrm_wrmtype.name AS type,
e2e_wrm_wrmstat.name AS status, e2e_wrm_wrmrequestname.name AS requestname
FROM e2e_wrm_wrmrequestname RIGHT OUTER JOIN e2e_wrm_wrmreport
INNER JOIN e2e_wrm_countersource ON e2e_wrm_wrmreport.sourceid = e2e_wrm_countersource.sourceid ON e2e_wrm_wrmrequestname.requestnameid = e2e_wrm_wrmreport.requestnameid
LEFT OUTER JOIN e2e_wrm_wrmstat ON e2e_wrm_wrmreport.newsumstatid = e2e_wrm_wrmstat.statusid
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_countersource.hostname, e2e_wrm_countersource.sourcename, wrmidentifier_2.name, e2e_wrm_wrmtype.name, e2e_wrm_wrmstat.name, e2e_wrm_wrmrequestname.name
GO
GRANT SELECT ON [dbo].[e2e_wrm_wrmtranrequestv] TO [apmadmin]
GO
