Skip to content

Instantly share code, notes, and snippets.

@hakandilek
hakandilek / gist:3968354
Created October 28, 2012 11:14 — forked from hozturk/gist:3968338
report request
{
"request":{
"ReportId":"Test.E02R01" ,
"Profile": {
"Period":"01",
"DataServerType":"1",
"Firm":"001",
"DataServerId":"1"
} ,
"Parameters":[
-- Connections
select c.session_id,
c.auth_scheme,
c.last_read,
c.last_write,
c.client_net_address,
c.local_tcp_port,
st.text as lastQuery
from sys.dm_exec_connections c
cross apply sys.dm_exec_sql_text(c.most_recent_sql_handle) st