How to get all Endpoint information about current connection information via SWQL?

Hi everyone,

I hope to have a good days.

I have a mission about getting information for UDT report via SWQL.

I can check individual information through the current connection widget on the IP or MAC detail page on the web console.

However, there was no place to check all current connections anywhere. The device inventory page was different from the current connection information on the detail page.

I need to create data that can report the entire connection information through a report.

The information I want is:

Endpoint_IP, Endpoint_MAC, Connected_To_Switch_Name, Connected_To_Switch_IP, Connect_To_Port_Name, Connect_To_Port_ID, Connection_Type

[ IP Information - Detail page, current network connection example - only reference snapshot and not a goal ]

If you know of a method or query to retrieve the entire current connection information using SWQL, I would like to receive help.

Thank you.

  • I dont have UDT so cant solve it direct for you or anything, but

    If you use F12 or Hubble (search solarwinds enable hubble) you can see the query

    "current connection information" is definately not the term for what you're after, this info will live on a table, and each column will be a column on that table, so you're looking for something in the format of

    SELECT (node port....)
    From Whateverthistableis (which could be searched for in SWQLStudio)
    Where (some filter, presumably where a layer up from where you are now .ipaddress like '10.196.3.37')

  • Thank you adam,

    I already check the Hubble info. 

    But, that widget's query using internal procedure and need fixed value (ip address ...). And, that couldn't modify or any other action.

    I want to get all current connection information on UDT via SWQL.

    The information I want is:

    Endpoint_IP, Endpoint_MAC, Connected_To_Switch_Name, Connected_To_Switch_IP, Connect_To_Port_Name, Connect_To_Port_ID, Connection_Type

    The screenshot I attached is to explain what information I want.

    Thank you.

  • Probably about the same query but without the WHERE statement then