Hi,
we have a schedule report one of my previous colleagues have created and its stopped working after a recent upgrade. we raised it with Solarwinds support but they are saying its a questions for thwack. We are getting the below error, can one of you please help?
Error setting up report cell during rendering 'Custom Table.'
Error executing SQL: Operand type clash: uniqueidentifier is incompatible with int
Query:
SELECT DISTINCT
con.Name AS [Site Location],
n.Caption AS [Node Hostname],
n.IP_Address AS [IP Address],
n.Vendor AS [Manufacturer],
n.MachineType AS [Machine Type],
ISNULL(ISNULL(ncc.chassisID, ISNULL(cpav.CurrentValue, f5sd.SerialNumber)), asasv.SerialNumber) AS [Node Serial No.],
ncm.ReplacementPartNumber AS [Part No.],
si.ShortDescription AS [Node Status],
n.LastSync AS [Last Polled],
IIF(ISNULL([SystemUpTime],0) = 0,'Unknown',CAST(FLOOR(n.SystemUpTime / 86400)
AS VARCHAR(10))+' Days ' +CONVERT(VARCHAR, DATEADD(second,n.SystemUpTime,0),108))
AS [Node Up Time],
n.ObjectSubType AS [Polling Method],
CASE WHEN ncm.Nodeid IS NULL THEN 'NO' ELSE 'YES' END AS 'NCM Backup'
FROM Nodes n
LEFT JOIN NCM_NodeProperties AS ncm ON n.NodeID = ncm.CoreNodeID
LEFT JOIN NCM_Cisco_Chassis AS ncc ON ncm.NodeID = ncc.NodeID
LEFT JOIN StatusInfo AS si ON n.status = si.StatusId
LEFT JOIN NodesData AS nd ON ncm.CoreNodeID = nd.NodeID
LEFT JOIN F5_System_Device AS f5sd ON n.NodeID = f5sd.NodeID
LEFT JOIN ContainerMemberSnapshots AS cms ON n.NodeID = cms.EntityID
LEFT JOIN Containers AS con ON cms.ContainerID = con.ContainerID
LEFT JOIN ASA_Node_V AS asanv ON n.NodeID = asanv.NodeID
LEFT JOIN ASA_System_V AS asasv ON asanv.SystemID = asasv.SystemID
LEFT JOIN (SELECT NodeID, CurrentValue FROM CustomPollerAssignmentView WHERE CustomPollerID = '64982b68-ab28-4324-a679-0b1f9e716647') cpav ON n.NodeID = cpav.NodeID
ORDER BY
con.Name, n.Caption ASC
