adam.beedell · SRE/Machine Learning Student · ✭✭✭✭✭

Hi Kevin, I still think we need an addition to the page, here's my logic: 1) AS isn't listed either 2) the FROM-Based subquery has no description or language from the documentation page - How would someone search for it? Where in a script is it supported? They're both in there and both work, I use em regularly, but not…

Hi Anirban, This is definitely possible, worst-case scenario you could put a block of script in to pull the data from solarwinds eg ## Solarwinds Query Base ##Prep and connect import-module SwisPowerShell $swis = Connect-Swis -Hostname $hostname -UserName $username -Password $password ##pull cisco PIDs in use from SLW…

So first off replace "AddHour(+5,StartTime.EventTime)" with "AddHour(5,StartTime.EventTime)" No plus required in that query After that is looks like it works in my environment, though I dont have the branches custom property

DM'd, Thanks!

[quote userid="81493" url="~/product-forums/the-orion-platform/f/orion-sdk/94130/need-help-to-insert-addhour-5-in-uptime-result"]AddHour(+5,StartTime.EventTime) [/quote]Not sure if it solves the problem on it's own, but this should just be "5" not "+5", probably going to generate an error twice on line 1

Just a username and password really. Solarwinds communicates with itself using an API so its always enabled. http://solarwinds.github.io/OrionSDK/swagger-ui SW dev kit with SWQL Studio helps a lot. Purple icons are API calls. Most of the time you'll just use a query.

Top right gets to fit more in because the names are cut down in size screenshot from my env for two things - Shorter names clearer and popping lables on the chart. The latter's a checkbox under edit, and on mouseover the chart data below is displayed decently well. If you chopped off the text it'd be reasonable, still…

Is the ideal one for you the top right chart? (or bottom left?)

@"Holcomb" @"witrick" What would you want it to look like in this instance? Using the column sizes in the screenshot above you'd either cut a bunch of text off or you'd have text wrapping all the way down the page. If you're happy cutting off some next you can use a customhtml element with iframes. If you're not happy…

Agreed with @"christopher.t.jones123", but also you don't need to JOIN, just use a.customproperties.clientprefix if you're in SWQL. If you're in SQL, you may as well switch to SWQL as it's not doing anything you'd need SQL functions for WHERE a.status in ('2','12') probably also works

I dont have a good fix for you, but I share the frustration. Reasons maybe - New tunnelid - connection attempts that are being denied showing up wrong - records getting stuck in the table I think there's a solution possible in checking reach tunnel's data history and alerting where something that had traffic stops having…

Settings -> Manage Alert Integration Instances -> Add -> Servicenow

 A bunch depends on the specifics of your infrastructure. Can be easy, probably hard. Examples: Latency: - Netpath from something in the network core to some service provider node (allowing information to not be dropped at your firewall (in NPM) - IPSLA from core switch to some service provider node using VNQM - Ping…

In a custom SWQL/SQL alert you cant modify the SELECT -> FROM section, but the box underneath is where you can edit in a WHERE (or a JOIN, or other clever stuff)

I dont think there's really an "Easy" way, but perhaps something like: 3 part report (pseudocode) 1st part - main availability report: Select [whatever details you want] from orion.nodes n where [device scope] and ( n.availabilitydetails.timestamp > adddays(getutcdate(), -30) and n.availabilitydetails.timestamp <…

Tested in my env, same behaviour at under about 600px on mouseover. Honestly i'd just give it a bigger width before trying to recreate these from scratch. Perhaps rotate the pages in a noc view for more screen real-estate. The text isnt going to be readable too low anyway.

For perfstack it's gotta be the unified time axis.

@"jan.rachwalik"@"kbswcon" Workaround i've got in use is you save the large numeric value in one API poller, then use another to query solarwinds through SWQL, then stick the secondary api poller on dashboards. Example:…

Super helpful, thank you! Still very much hoping for a regular text save at some point. I've spoke to @"jan.rachwalik" on the topic prior, still hoping!

Personally having this issue - I'm moving toward polling OME as i'm struggling to find all hardware metrics anywhere else. The OME api aint too bad, I dont have a complete solution yet though.

@marcrobinson this is super interesting, really goes a way to fixing a hole in the use case for API pollers Am i right in thinking that you're describing a way to pull pre-defined text out, where you've defined {string} = {number} within an api monitor? I've not seen a way to pull non-defined text out (say you're querying…

It needs to evaluate to something or it'll come back with the macro text. (chuck in a CASE or UNION) If it's still not evaluating that's a confusing pain

Dummy nodes work well for cloud-stuff. Trying a external or ping-only node with something obvious in the caption "$service} API/SAM Monitoring host" etc

There's a vmware alarm for this, vmware alarms flag vm-layer statuses, so it'll show up there. That said, that solution is bad because other alarms exist. Not clear to me what the "best" solution would be.

In-UI you can do this as an alert action, if so run em daily overnight or something.

If you're using an orion Map you can add the link to a picture or shape under "Behaviour". Personally use that most of the time. Lots of ways of doing this sort of thing depending on specifics

This seems pretty doable, out of curiosity did you get this setup?

Please let us save text!

You want a UNION or weird join. Union for thing name | thing data | etc other thing | other data | etc weird join for thing name | thing data | unrelated thing name | unrelated thing data in SWQL bracketed FROM queries kinda work as a CTE kinda. Talk to your DBA if you have one and be patient while they scratch their head…

SAM templates -> new -> custom powershell -> save -> application discovery :) Notes for extra data is good, but i'd only reccomend that when there's a secondary check that fills in other data. Using Statistic + message + custom SWQL macros gets you almost everything else albeit it's sometimes a faff.