Node Details Widget not working with Scheduled Report. Need a fix or workaround.

sidj2025

Our scheduled reports stopped working after we implemented SSL and a Mandatory Notice to email a PDF of the report. Since then we have seemingly fixed the SSL issue, but one of the reports is still not working. All of the other reports work correctly. I narrowed it down to one item on the report that causes an unexpected error. It is the Node Details widget. I have one for one node. I tried using a different node and the same thing happened. If I take off PDF and add CSV, Excel, HTML it will run however the CSV and Excel reports won't generate. The HTML is there but nothing displays. From looking around online I found something that said that there was a known issue with dynamic widgets and scheduled reports with version 2025.2. My conclusion is that Node Details is a dynamic widget. I am currently using version 2025.2.1. One workaround may be to use a SWQL query to pull the needed information rather than use the widget. However I cannot pull all of the information contained on the widget using SWQL as I don't know the properties. Below is what I have so far and what I need.

What I need is: node status (have), polling IP address- (have), Dynamic IP- (have), Machine Type- (have), Node Category (This may be custom since we have Network or Server as the two choices), DNS- (have), System Name- (have), Description- (have), Last Boot- (have), Software Version, Software Image, Hardware, Number of Cores- (have), Telnet, and Web Browse.

This is what I have for the SWQL: (I still need to organize it.)  Also how to get this as a list going vertical versus horizontal?
SELECT
n.NodeID,
n.Caption AS [Node Name],
n.DynamicIP,
n.Description,
n.StatusDescription as Status,
n.LastBoot,
n.IPAddress,
n.IPAddress AS [Polling IP Address],
n.MachineType,
n.CpuCount AS [Number of Cores],
n.Status,
n.Vendor,
n.Description,
n.DNS,
n.SysName,
e.ServerName AS [Polling Engine]
FROM
Orion.Nodes n
LEFT JOIN
Orion.Engines e ON n.EngineID = e.EngineID
WHERE
n.NodeID = <node ID>

Other ideas are welcome on what I can do to get the report to work with the widget as is. 

Lofstrand

Hi

I Joined in data from the VirtualMachines table to get the host information. 

The Telnet and web browser fields are just links created in GUI, no actual data in db. Added them in below example anyway

SELECT
    n.Caption AS [Node Name],
    n.StatusDescription AS Status,
    n.IPAddress AS [Polling IP Address],
    n.IOSVersion,
    n.DynamicIP,
    n.MachineType,
    n.DNS,
    n.SysName,
    n.NodeDescription,
    n.LastBoot,
    n.IOSImage,
    n.Contact,
    n.Location,
    n.SysObjectID,
    n.CpuCount AS [Number of Cores],
    si.HostName,
    si.DeviceType,
    ISNULL(VM.Host.HostName,'-') AS [VM Hostname],
    ISNULL(VM.Host.IPAddress,'-') AS [VM Host IP],
    CONCAT('telnet://',N.IPAddress) AS Telnet,
    CONCAT('http://',N.IPAddress) AS [Web Browser],

    CONCAT('telnet://',N.IPAddress) AS [_LinkFor_Telnet],
    CONCAT('http://',N.IPAddress) AS [_LinkFor_Web Browser]

FROM Orion.Nodes AS n
LEFT OUTER JOIN Orion.AssetInventory.ServerInformation AS si ON n.NodeID = si.NodeID
LEFT OUTER JOIN Orion.VIM.VirtualMachines AS VM ON N.NodeID=VM.NodeID
WHERE
n.NodeID = 1