create view  e2e_wrm_wrmdetailv AS
SELECT e2e_wrm_wrm.timestart, e2e_wrm_countersource.sourcename, e2e_wrm_wrmtype.name AS type,
e2e_wrm_wrmidentifier.name AS transactionname, e2e_wrm_countersource.hostname,
wrmidentifier_1.name AS identifier, e2e_wrm_weblogurl.url, e2e_wrm_wrmstatusmessage.message,
wrmstat_2.name AS summarystatus, wrmstat_1.name AS accuracystatus,
e2e_wrm_wrm.resptime, e2e_wrm_wrm.firstbytems, e2e_wrm_wrm.statuscode,
e2e_wrm_wrm.bytesrec, e2e_wrm_wrm.retrycount, e2e_wrm_wrm.connecttimems,
e2e_wrm_wrm.pingtimems, e2e_wrm_wrmrequestname.name AS requestname
FROM  e2e_wrm_wrm INNER JOIN  e2e_wrm_countersource ON e2e_wrm_wrm.sourceid = e2e_wrm_countersource.sourceid
INNER JOIN  e2e_wrm_wrmtype ON e2e_wrm_wrm.typeid = e2e_wrm_wrmtype.typeid
LEFT OUTER JOIN  e2e_wrm_wrmrequestname ON e2e_wrm_wrm.requestnameid = e2e_wrm_wrmrequestname.requestnameid
LEFT OUTER JOIN  e2e_wrm_weblogurl ON e2e_wrm_wrm.urlid = e2e_wrm_weblogurl.urlid
LEFT OUTER JOIN  e2e_wrm_wrmidentifier ON e2e_wrm_wrm.transactionid = e2e_wrm_wrmidentifier.identifierid
LEFT OUTER JOIN  e2e_wrm_wrmidentifier wrmidentifier_1 ON e2e_wrm_wrm.identifierid = wrmidentifier_1.identifierid
LEFT OUTER JOIN  e2e_wrm_wrmstatusmessage ON e2e_wrm_wrm.statusmessageid = e2e_wrm_wrmstatusmessage.statusmessageid
LEFT OUTER JOIN  e2e_wrm_wrmstat wrmstat_1 ON e2e_wrm_wrm.newaccuracystatid = wrmstat_1.statusid
LEFT OUTER JOIN  e2e_wrm_wrmstat wrmstat_2 ON e2e_wrm_wrm.newsumstatid = wrmstat_2.statusid


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