Problem Pulling End of Sale/Support Information

Just tried your query in SWQL studio, without your custom properties of course. I ran just fine. 

Is it working without the where-part?

Nope it still fails, 


But if I comment out the NodeProperties.EndofXXX it works:

Odd - almost like the NodeProperties (NVM.NodeProperties) Navigation Property is broken/connected to the wrong place.  Or there is no data (since this acts like an INNER JOIN).

If you select TOP X from NCM.NodeProperties, does that return data?

Odd - almost like the NodeProperties (NVM.NodeProperties) Navigation Property is broken/connected to the wrong place.  Or there is no data (since this acts like an INNER JOIN).

If you select TOP X from NCM.NodeProperties, does that return data?

I get nothing back when I run it SWQL Studio:


But run the same SWQL in creating a Widget Table on a Modern dashboard it works (doing a show records):

This says "permissions" to me - are you using the same user in SWQL Studio and on the platform?

Yep using the same Account on both SWQL Studio as I am on the Platform.  I have just done a check using a local account (rather than an AD account) and same things happen.. 

Ok this is getting wacky... Just did a File - New Connection to connect back with my account in to SWQL Studio and the data is now showing, but is still failing in PostMan, just shows "result": []... 

Yeah - I'm out when you brought in PostMan. 

Are you using the new 17774 port?  I can't think of anything else.

Yep using 17774

What tool would you recommend to use when building Select API? 

SWQL Studio and use the "Copy Query As" functionality...

But that's because I'm lazy and bad at escaping my own URLs.

Thanks, that is really handy to have, but alas hasn't fix the problem as it is failing to display, maybe if I refresh it 3 times it might appear.. 

<sarcasm>Remind me of the definition of insanity again?</sarcasm>

You've got an odd problem there LeBeauUK , I won't deny it.  Have you tried turning it off and back on again?

All joking aside, in the middle of the night (or day if it suits you), you may want to restart the "SolarWinds Information Service" on the server you are hitting.