Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Getting Switch Port details through SDK-API

Hi,

I am new user of Orion , and having less knowledge of scripting and all. I am using UDT and having a Change Management System. My requirement is --through that CMS web API, I will send an IP address to Orion UDT, and in return need Corresponding Switch and Port details from UDT. If anyone can help to achieve this through SDK/API/Script etc...

Find more posts tagged with

Accepted answers

tdanner

I have attached a sample PowerShell script to get NCM to execute a script on a device. Hope that helps!

NCM.ExecuteScript.ps1

All comments

tdanner

Something like this should get you what you need. I'll give the example in powershell:

Add-PSSnapin SwisSnapin

$swis = Connect-Swis -Hostname yourorionserver # this will prompt you for credentials

Get-SwisData $swis "SELECT n.IP_Address, n.Caption, p.Name, p.Speed, p.PortType FROM Orion.Nodes n JOIN Orion.UDT.Port p ON n.NodeID = p.NodeID WHERE n.IP_Address = @ip AND p.IsExcluded = 0 AND p.IsMissing = 0" @{ip="1.2.3.4"}

That should get you the name and management IP of the connected switch, plus the name, speed, and type of the port it is on.

adat

Thanks tdanner, I am little bold now. I want to achieve as mentioned below.... Can these be achieved through Orion---

A user desktop is connected with Switch ‘X’ in port Number ‘1’. The VLAN membership configured in the port ‘1’as VLAN ‘A’.
The user desktop will get an IP address (Say 10.1.1.1) from ‘A’ VLAN subnet , from the DHCP server.
Likewise Switch X having multiple such other user desktops are connected with.
In same way there might have multiple other switches in LAN like ‘Y’, ‘Z’ etc. where multiple other desktops are connected with.
Desktops one NIC card will be physically connected with one switch port, and the NIC will have single MAC address.
In switch ‘X’ there will be one MAC to corresponding IP address in ARP table.
Our Ticketing system will be sending an IP address to UDT, like 10.1.1.1 in this example. And an would be VLAN ID , let’s say VLAN ‘B’ for this example.
UDT will take the IP Address (10.1.1.1) and will check in his DB and will return—Direct connection details of this IP ---
- Switch ‘X’
- Port number ‘1’
- Present VLAN ‘A’

9. The above output of point number ‘8’ (a,b &c) will be passed on to NCM

10 Would be VLAN ID ‘B’ also passed to NCM in step 7.

11. Now NCM will generate a script to ---

- Remove VLAN ‘A’ from switch ‘X’, Port number ‘1’
- Add VLAN ‘B’ membership in switch ‘X’ Port number ‘1’.
- On completion will return a value to ticketing system as Done or Not Done.

tdanner

That's a neat use case. The NCM side of that - scripting NCM to run a config template with some parameters - is something the product isn't ready for yet. I'll make sure the product manager knows that you're interested in this.

adat

Thanks tdanner,

As per my understanding all information's are there in UDT, a SQL type query can get all those info ... NCM supports scripting /programming type template. Hence there are not much challenges to make the solution I am looking for. Please get in touch if this can be made as a solution for us ..we can discuss on potentiality and other prospects on this.

tdanner

I have attached a sample PowerShell script to get NCM to execute a script on a device. Hope that helps!

NCM.ExecuteScript.ps1