No problem. I just created and tested the following SWQL query. Create a new report, choose "custom table", and for the datasource, choose "Advanced SWQL/SQL Query" from the drop down. Select the SWQL radio button, and copy and paste the following query.
m.NodeAccessPoint AS [NodeName]
, m.PortName AS [PortName]
, m.PortDescription AS [PortDescription]
, m.MacAddress AS [MACAddress]
FROM ORION.UDT.MACCurrentInformation m
GROUP BY m.NodeAccessPoint, m.PortName, m.PortDescription, m.MacAddress
Maybe I am not even in the correct place. I am using the Orion Report Writer on one of my servers. Is that where you are creating the report? I am asking because I do not see a "custom table" option anywhere after I click "New report."
You may be on an older version of UDT. The SolarWinds reports were integrated with the web console awhile back. I was referring to creating a new report in the web, and not the legacy Report Writer program. Upgrade to the latest version of UDT(and other modules you may own) at your earliest convenience. If you don't have the time, we @ Loop1 would be happy to help.
What version of UDT are you currently on? Go to Customize Page on your UDT summary page, and see if there is a web resource called "Custom Query". If so, you can paste this query into it by clicking on Edit on that Custom Query resource after you've added it to the page.