dan_jagnow · Senior Architect

Marc, I was able to run your script without errors after changing the username/password, engine ID, IP address, and credential ID for my environment. I suspect that this is an environmental problem, not a problem with your Powershell script. Try checking the log files in the following locations for clues about what is…

I believe these are the values you're looking for: Unknown.HH0 CIM.VMware1 SNMP.Dell2 SNMP.HP3 SNMP.IBM4 VMwareAPI.vCenter5 WmiDell6 Wmi.HP7 Wmi.IBM8 SNMP.NPM.Cisco9 SNMP.NPM.Juniper10 SNMP.NPM.HP11 SNMP.NPM.F512 SNMP.NPM.Dell.PowerEdge13 SNMP.NPM.Dell.PowerConnect14 SNMP.SAM.Dell.BladeChassis15 SNMP.SAM.HP.BladeChassis16…

Maybe Orion.AssetInventory.LogicalDrive? Not sure offhand. If you open SWQL Studio and type "volume" in the search box of the Object explorer pane, you'll see some likely candidates for where to look.

Here is some reference code for adding a node to a polling engine: https://github.com/solarwinds/orionsdk-python/blob/master/samples/add_node.py To specify which polling engine you want assign the node to, you would set the EngineID value here: # set up property bag for the new node props = { 'IPAddress': ip_address,…

There are some general details about using the SolarWinds Orion API to manage credentials here: https://github.com/solarwinds/OrionSDK/wiki/Credential-Management As you have noted, things get trickier for managing credentials that are stored in WPM scripts. To the best of my knowledge, there is not currently an API that…

Here is a possible starting point: SELECT nc.NodeID, nc.AvgLoad, nc.ObservationCount FROM ( -- Get counts grouped just by node. SELECT NodeID, COUNT(*) AS ObservationCount FROM Orion.CPULoad WHERE ObservationTimestamp > ADDDAY(-2, GETUTCDATE()) GROUP BY NodeID ) AS n INNER JOIN ( -- Get counts grouped by the combination of…

The first problem is a little bit tricky. If you want to allow your users to do something that their current Orion permissions wouldn't allow them to do, you have a couple of options. The simplest thing would be to give the users additional permissions. Do note that IPAM permissions can be set without granting global…

I'm not aware of any reason why you would be unable to set up a second free poller in the secondary data center.

It's a casing problem. Update those names to _IconFor_DEVICE and _LinkFor_DEVICE (to match the casing of your first column name), and you'll start seeing what you're looking for.

Are you looking for something like this? SELECT n.Caption, i.InterfaceName, i.InterfaceLastChange, DAYDIFF(i.InterfaceLastChange, GETDATE()) AS DaysSinceLastChange FROM Orion.Nodes n INNER JOIN Orion.NPM.Interfaces i ON i.NodeID = n.NodeID WHERE i.InterfaceID IN ( SELECT TOP 5 ii.InterfaceID FROM Orion.NPM.Interfaces ii…

I'm afraid you need the URI. Alert suppression is designed to work with multiple entity types, not just nodes, so an ID alone is not sufficient. There are details here: Alerts · solarwinds/OrionSDK Wiki · GitHub​ Fortunately, you can easily retrieve the URI for a node if you know the node ID.

I believe this thread contains the answer that you're looking for: "An error occurred when verifying security for the message" error in SWQL studio...

See the following issues. I suspect that you are missing 'v3' from your endpoint URL, which means you are connecting to the legacy SWIS v2 endpoint instead of the current SWIS v3 endpoint. Set Poll Interval on Node Node Creation Error In other words, your URL should look something like this:…

That should work. Make sure you have Basic Auth enabled with valid Orion credentials, and make sure that your settings have SSL certificate verification turned off (for the self-signed Orion certificate).

Take a look at the following documentation, under the CRUD operations for IPAM.Subnet heading. You should be able to set the ScanInterval property on IPAM.Subnet. I'm not sure whether it is possible to change the polling engine via the API. IPAM 4.7 API · solarwinds/OrionSDK Wiki · GitHub

If I understand correctly what you're trying to do, you may be interested in using Audit Trails: Success Center I'm not aware of an easy way to audit which queries are running for a particular user.

There is schema documentation for Orion.Nodes here: http://solarwinds.github.io/OrionSDK/2019.2/schema/Orion.Nodes.html You could try something like this for the CPU and physical memory. I'm not sure about virtual memory. SELECT n.NodeID, n.DisplayName, n.IPAddress, n.MachineType, n.Interfaces.DisplayName AS…

See How to change supernet CIDR in Orion IPAM through SWIS . It is supposed to be possible via the API, but there is an open bug that is being fixed.

Here is C# code that will do what you're looking for: using System; using System.Collections.Generic; using System.Diagnostics; using System.Linq; using Newtonsoft.Json.Linq; namespace CSRestClient { internal class Program { private const string Hostname = "myserver.mydomain.local"; private const string Username = "admin";…

There is some documentation about ConfigSearch and ConfigArchive that you'll want to read: https://github.com/solarwinds/OrionSDK/wiki/NCM-Config-Search There is also some useful sample code (in Python) from clarv02​ in this thread that should get you started: NCM - DOWNLOAD THE LATEST CONFIG INFO FOR ALL DEVICES

There is information about working with Orion alerts here, including how to acknowledge them: https://github.com/solarwinds/OrionSDK/wiki/Alerts You might also be interested in this thread: How to Acknowledge Alerts via REST API

Could you provide a query that you hoped would work, but which is timing out? I'd be interested to run it in my environment to see if I encounter the same timeout.

Your query does not include the DateTime column from Orion.ResponseTime. Since you are ordering by Availability ASC, it's going to pick the worst individual measurements it can find for the entire history captured in this table. Since stated your criteria include looking at the last 7 days, you will at least need to add…

I think this SWQL query is close to what you need, except that it doesn't include the Technical Service custom property from your environment: SELECT n.DisplayName, eps.SoftwareRevision, n.IPAddress, n.MachineType, epf.FirmwareRevision, eps.Description FROM Orion.Nodes n INNER JOIN Cirrus.Nodes cn ON cn.CoreNodeID =…

According to this thread, it appears you may need to use ​CustomProperties​ instead of ​Custom in the URL: Error Updating Properties and Custom Properties of Nodes

This question is probably a better fit for the Server & Application Monitor (SAM) forum: Server & Application Monitor You might want to take a look at how Linux Agent deployment works here: Monitor with the Orion Agent for Linux Re: Linux Agent Deployment Including the exact error message and possibly a screenshot…

I don't believe that SWQL currently supports a single wildcard character. See Orion Platform SWQL, Thwack! Now I got it.

Try adding some columns to your query (especially each primary key column) so you can identify where unexpected values are coming from. You might also want to add an explicit ELSE to your CASE WHEN to control what comes back when that condition is not true. SELECT DISTINCT n.NodeID, n.Caption AS [UPS], cpa.ID AS [CPAID],…

sirpaw​, the XML elements are case-sensitive. Instead of using "<IPAddress>", you'll need to use "<IpAddress>". You'll need to adjust the casing in the open and close tags.

There is a sample C# project as part of the OrionSDK GitHub repository. You might want to try using that code as a starting point for your own solution: OrionSDK/Samples/CSharp at master · solarwinds/OrionSDK · GitHub