Problem Pulling End of Sale/Support Information

Hi Everyone,

Has anyone come across this problem? Trying to pull End of xxx data from Solarwinds, when I try to run it either in SWQL Studio or as an API in Postman it doesn't return any results, yet if I add it as a Widget in a modern dashboard it returns the data. Here is the code that I am running:

Select N.caption as [Device Name]
, N.IP_Address as [IP Address]
, N.Vendor
, N.CustomProperties.SerialNumber
, N.CustomProperties.SiteName as [Site Name]
, N.CustomProperties.HigherHealthAuthority as [Higher Health Authority]
, N.NodeProperties.EndOfSales
, N.NodeProperties.EndOfSoftware
, N.NodeProperties.EndOfSupport
, N.NodeProperties.EosComments

from orion.nodes as N
Where n.CustomProperties.HigherHealthAuthority = 'ABC'

Top Replies

KMSigma.SWI 10 months ago in reply to LeBeauUK +2

SWQL Studio and use the "Copy Query As" functionality... But that's because I'm lazy and bad at escaping my own URLs.

Parents

0 Seashore 10 months ago

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

Is it working without the where-part?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 LeBeauUK 10 months ago in reply to Seashore

Nope it still fails,

But if I comment out the NodeProperties.EndofXXX it works:
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 KMSigma.SWI 10 months ago in reply to LeBeauUK

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?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 LeBeauUK 10 months ago in reply to KMSigma.SWI

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):
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 KMSigma.SWI 10 months ago in reply to LeBeauUK

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

Sign in to reply

Verify Answer

Cancel
0 LeBeauUK 10 months ago in reply to KMSigma.SWI

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..
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 LeBeauUK 10 months ago in reply to LeBeauUK

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": []...
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 LeBeauUK 10 months ago in reply to LeBeauUK

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": []...
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

0 KMSigma.SWI 10 months ago in reply to LeBeauUK

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

Are you using the new 17774 port? I can't think of anything else.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 LeBeauUK 10 months ago in reply to KMSigma.SWI

Yep using 17774
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 LeBeauUK 10 months ago in reply to KMSigma.SWI

What tool would you recommend to use when building Select API?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 KMSigma.SWI 10 months ago in reply to LeBeauUK

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

But that's because I'm lazy and bad at escaping my own URLs.
Cancel
Vote Up +2 Vote Down

Sign in to reply

Verify Answer

Cancel
0 LeBeauUK 10 months ago in reply to KMSigma.SWI

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..
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 KMSigma.SWI 10 months ago in reply to LeBeauUK

<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.

I am not part of the SolarWinds Support Organization and anything you do based on my recommendations are 100% your own fault for relying on the recommendations some random person on the Internet.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 LeBeauUK 10 months ago in reply to KMSigma.SWI

Yeah bounced the service SolarWinds Information Service v3, didn't make any difference, still the same issue...
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 LeBeauUK 10 months ago in reply to KMSigma.SWI

Ok twist it is now working when I run the SWQL in SWQL Studio and in a web browser, but then when I either try on a different device or if I ask another user that has the same access as me it fails
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 KMSigma.SWI 10 months ago in reply to LeBeauUK

Sounds like an issue for support at this point.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel