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