create view e2e_apm_AnalysisAlertsV AS SELECT r.trans_id AS TRANSID, t.trans_state AS  TRANS_STATE,r.trans_wellness AS TRANS_WELLNESS,
r.num_exception AS EXCEPTION,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.delta_threshold AS DELTA_THRESHOLD, CONVERT(float(8), r.exception_threshold)/1000 AS THRESHOLD, CONVERT(float(8), r.net_total) /1000 AS NETTOTAL,
CONVERT(float(8), 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.ip 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_alert t ON r.trans_id = t.trans_id INNER JOIN e2e_apm_host h ON r.host_id =  h.host_id WHERE r.trans_wellness > 0


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