create view  e2e_apm_GeneralDetail_dayV AS SELECT a.app_name AS APPLICATION, r.app_id AS APPID, 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, r.user_id AS USERID, r.op_id AS OPID, o.op_name AS OPERATION, r.server_id AS SERVERID, r.client_id AS CLIENTID, c.client_name AS CLIENT, s.server_name AS SERVER, r.duration AS MAXRESPONSETIME, r.duration AS MINRESPONSETIME, r.local_dur AS MAXLOCALTIME, r.wire_dur AS MAXNETWORKTIME, r.server_dur AS MAXSERVERTIME, r.server_dur AS MINSERVERTIME, a.app_name + '/' + o.op_name AS APPOPNAME 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 INNER JOIN  e2e_apm_client c ON r.client_id = c.client_id INNER JOIN  e2e_apm_server s ON r.server_id = s.server_id


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