tdanner ✭✭✭✭✭

No, SWQL does not support the ROW_NUMBER() feature from SQL. Off hand I can't think of a reasonable way to match these results using only SWQL features. If the number of nodes to fetch logs for is not large, you could get by with running a separate "TOP 500" query for each one.

This is not supported yet. You can see the IPAM operations available through the API here: IPAM 4.6 API · solarwinds/OrionSDK Wiki · GitHub

Por "pollers", quiere decir "polling engines" o algo más?

SWIS is an integral part of the Orion platform, so it is installed on the Orion server as part of NPM, APM, etc.

You should be able to just pass null for the parameters parameter. I don't know why Microsoft's WSDL parser thinks that should be a DataSet - there's no DataSet you could build that would make sense on the other end. In the current development branch, we have changed the WSDL to avoid this problem. Microsoft's…

Try this: How to Reset Your Forgotten Windows Password the Easy Way

That script was designed for moving nodes between Orion systems running the same version of the platform. The trouble with moving between different versions (especially a gap as wide as 10.1 and 11.5.1) is that the names of the pollers in the Pollers table have changed.

When you hover over a node link, the page makes an ajax request to /Orion/NetPerfMon/NodePopup.aspx?NetObject=N:123 (where 123 is the actual NodeID, of course). For some reason, this page is failing to load. The best way to diagnose this would be to know the actual error that is occurring on the server. You could get this…

Rather than write custom asp.net code, I recommend you build your customization using javascript in a Custom HTML resource. You can add this resource to the page like any other resource, then click its Edit button and add your own HTML and javascript. Here's a simple example: <div id="austinTemp"> </div> <script…

AlertObjects entries are not cleared when the alert is reset. You can still go from AlertHistory to AlertObjects to AlertConfigurations for alerts that no longer appear in AlertActive. I'll clarify this on the wiki page. For example, if you have only one alert "Node is down" and only server "Crashy" that previously went…

Can you look in C:\ProgramData\SolarWinds\InformationService\v3.0\Orion.InformationService.log for the exception stack trace? That will help us figure this out.

What do you mean by "prod.state"? If you know what SQL query you would use, I can help you find an equivalent.

I think you are running into trouble with nested quotes. Your query is wrapped in single quotes to make a PowerShell string. Then inside that, the IP address is also wrapped in single quotes to make a SWQL string. But that confuses PowerShell, since it sees the single quote character before the IP address as the end single…

Getting the HardwareHealthItemKey in the right format is undocumented and tricky. This will do it: $swis = connect-swis # connection details here# you need these three properties from the sensors to disable$sensor = Get-SwisData $swis "SELECT TOP 1 HardwareCategoryStatusID, HardwareInfoID, UniqueName FROM…

In NPM 12 you can use ${N=Alerting;M=AlertObjectID} for this purpose. Prior versions don't have any appropriate variable.

Is the M: drive a local disk or a network share? It looks like your script is adding the V.* pollers to the node. Those have to be added to the Volume.

Users editing the contents of source code in the website is not something we support, but if you let us know what behavior you are trying to get, we might be able to suggest a supported way to get there.

No, this is not currently possible.

What happens if you run the same query in SWQL Studio? There's no limitation specific to the API, and there's no license restriction around that sort of query. One possibility is account limitations - are there any account limitations applied to the credentials you are using for the QueryXml call?

I agree. I opened NPM-10374 to track this.

The Metadata.VerbArgument.XmlTemplate property is only available in SWISv3. I'm guessing your perl script is connecting to the SWISv2 service. Look at the HTTPS URL it is connecting to. It should be https://servername:17778/SolarWinds/InformationService/v3/OrionBasic. Is it missing the "/v3" part?

I investigated this. It seems to be a bug with the REST endpoint that translates null values in JSON to empty string for these kinds of requests. I opened internal issue PLA-190 to track it. Unfortunately I did not find any workaround other than just using PowerShell to perform this operation.

We don't have an API for importing a discovered node other than the method you have already discovered (use the DiscoveredNodes data to fill out the arguments for adding a node). We are looking at improving this in the future, so I'll make sure the team hears about this use case. With interfaces, there is not a direct way…

Unfortunately UDT's API is limited to read operations at this time.

You can disable pollers through the API. Get the Uris for the pollers to disable, then call bulkupdate to turn them off. nodeid = 588 # Get the NodeID from somewhere pollerdata = swis.query("SELECT Uri FROM Orion.Pollers WHERE NetObjectID=@nodeid AND (PollerType LIKE '%Topology%' OR PollerType LIKE '%EnergyWise%')",…

Yes, you can configure SWIS to speak HTTP in addition to (or instead of, if you prefer) HTTPS. To do this, you will need to edit C:\Program Files (x86)\SolarWinds\Orion\Information Service\2.0\SolarWinds.InformationService.Service.exe.config and make two changes. (I'll assume you are familiar with XPath. If not just let me…

Orion has native integration with ServiceNow, released almost two years ago: SolarWinds Orion 2016.1 feature: ServiceNow integration - SolarWinds Worldwide, LLC. Help and Support

Very strange. Try adding the node by IP Address instead of hostname.

Here's a query that returns nodes with their last-polled CPU load and also the lowest CPU poll value they had in the last 30 minutes: SELECT N.Caption, N.CPULoad, MIN(N.CPULoadHistory.MinLoad) AS MinLoad FROM Orion.Nodes N WHERE N.CPULoadHistory.DateTime > ADDMINUTE(-30, GETUTCDATE()) GROUP BY N.Caption, N.CPULoad ORDER BY…

According to https://github.com/solarwinds/OrionSDK/wiki/IPAM-4.5.x-API , that should work in IPAM 4.5 but obviously it is not. For the specific case of updating status, there's also a verb you can use. Try that and see if it will meet your needs:…