[dbo].[e2e_apm_AppOpSummary_dayV]
create view e2e_apm_AppOpSummary_dayV AS SELECT a.app_id AS APPID, a.app_name AS APPLICATION, o.op_name AS OPERATION, r.duration AS DURATION, r.local_dur AS LOCALTIME, r.wire_dur AS NETWORKTIME, r.server_dur AS SERVERTIME, r.duration AS MAXDURATION, r.local_dur AS MAXLOCALTIME, r.wire_dur AS MAXNETWORKTIME, r.server_dur AS MAXSERVERTIME, r.start_datetime AS TStamp, r.num_complete AS COMPLETED, r.num_cancelled AS CANCELLED FROM e2e_apm_resp_data_day r INNER JOIN e2e_apm_application a ON r.app_id = a.app_id INNER JOIN e2e_apm_operation o ON r.op_id = o.op_id
GO
GRANT SELECT ON [dbo].[e2e_apm_AppOpSummary_dayV] TO [apmadmin]
GO
