DFC last DQL executed by a session

Axel_Gil

Hi,

Do you know any DFC code able to list the last DQL executed by a session?

I'd like to walk through the repository sessions and obtain the last DQL executed for every session.

Is it possible?

Thanks!

Find more posts tagged with

Comments

sivarry

Hi,

To my knowledge last DQL is not stored in the session but the last DFC/API/DQL command is translated into low level API code by Content server which is available in last_rpc and current_rpc attributes of SHOW_SESSIONS/LIST_SESSIONS

-Siva

Axel_Gil

Thanks Siva,

It is possible there is no way to obtain the last executed SQL or DQL form a Session.

It is a administrative method called GET_LAST_SQL but it only obtains the last SQL in database, no for session. (I don't know why copy/paste of administrative method name text format is so big, )

Yes, i know how to obtain RPC but that is not what i want...

I'm going to investigate a little bit more and if i don't find anything else i'll forgot it.

Thanks