create view  e2e_wrm_wrmnotsentdetailv AS
SELECT e2e_wrm_wrm.timestart, e2e_wrm_wrm.timeend, e2e_wrm_countersource.sourcename,
e2e_wrm_wrmtype.name AS type, e2e_wrm_wrmidentifier.name AS transactionname,
e2e_wrm_countersource.hostname, e2e_wrm_weblogurl.url,
wrmidentifier_1.name AS identifier,
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 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
INNER 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
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
WHERE (e2e_wrm_wrm.issent = 0)


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