create view  e2e_apm_AnalysisDetailV
    AS SELECT r.start_datetime AS TStamp,r.app_id AS APPID, a.app_name AS APPLICATION,r.op_id AS OPID, o.op_name AS OPERATION,
        r.server_id AS SERVERID, s.server_name AS SERVER, r.client_id AS CLIENTID, c.client_name AS CLIENT,
        r.user_id AS USERID, 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.delta_threshold AS DELTA_THRESHOLD, dbo.float8(r.exception_threshold)/1000 AS THRESHOLD,
        dbo.float8(r.net_total) /1000 AS NETTOTAL, dbo.float8(r.net_global) /1000 AS NETGLOBAL, r.cpu_util AS CPUUTIL,
        r.mem_util AS MEMUTIL, a.app_name + '/' + o.op_name AS APPOPNAME,
        r.host_id AS HOSTID, h.host_name AS HOSTIP, h.local_name AS HOSTNAME
    FROM  e2e_apm_application a INNER JOIN  e2e_apm_resp_data 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 INNER JOIN  e2e_apm_host h ON r.host_id = h.host_id


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