One query was aborted by the system dba from viewpoint. I could take out the record from dbqllogtbl_hst and that shows that it was aborted. Now, i want to know which was the user/IP of the machine from which this was aborted. Can someone help me how to take out this info ?
Hope you can get from Logonsource from dbc.dbqlogtbl :). Also other details are there, like querytext.... or other details from there can be macthed with from dbql.
I can see the logonsource from dbqllogtbl. The logonsource is the source from which the query was executed. But, i can see in the dbqllogtbl tht the query was aborted using "abort session"- which means it was aborted using viewpoint. But, i want to know which is the user who has aborted this query. We have a team of DBAs and this query can be aborted by anyone in the team.