mrxinu

Oh, I CallAPI, I gotcha. I thought I'd learned a new word. Once you get the JSON result back (in $result) you need to decode it again so you can use it otherwise you get that {"results... thing. Try this: <?phpinclude 'includes/functions.php';$data = array('query' => "SELECT sysname, statusled FROM Orion.Nodes WHERE…

I think you're still seeing an availability - it's the round number that's throwing you. Check out this thread: http://thwack.solarwinds.com/message/176458#176458

Have you ever been able to successfully query SolarWinds?

What about posting this to your own public GitHub repo with a link so we can submit issues/PRs?

If the blackout windows are known ahead of time maybe it would make more sense to create a pair of integer custom properties called BlackoutStartHour and BlackoutEndHour. Then when you're calculating your availability you can exclude any hours inside that range. The caveat being that you would have to increase your hourly…

Using AD users with the API has been an issue since the beginning. Save yourself some heartache and use a local Orion user.

Hey there, you would use the same tactic I describe here: https://thwack.solarwinds.com/t5/Orion-SDK-Discussions/Question-on-widget-set-up-for-a-modern-dashboard/m-p/608389/highlight/true#M10811

Hey there - I hope you've had a restful weekend and you're reading this on Monday! First, there are some more convenient entities in SWQL to get this information so you don't have to crawl through the assignment table. The one that's probably the most interesting is Orion.NPM.CustomPollerStatusOnNode. It assumes that…

You would get two alerts as SolarWinds would poll the node and see it down but would also poll the interface and see it down. If the node is down, how is SolarWinds polling it to find out the interface is down? Again we're assuming that the interface that's going down is also the one causing the down condition for the…

Are you sure you want the DISTINCT? I just removed it and it looks pretty distinct on its own.

It's true that the tables are date-stamped but they're consolidated nightly in a view so you can always access them. If you're talking about interface traffic the view is called InterfaceTraffic.

I don't have anything to contribute about it misbehaving but, a wild idea, bounce the services and see if that achieves the same effect?

I feel like something strange is happening between the time you provide the query to run and when it gets converted to JSON to pass along to the API. Can you adjust your query to be on a single line and see if you get the same error?

Do a Get-SwisObject, adjust the portions you want to change, and provide that to the verb to update it.

Are you using the PowerShell SDK or the REST API with another language? When you say maintenance do you mean unmanaging or suppressing alerts (mute)?

If you create another, unrelated, dependency in the GUI does it the one you created with the API show up in the GUI? I'm trying to determine if it's the same behavior @"shuth" was seeing in another environment.

Good stuff, but if you wanted insta-points from getting upvoted (and so folx can find it), there's a content exchange for these gems. https://thwack.solarwinds.com/t5/NPM-Documents/tkb-p/npm-documents

You update the NCM node's ConnectionProfileID but as I write that I don't know where that list of connection profiles comes from. I'm asking Ana who wrote this example for SolarWinds' repository. In the meantime, here it is: https://github.com/solarwinds/OrionSDK/blob/master/Samples/Go/NCMProfile/main.go

Hey there! Where are you trying to use the variable? If you're using SWQL somewhere, it's located in the Orion.AlertConfigurationsCustomProperties entity/table. If you were creating a list of the alerts and their ResponsibleTeam, it would look like this: SELECT Configs.Name , CustomProperties.ResponsibleTeam FROM…

I thought I'd throw a message in here so you could mark it as correct. The solution we came up with was to count up the Up, Warning, and Unmanaged nodes in one query and then the Down in another query and then UNION them. If the query we put together works maybe you can post it as a reply to this so folx can enjoy it if…

You said SolarWinds to ServiceNow but your subject says SolarWinds to Nagios. Which were you shooting for?

Assuming you want the most recent running config, this should do it: SELECT n.IPAddress ,cn.NodeID ,n.Caption ,ca.Config FROM Cirrus.Nodes cn JOIN Orion.Nodes n ON cn.CoreNodeID = n.NodeID JOIN Cirrus.ConfigArchive ca ON cn.NodeID = ca.NodeID JOIN ( SELECT ca.NodeID, MAX(ca.DownloadTime) AS MostRecentDownload FROM…

I took a swing a modeling it after the groups code out on the SolarWinds GitHub repository because it had an XML component, but couldn't quite get there. Maybe someone with more background might be able to get over the hump. Import-Module SwisPowerShell $swis = Connect-Swis -Hostname <redacted> -Trusted $query = " SELECT…

SAM templates have to be applied to nodes to become application monitors. That's what that URI is telling us. Under what situation would you have an application that doesn't have a node associated with it?

When you schedule a report to be sent out it already allows you to send it in PDF format by default.

What would the command be and what would you expect the report to look like?

Some clarifying questions about your requirements: * Do you want to include unmanage spans that haven't happened yet or are you only considering nodes that are currently in an unmanaged state? For example, if a node will be unmanaged for 12 hours but it won't happen until next week, is that added to the total minutes? * Do…

You can use an account limitation to lock a user into a subset of your devices. That prevents them from accessing any of the other devices. The full-access to device group A and read-only access to device group B concept isn't supported. You would have to create four separate accounts - full-access to group A, full-access…

I see that the first two changed, but not the third. Did you mean for ZZZ0 to be ZZZ01 in the first example?

Can you post the script you're using?