All Forums Tools
AmarnathG 16 posts Joined 10/12
02 Nov 2012
How to Find Database name using Proxyid/Service id

Hi Experts,
Could you please let me know the query/process to find database name using Proxy id/Service id.
I t would be highly appreciated.
Thanks,
Amarnath

AmarnathG
AmarnathG 16 posts Joined 10/12
04 Nov 2012

Hi All,
Any replies...Thanks

AmarnathG

ulrich 816 posts Joined 09/09
05 Nov 2012

Silence might be related to the fact of unclear understanding of requirements.
What are you looking for?
"database name using Proxy id/Service id"???????????

feel free to donate bitcoin:12kgAUHFUqvG2sQgaRBXFhCwyf9HXdkGud

AmarnathG 16 posts Joined 10/12
06 Nov 2012

Hi ulrich,
In teradata View pont by having session id/username we can find out long running jobs/scripts.
I have two questions.
1.There is only one proxy id/username  for every database?
2.If i want to find database name using proxy id/username,then what is the process to find out.
Please let me if you need furthe details.Thanks for reply
 
AmarnathG

AmarnathG

AmarnathG 16 posts Joined 10/12
21 Nov 2012

i All,
Any replies...Thanks

AmarnathG

katakoti 21 posts Joined 11/12
28 Nov 2012

Hi Amar,
Please try the below query .......
 

SELECT defaultdatabase,sessionno
FROM Dbc.Sessioninfo where username='USR_NAME' ;

 

AmarnathG 16 posts Joined 10/12
28 Nov 2012

Hi Koti.Thanks for reply.
Above Query Valid for username.
if i use Proxy id, do we have any query to find out name of the database?
 
Thanks
AmarnathG

AmarnathG

katakoti 21 posts Joined 11/12
28 Nov 2012

I think ....Use name is nothing but proxy id....

You must sign in to leave a comment.