Adding NodeNotes to a SWQL query

Node Notes are stored in the Orion.NodeNotes entity (which you seem to have discovered on your own).

Would you only want the most recent note?  Depending on the number of notes, you might return more records than you anticipate.

Huh, I didn't realize that could take multiple notes, see that now, thank you.

I was gonna hit the easy button and add a custom property since they are linked directly to the node and easy to pull. I think I'll go that route now since that'll be a single unique value.

Well, if you wanted the most recent note, this is your query:

SELECT N.DisplayName
     , MAX(N.AssetInventory.WindowsUpdates.LastSuccessInstallTime) AS [Last Update install]
     , N.IPAddress
     , N.Description
     , [NN].TimeStamp AS [Note Date]
     , [NN].Note AS [Most Recent Note]
FROM Orion.Nodes N
LEFT JOIN (
     SELECT [NN].NodeID
          , [NN].Note
          , [NN].TimeStamp
     FROM Orion.NodeNotes AS [NN]
     WHERE [NN].TimeStamp = (
               SELECT MAX([NNRecent].TimeStamp) AS [MostRecentTS]
               FROM Orion.NodeNotes AS [NNRecent]
               WHERE [NN].NodeID = [NNRecent].NodeID
               )
     ORDER BY [NN].NodeID
          , [NN].TimeStamp
     ) AS [NN]
     ON [N].NodeID = [NN].NodeID
WHERE N.IsServer = True
GROUP BY N.DisplayName
     , N.AssetInventory.WindowsUpdates.LastSuccessInstallTime
     , N.IPAddress
     , N.Description
     , [NN].Note
     , [NN].TimeStamp 
ORDER BY N.AssetInventory.WindowsUpdates.LastSuccessInstallTime DESC

That works perfect, thank you very much, there's 110% I would've never got that working.

And there's a 150% chance I had to dig through old stuff to find it.

Glad it will work for you.

For anyone who happens upon this page, I've outlined the query logic in Returning the Most Recent Element from a Related Entity in the SolarWinds Platform API pages.

For anyone who happens upon this page, I've outlined the query logic in Returning the Most Recent Element from a Related Entity in the SolarWinds Platform API pages.