LeBeauUK · I hold all the Aces · ✭✭✭✭✭

Oh I really hope so, I love the one I have got that says "Hold Tight and pretend there's a plan"

Another notification that we send to MS Teams is a warning message when a node reboot. { "summary": "Card \"REBOOT Notification - \"", "themeColor": "f3e034", "title": "ALERT TRIGGER: ${N=SwisEntity;M=Caption} Has Rebooted", "sections": [ { "activityTitle": "Device:…

I think there was a message after you submitted that the points won't be applied until after the 20th of April. 

Been Able to get on (using Chrome) but have the SCP Exam Voucher for 60k Credits been removed? 

Does Cherwell accept Json posts? We are going to be doing that with TOPdesk.. Edited - Yeap from what I can see from doing a search Cherwell supports Webhooks, so you will be able to this action: and provide the inforamtion at a guess it will be Json, so it will be something like this: { "device":…

Most prob launch during ThwackCamp ;) 

Hi What we use is the Universal Device Poller (Which should be on the main server) and use SNMP to retrieve the serial number, then what you can do is export that information and then import it in to a custom property field called Serial Number. Looking on the Huawei forums looks like the OID you need…

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 ,…