yaquaholic · Senior Monitoring Simian · ✭✭✭✭✭

From SQL you'll need to concatenate the various IDs to the following URIs: Node URI /Orion/NetPerfMon/NodeDetails.aspx?NetObject=N:<NodeID> SQL: SELECT Caption, IPAddress, CONCAT('/Orion/NetPerfMon/NodeDetails.aspx?NetObject=N:', NodeID) AS URI From Nodes Interface URI /Orion/View.aspx?NetObject=I:<InterfaceID> SQL: SELECT…

It is because the ampersand is reserved for query parameters. #SWQL Query $query = "SELECT TOP 1 Caption, @"email" AS Email FROM Orion.Nodes " $params = @{email='yaquaholic@thwack.com'} #PSSnapin presence check/add if (!(Get-PSSnapin -Name "SwisSnapin" -ErrorAction SilentlyContinue)) { Add-PSSnapin SwisSnapin -ErrorAction…

Hi Sc00ter, It appears that it is just that your python script isn't indented properly: Line 28: IndentationError: unexpected indent

Hi bunjiega101 SWQL works very much like SQL and you need to add an ORDER BY statement to the query before it will do what you want. Using the DESC for descending order, you get the big numbers first. In the example below I've used the overall PercentUtil column to order the results by, you could use OutPercentUtil or…

Hi Leathem123, Have a look at the https://github.com/solarwinds/OrionSDK/wiki/IPAM-API and the https://github.com/solarwinds/orionsdk-python pages. There should be enough details in there to get you going. Shout if you get stuck Yaquaholic

Hi Pseudonetworker, I don't have an alert version of this in our environment, but I've done some SWQL reporting on such things. Here's what I came up with: SELECT n.Caption AS Device, n.IPAddress AS Device_IP, rn.NeighborIP AS Neighbour_IP, rn.Ip_Address_Type, rn.ProtocolStatusDescription, rn.IsDeleted, rn.LastChange,…

Hi there, What's the OID? And does it work if you snmpwalk <OID>.10 ? yaquaholic

Hi Dangreenhaus, I got it working within my environment fine, I had to rewrite the ForEach statements a little and corrected the Remanage to just use the NodeID, but otherwise it's good to go. ####Start ################# #Unmamane/remanage devices #dangreenhasu 2020 11 24 #Silently Call SolarWinds SDK Import-Module…

Hi arnabmk, Try something like the following SWQL: SELECT v.Uri, v.DisplayName FROM Orion.VIM.VirtualMachines AS v WHERE DayDiff(v.OldestSnapshotDate,getdate())>2 AND v.Node.Unmanaged = 0 I hope it helps, yaquaholic 

Hi Troye23, Create a new alert that runs every 12 or 24 hours with a SWQL trigger such as: The above SWQL triggers when any snapshot over 10 days old is discovered. I hope it helps! Regards, Yaquaholic 

Peter, Have you had a look at the Orion SDK? If you have a look under the Samples folder, you will find examples of how to update a node to SNMP v3 credentials. This example script could easily be updated to perform bulk updates. Regards, yaquaholic

Hi Jinqaing, Have a look at the examples scripts provided on the Orion SDK GitHub repository, as they just what you are looking for. Here is the Powershell version, but other language examples are also provided: https://github.com/solarwinds/OrionSDK/blob/master/Samples/PowerShell/ChangeSNMPVersion.ps1 You first "get" the…

The Set-SwisObject can be used like so: # Variables$SwisHost = "<your Orion server>"$user = "<user name>"$nodeid = <NodeId>$newname = "<new name>"#Get password and create credentials$passwd = Get-Content 'C:\Scripts\OrionAdmin.txt' | ConvertTo-SecureString -AsPlainText -Force$SwisCreds = New-Object -typename…

Here's three lines to get you started: $users = (gcim Win32_LoggedONUser).Antecedent.Name Write-Host "Statistic.users: $($users.count)" Write-Host "Message.users: Logged on users are: $users"

I think I need to be working on version 2 of this script

Script is avaialbe for download here - OrionSDK_find_and_delete_down_volumes_then_open_node_List_Resources_url.ps1

And once you have the Enterprise OID, www.mibdepot.com is a great place to find the relevant MIBs. There are other sites, but I find that one the easiest to get on with and if you have MIBs that aren't mentioned they are very good at adding them (if you upload them).

This question, should have been a poll....

WMI can be controlled at a per host level, did you configure the polled server to allow WMI polls from the new poller, before you switched them over? Check out this document, to give you a better inights and hopefully fix your issues:…

Definitely configure it to be polled by SNMP

Have you tried this? Go to Setup --> General --> Options Set the Server DNS name to the external host name you'd like in the URL. You'll probably have to restart the WHD service or reboot. I hope it helps. Full credit has to go to SolarWinds support for this.

You want the interface down alert to SSH on to the device and show the interface detail, in the alert text? This isn't possible out of the box, as NPM polls network devices via SNMP and doesn't have the capability to SSH to a device. Even if you were to create a script, and attach it to the alert as an action, it will be…

Can you SSH from the Orion server to the device in question, with the same credentials? It is probably either being blocked by network security or your credentials are wrong. If you can SSH from Orion, with the same credentials and login then you've proved that bit works. If you can log in, also check that the enable and…

There are a few canned reports already available, for the interface reporting. Have a look under the Reports section and have a search for reports containing the word 'percentile'. These reports can easily be copied and modified, to suit your requirements and will give you a good starting point. And have you tried to…

Have you checked the SolarWinds port requirements documentation? Port requirements for all SolarWinds products - SolarWinds Worldwide, LLC. Help and Support

As long as the Windows 10 servers (10.x.x.x.) have the correct network access, you can point their Desktop Notification clients directly at your Orion server (in 192.168.x.x.) and they will work. You only need to install the notification client, onto the computer you want to see/hear the alerts upon, so no, you won't need…

Hi Bootneck1111, 1. Get the Desktop Notification Tool from your Orion server- http://<your solarwinds server>/DesktopNotificationTool/SolarWinds.DesktopNotificationTool.msi See for more details:…

I think you'll find it's down to the IIS onfiguration, if you look under the Authentication you will find that Windows authenication is enabled. This way it passes the credentials you logged into your Windows session with, straight to IIS,as you log into Orion.

Bump...

You could split IPAM off your Orion platform to its own server (uninstall, reinstall on a separate server and point to existing DB instance), if you have a separate IPAM DB instance from the rest of your SolarWinds DBs. If it is a common Orion DB, you may need to just start again (export everything from old IPAM, import…