• State Suggested Answer
  • Locked Locked
  • Replies 2 replies
  • Answers 1 answer
  • Subscribers 24 subscribers
  • Views 2153 views
  • Users 0 members are here
Options
Related
This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

UDT Device Inventory Report

KwiQ

hello, i'm trying to generate report for UDT Device inventory with mac address of Endpoints. In UDT Device Inventory i can see all i need:

But when i'm trying to generate report for some devices:

I can not see ports of these devices - there is not an option to choose in report creator. Is any chance to add port numbers of devices to this report ?

Parents
  • 0

    When you click on the MAC address, does it show association with an IP Address?  I don't think the report and the Device Inventory gets the data from the same location.  It would be better to just submit a feature request for that page to have an out of the box report or an option to export.

  • 0 in reply to donrobert5

    thanks, i was able to do what i want:

    select [Device].ConnectedTo, [Device].portname, [Device].portnumber, [Device].vlan, [Device].connectiontypename, [Device].macaddress, [Device].ipaddress, [Device].macvendor, [Device].hostname
    from orion.udt.allendpoints as [Device]
    left join orion.udt.port AS [Port]
    ON [Port].PortID = [Device].PortID
    where [Device].ConnectedTo like '%s-dcn%'
    and [port].speed <> 0

Reply
  • 0 in reply to donrobert5

    thanks, i was able to do what i want:

    select [Device].ConnectedTo, [Device].portname, [Device].portnumber, [Device].vlan, [Device].connectiontypename, [Device].macaddress, [Device].ipaddress, [Device].macvendor, [Device].hostname
    from orion.udt.allendpoints as [Device]
    left join orion.udt.port AS [Port]
    ON [Port].PortID = [Device].PortID
    where [Device].ConnectedTo like '%s-dcn%'
    and [port].speed <> 0

Children
No Data

SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 200,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.

SolarWinds Customer Success Center Certification SolarWinds Lab Link Accounts
About THWACK Blogs Federal & Government Edit Settings Free Tools & Trials
Legal Documents Terms of Use Privacy California Privacy Rights Security Information
©2021 SolarWinds Worldwide, LLC. All Rights Reserved.