The most recent content from our members.
Hi I found this in one of the questions but I would like to be able to run the query with hostnames as well to report on. Sorry I am a newby to SQL queries. USE [SolarWindsOrion] SELECT dbo.udt_FormatMACAddressForUI(E.MACAddress) as MACAddress, ip.IPAddress, P2e.LastSeen as LastSeen, P2E.VlanID, N.caption as Nodename,…
Hi I am trying to get my head around this one bit not working. I need to pull a report that looks at port history to identify for the last 7 days port activity across all our access layer port switches to state any IP/MAC details retrieved in the last 7 days. I am running the SWQL query below to find the devices but last…
Hello, is any chance to get report like this: Node Name / % port used / port available / port used/ but grouped by type of interface ? For example if device has 24 ports 1G + 4 ports 10G I would like to have two rows in report. I have devices with ports 1G, 10G, 100G and simple number of free port is useless. Regards Andrew
Hey All! I had a request to create a widget on port description, and I whipped this up real quick. Enjoy! * On the dashboard, customize the page and add a “Custom Query” widget * Edit the widget, title this “Search Port Description”, and check the box for “Enable Search” * Use the following queries: For the top box: select…
A listing of all ports in UDT and what is connected to each If you wish to isolate to a particular node, add a where clause at the end WHERE UP.Node.Caption='<name_of_the_device>'
Good Day Thwackers! I require some help to create a report please. I need to know how many Cisco Phones I have connected to my network. Now under Device tracker summary I can see the below: If i click on "cisco" on the graph it just gives be a list with two headers:MAC addresses and "Match Type" so this will not give my…
So I've been tasked with providing a report that shows all UDT endpoints and the ones that have been first discovered in the last 24 hours. In this report i need the discovery time, MAC address, IP Address, Vendor, and DNS name. I don't see any table that has all of this information so i made my own query below. However,…
Hi All, I have recently created a SQL Script to list all Nodes with UnUsedPorts in the last 30 days. I currently have an issue where by I would like to try and add either a COUNT or SUM that rather than displaying all the individual ports it just summarizes to show; NodeName > Total Ports Unused > Total Used Again keeping…
Hi guys, I'm trying to build two new reports for UDT, but I'm getting stuck with the more advanced SQL queries that lookup date. I hope one of you can help 1. A Summary View report, much like the Top 10 Nodes by Percent Ports Used resource, that groups the Nodes by <custom_Property> AND only lists historical "Archive"…
It looks like you're new here. Sign in or register to get started.