LeBeauUK · Changing - New Item here soon... · ✭✭✭✭✭

Running config wizard didn't fix it. 

LOL... So just so that I have got it clear the 3rd party have to: 1 - click on "+ Create Your Own application" 2 - Call it something meaning full, like SolarwindsOrion_SAML 3 - Do the thing with the certificate... Job done?? Hopefully they will be ok with this and not request for documentation for this... 

Doing a search on that all I can see is 

Might pay to post your question here (+) Patch Manager - THWACK (solarwinds.com)

Picked up from SQL on StatusInfo: so 1 - 1 is Up Up 2 - 2 is Down Down 3 - 4 Warning Sutdown…

I also got that message when there are spaces in the filename as well... 

That would imply you are using SQL rather than SWQL. Becareful using SQL as SolarWinds could (and do) make changes to Tables within the database.. 

Hi @"ifhd7" Very Strange, as I have put that SWQL into test pad I have got and it is working as it should do. When you put the SWQL into the table and click on Show Records is it showing all of the columns that you expect to see? Have you puit the code in to a Classic Dashboard on a Custom Query to see if it works on…

Ok I have just moved the custom field to after the Duration so: SELECT TOUPPER(SUBSTRING (n.Caption,1, CASE WHEN CHARINDEX('.',n.Caption,1) <=4 THEN LENGTH(n.Caption) ELSE (CHARINDEX('.',n.Caption,1)-1) END)) AS [IP] ,case when min(rt.DateTime) is NULL then 'More than a year' else…

Are all 3 connection patched in to a core switch? If so, monitor the Interface and add this widget on to the device page - Current Percent Utilization of Each Interface it will show the utilisation on the interfaces. 

Hi @"ifhd7" you can simply add n.CustomProperties.SiteName as [Site Name] at the start of the select, but make sure that you add it to the Group By as well... SELECT n.CustomProperties.SiteName as [Site Name], TOUPPER(SUBSTRING (n.Caption,1, CASE WHEN CHARINDEX('.',n.Caption,1)

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

Yeah bounced the service SolarWinds Information Service v3, didn't make any difference, still the same issue... 

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

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

Yep using 17774

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": []... 

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

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):

Nope it still fails, But if I comment out the NodeProperties.EndofXXX it works:

I see that you have got a Custom Property in the select area [quote userid="295797" url="~/products/the-orion-platform/f/report-lab/101177/how-can-i-add-customproperty-in-this-query"]AlertObjects.Node.CustomProperties.Locations as Location[/quote]So to add the device_type custom property, simply add:…

That is now working, must of been having finger trouble yesterday :) 

Thanks for the pointer managed to get a list of device that are on that site, although I needed to use Like rather than = in the query: select n.caption as [Device] -- shows the current status icon , '/Orion/images/StatusIcons/Small-' + n.StatusIcon AS [_IconFor_Device] -- makes a clickable link to the node details ,…

 Hi @"KMSigma.SWI" , Is there any widget that will support the passing of a ${CUSTOM PROPERTY} parameter which will allow me to create a list of devices that are on the same site as the node they are looking at? As one of the request from my users is to allow faster navigation to devices. 

 * LeBeauUK keeping fingures cross you are coming back to the UK

I think you will find the problem could well be with the importing cost/red tape in to India. As I am sure Thwack would like to send their items to you... 

Haven't hear or found anything so far.. 

I think you will find it in the Orion.ResponseTime within SWQL, not sure in SQL. 

Ok just wanted to make sure nothing was broken :). I can access the screen I need by clicking on the sub menu and then click on Content Exchange on there: As it is useful to see what areas have had updates at a quick view like this:

Hi, On the Trigger Condition, there is a tick box totowards the bottom where you can set a time condition: