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.

Parents
  • 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')

Reply
  • 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')

Children