Browse Live Discover and Response Queries by Category
Approved

This query is one you are recommended to read the full content of the post to use. It is not simply a copy and paste query, like others in the forum. It is valuable in the right situation 

Live Discovery - Need help to get current IP address

Hi, need some help on creating a query that will show me the current IP address the machine is connecting from.

Is there any nice easy way of doing this?

I've tried with: interface_addresses.address Network_IP,

But that returns the IP for all existing interfaces, not just the one that the machine is connected from.

Thanks in advance!

Diego Tavolari
Parents

  • Or A simple Query just to list the active Adapter connection

    SELECT ia.interface , address , mask , ia.type , ia.friendly_name  

from interface_addresses ia

JOIN interface_details id ON ia.interface = id.interface

WHERE connection_status = 2 AND mask LIKE '255.%%'

Comment

  • Or A simple Query just to list the active Adapter connection

    SELECT ia.interface , address , mask , ia.type , ia.friendly_name  

from interface_addresses ia

JOIN interface_details id ON ia.interface = id.interface

WHERE connection_status = 2 AND mask LIKE '255.%%'

Children
Unfiltered HTML