[dbo].[e2e_wrm_wrmtransactionv]
create view e2e_wrm_wrmtransactionv AS
SELECT e2e_wrm_countersource.hostname, e2e_wrm_countersource.sourcename,
e2e_wrm_wrmidentifier.name AS transactionname, e2e_wrm_wrmstat.name AS status
FROM e2e_wrm_wrmreport INNER JOIN e2e_wrm_countersource
ON e2e_wrm_wrmreport.sourceid = e2e_wrm_countersource.sourceid
INNER JOIN e2e_wrm_wrmidentifier ON e2e_wrm_wrmreport.transactionid = e2e_wrm_wrmidentifier.identifierid
LEFT OUTER JOIN e2e_wrm_wrmstat ON e2e_wrm_wrmstat.statusid = e2e_wrm_wrmreport.newsumstatid
GROUP BY e2e_wrm_countersource.hostname, e2e_wrm_countersource.sourcename, e2e_wrm_wrmidentifier.name, e2e_wrm_wrmstat.name
GO
GRANT SELECT ON [dbo].[e2e_wrm_wrmtransactionv] TO [apmadmin]
GO
