How to Find Database name using Proxyid/Service id

Tools
Enthusiast

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

7 REPLIES
Enthusiast

Re: How to Find Database name using Proxyid/Service id

Hi All,

Any replies...Thanks

Senior Supporter

Re: How to Find Database name using Proxyid/Service id

Silence might be related to the fact of unclear understanding of requirements.

What are you looking for?

"database name using Proxy id/Service id"???????????

Enthusiast

Re: How to Find Database name using Proxyid/Service id

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

Enthusiast

Re: How to Find Database name using Proxyid/Service id

i All,

Any replies...Thanks

Enthusiast

Re: How to Find Database name using Proxyid/Service id

Hi Amar,

Please try the below query .......

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

Re: How to Find Database name using Proxyid/Service id

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

Enthusiast

Re: How to Find Database name using Proxyid/Service id

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