[dbo].[e2e_apm_SubTransactionsDetailV]
CREATE VIEW e2e_apm_SubTransactionsDetailV AS SELECT r.trans_id AS TRANSID,
r.app_id AS APPID, a.app_name AS APPNAME, r.op_id AS OPID, o.op_name AS OPNAME,
r.start_datetime AS TStamp, r.duration AS RESPONSETIME, s.query AS SUBTRANSNAME,
s.query_type AS SUBTRANSTYPE, s.duration AS SUBTRANSTIME, s.server_name AS SUBTRANSSERVER,
s.server_ip AS SUBTRANSSRVIP, s.server_port AS SUBTRANSSRVPORT, s.packets AS SUBTRANSPACKETS,
s.bytes AS SUBTRANSBYTES FROM e2e_apm_net_subs s INNER JOIN e2e_apm_resp_data r
ON s.parent_trans = r.trans_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
GO
GRANT SELECT ON [dbo].[e2e_apm_SubTransactionsDetailV] TO [apmadmin]
GO
