create view  e2e_wrm_wrmreportdetailv AS
SELECT     dbo.e2e_wrm_wrmreport.timestart, dbo.e2e_wrm_countersource.sourcename, dbo.e2e_wrm_wrmtype.name AS type,
                      dbo.e2e_wrm_wrmidentifier.name AS transactionname, dbo.e2e_wrm_countersource.hostname, WRMIdentifier_1.name AS identifier,
                      dbo.e2e_wrm_weblogurl.url, dbo.e2e_wrm_wrmstatusmessage.message, wrmstat_2.name AS summarystatus, wrmstat_1.name AS accuracystatus,
                      dbo.e2e_wrm_wrmreport.resptime, dbo.e2e_wrm_wrmreport.firstbytems, dbo.e2e_wrm_wrmreport.statuscode, dbo.e2e_wrm_wrmreport.bytesrec,
                      dbo.e2e_wrm_wrmreport.retrycount, dbo.e2e_wrm_wrmreport.connecttimems, dbo.e2e_wrm_wrmreport.pingtimems,
                      dbo.e2e_wrm_wrmreport.timefactor, dbo.e2e_wrm_wrmgroup.name AS groupname, dbo.e2e_wrm_wrmrequestname.name AS requestname,
                      dbo.e2e_wrm_wrmreport.pctresptime, dbo.e2e_wrm_wrmreport.maxresptime, dbo.e2e_wrm_wrmreport.minresptime
FROM         dbo.e2e_wrm_wrmreport INNER JOIN
                      dbo.e2e_wrm_countersource ON dbo.e2e_wrm_wrmreport.sourceid = dbo.e2e_wrm_countersource.sourceid LEFT OUTER JOIN
                      dbo.e2e_wrm_wrmtype ON dbo.e2e_wrm_wrmreport.typeid = dbo.e2e_wrm_wrmtype.typeid LEFT OUTER JOIN
                      dbo.e2e_wrm_wrmgroup ON dbo.e2e_wrm_wrmreport.groupid = dbo.e2e_wrm_wrmgroup.groupid LEFT OUTER JOIN
                      dbo.e2e_wrm_wrmrequestname ON dbo.e2e_wrm_wrmreport.requestnameid = dbo.e2e_wrm_wrmrequestname.requestnameid LEFT OUTER JOIN
                      dbo.e2e_wrm_weblogurl ON dbo.e2e_wrm_wrmreport.urlid = dbo.e2e_wrm_weblogurl.urlid LEFT OUTER JOIN
                      dbo.e2e_wrm_wrmidentifier ON dbo.e2e_wrm_wrmreport.transactionid = dbo.e2e_wrm_wrmidentifier.identifierid LEFT OUTER JOIN
                      dbo.e2e_wrm_wrmidentifier WRMIdentifier_1 ON dbo.e2e_wrm_wrmreport.identifierid = WRMIdentifier_1.identifierid LEFT OUTER JOIN
                      dbo.e2e_wrm_wrmstatusmessage ON
                      dbo.e2e_wrm_wrmreport.statusmessageid = dbo.e2e_wrm_wrmstatusmessage.statusmessageid LEFT OUTER JOIN
                      dbo.e2e_wrm_wrmstat wrmstat_1 ON dbo.e2e_wrm_wrmreport.newaccuracystatid = wrmstat_1.statusid LEFT OUTER JOIN
                      dbo.e2e_wrm_wrmstat wrmstat_2 ON dbo.e2e_wrm_wrmreport.newsumstatid = wrmstat_2.statusid


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