[dbo].[e2e_wrm_wrmgroupsv]
create view e2e_wrm_wrmgroupsv AS
SELECT e2e_wrm_countersource.hostname, e2e_wrm_countersource.sourcename,
e2e_wrm_wrmgroup.name as groupname, wrmstat.name AS summarystatus,
e2e_wrm_weblogurl.url, e2e_wrm_wrmidentifier.name AS identifier
FROM e2e_wrm_wrmstat wrmstat RIGHT OUTER JOIN e2e_wrm_wrmreport
INNER JOIN e2e_wrm_countersource ON e2e_wrm_wrmreport.sourceid = e2e_wrm_countersource.sourceid
INNER JOIN e2e_wrm_wrmgroup ON e2e_wrm_wrmreport.groupid = e2e_wrm_wrmgroup.groupid
INNER JOIN e2e_wrm_weblogurl ON e2e_wrm_wrmreport.urlid = e2e_wrm_weblogurl.urlid
INNER JOIN e2e_wrm_wrmidentifier ON e2e_wrm_wrmreport.identifierid = e2e_wrm_wrmidentifier.identifierid
ON wrmstat.statusid = e2e_wrm_wrmreport.newsumstatid
GROUP BY e2e_wrm_countersource.hostname, e2e_wrm_wrmgroup.name,
e2e_wrm_countersource.sourcename, wrmstat.name,
e2e_wrm_weblogurl.url, e2e_wrm_wrmidentifier.name
GO
GRANT SELECT ON [dbo].[e2e_wrm_wrmgroupsv] TO [apmadmin]
GO
