How to find IP Address of Client 
Author Message
 How to find IP Address of Client
Hi there,

Sorry I just repost using Dejanews to make sure
my news is come out :). Is there anybody out
there that knows how to get the IP address of a
user that connected to a particular database.
DB2 List application doesnt tell the IP address :
(.

Is there any table that we can query on ?

Regards,
Tirta

Sent via Deja.com
http://www.***.com/



Sun, 06 Jul 2003 00:53:40 GMT
 How to find IP Address of Client

Hi,
I could be mistaken, but I thought list applications does show the ip as
part of the application id. Maybe you need it include the SHOW DETAIL
clause to.

If that doesn't work out, try GET SNAPSHOT for all remote_applications.

Hope that helps,
David.

Quote:

> Hi there,

> Sorry I just repost using Dejanews to make sure
> my news is come out :). Is there anybody out
> there that knows how to get the IP address of a
> user that connected to a particular database.
> DB2 List application doesnt tell the IP address :
> (.

> Is there any table that we can query on ?

> Regards,
> Tirta

> Sent via Deja.com
> http://www.deja.com/



Sun, 06 Jul 2003 02:15:32 GMT
 How to find IP Address of Client

says...

Quote:
> Hi there,

> Sorry I just repost using Dejanews to make sure
> my news is come out :). Is there anybody out
> there that knows how to get the IP address of a
> user that connected to a particular database.
> DB2 List application doesnt tell the IP address :
> (.

> Is there any table that we can query on ?

> Regards,
> Tirta

> Sent via Deja.com
> http://www.deja.com/

Hi,
The second part of the application id you see when entering  the "list
applications" command contains the IP address.
A connection from IP address 10.3.40.120 is converted to hex (10 = 0A,
3 = 03, 40 = 28, 120 = 78)  and the dots are removed. It will show up
as *TCPIP.0A032878.(......).
You can find a compleet description about this field in the System
Monitor Guide and Reference.

Hope this helps.



Sun, 06 Jul 2003 02:45:55 GMT
 How to find IP Address of Client

Thanks for all of you that have already replied, It works :).

Regards,
Tirta


Quote:

> says...
>> Hi there,

>> Sorry I just repost using Dejanews to make sure
>> my news is come out :). Is there anybody out
>> there that knows how to get the IP address of a
>> user that connected to a particular database.
>> DB2 List application doesnt tell the IP address :
>> (.

>> Is there any table that we can query on ?

>> Regards,
>> Tirta

>> Sent via Deja.com
>> http://www.deja.com/

> Hi,
> The second part of the application id you see when entering  the "list
> applications" command contains the IP address.
> A connection from IP address 10.3.40.120 is converted to hex (10 = 0A,
> 3 = 03, 40 = 28, 120 = 78)  and the dots are removed. It will show up
> as *TCPIP.0A032878.(......).
> You can find a compleet description about this field in the System
> Monitor Guide and Reference.
> Hope this helps.

--
Tirta Wijaya


Sun, 06 Jul 2003 10:15:57 GMT
 How to find IP Address of Client
Refer to the Zero Impact Sql Monitor product line at www.sqlpower.com for
SQL performance, end-user service level, Top N SQL, and data usage analysis.
The product captures in real-time the end-user response time, database
server response time, network time, client IP address and much more.  SQL by
client IP address can be filtered in real-time or offline.

Randy Reiter


Quote:
> Hi there,

> Sorry I just repost using Dejanews to make sure
> my news is come out :). Is there anybody out
> there that knows how to get the IP address of a
> user that connected to a particular database.
> DB2 List application doesnt tell the IP address :
> (.

> Is there any table that we can query on ?

> Regards,
> Tirta

> Sent via Deja.com
> http://www.deja.com/



Wed, 09 Jul 2003 06:52:43 GMT
 
 [ 5 post ] 

 Relevant Pages 

1. Finding the IP address of a web client

2. Finding IP address of client

3. How to find IP address of the SQL server

4. How to find an IP Address of the data user

5. IP Address Cannot Be Found!

6. Finding out the last 10 times a certain terminal IP address was l

7. Get client's IP Address or Server Name

8. Client with multiple IP address

9. How do I capture a SQL client's ip address

10. IP address of client machines

11. Connecting to SQL Server w/o client IP address

12. Client IP Addresses


 
Powered by phpBB® Forum Software