cancel
Showing results for 
Search instead for 
Did you mean: 

Connection activity

Former Member
2,000

Anyone knows how to see the lastActivity of each connection?

Accepted Solutions (0)

Answers (1)

Answers (1)

MarkCulp
Participant

If by "last Activity" you mean what did each connection do, when did it do it, then the easy answer is to use

select connection_property( 'LastReqTime', connid ),
       connection_property( 'LastStatement', connid )

to get this information about connection connid

See this documentation page for a full list of information about each connection that can be obtained by using connection_property() or connection_extended_property()

You can also get the connection activity information by using the sa_conn_activity() procedure.

FWIW: You can get the full list of properties for a connection (or all connections) by using the sa_conn_properties() procedure.

HTH

Breck_Carter
Participant
0 Kudos

Exactly how is connection_extended_property called without the second argument but with the third argument?

AFAIK in this context connection_property is the function of choice.

MarkCulp
Participant
0 Kudos

One doesn't try to omit a parameter ;-). I corrected my answer to use connection_property()