create view  e2e_apm_LocationDetailsV AS SELECT h.host_id AS HostID, h.ip AS IPADDRESS, h.host_name AS HOSTNAME, h.local_name AS LOCALNAME, h.os, h.aro_server AS AROSERVER, h.last_contact AS LASTCONTACT, h.thresh_version AS THRESH_VERSION,h.startup_time AS STARTUP_TIME, h.remark AS REMARK, r.trans_id AS TRANSID, r.app_id AS APPID, r.op_id AS OPID, r.client_id AS CLIENTID, r.user_id AS USERID, r.server_id AS SERVERID, a.app_name AS APPLICATION, o.op_name AS OPERATION, u.user_name AS USERNAME,c.client_name AS CLIENT, s.server_name AS SERVER, r.start_datetime AS TStamp,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 EXCEPTIONS, CONVERT(float(8), r.net_total)/1000 AS NETTOTAL, CONVERT(float(8), r.net_global)/1000 AS NETGLOBAL, r.delta_threshold AS DELTA_THRESHOLD, CONVERT(float(8), r.exception_threshold) AS THRESHOLD, r.cpu_util AS CPUUTIL, r.mem_util AS MEMUTIL, n.subnet AS SUBNET, n.octet1 AS OCTET1, n.octet2 AS OCTET2 , n.octet3 AS OCTET3 FROM  e2e_apm_host h INNER JOIN  e2e_apm_resp_data r ON h.host_id = r.host_id INNER JOIN  e2e_apm_client c ON c.client_id = r.client_id INNER JOIN  e2e_apm_server s ON s.server_id = r.server_id INNER JOIN  e2e_apm_user u ON u.user_id = r.user_id INNER JOIN  e2e_apm_application a ON a.app_id = r.app_id INNER JOIN  e2e_apm_operation o ON o.op_id = r.op_id INNER JOIN  e2e_apm_subnet n ON n.host_id = h.host_id


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