Insert Nodes via DataBase

jimmy_mccubbins

I guess this has a couple of questions attached to it.

I want to be able to add nodes via ICMP real quick to SW through the DB.  

1: Can it be done?

2: SW says it shouldn't be done, but that doesn't mean it cant. So should it be done?

3: What repercussions may come from it?

4: What items have to be inserted with the INSERT command?

Here is what I am working with so far.

Insert INTO [NodesData] (IP_Address, Caption, ObjectSubType, RediscoveryInterval, PollInterval, EngineID) VALUES ('12.345.67.89', 'TESTNODE', 'ICMP', '45', 300', '6')

stevenstadel

It is never a good idea to add directly to the database, we have no idea if that method is populating all the tables needed. The supported way would be to add in new nodes with the Orion SDK and PowerShell to make sure all the relevant tables are populated. Releases · solarwinds/OrionSDK (github.com)

Here is an example I pulled from thwack of inserting ICMP nodes with a SWIS connection and a CSV. The CSV for the PowerShell below must have the headers "Caption", "IP_Address" and "Vendor" within the CSV. 

$OrionServer = "192.168.1.100"
$creds = Get-Credential
$swis = Connect-Swis -Credential $creds -Hostname $OrionServer
$nodes = Import-Csv -Path "C:\Users\Brent\Desktop\Thin-AP-List-2022-11-18.csv"

ForEach ($node in $nodes) {

	$newNodeProps = $null

	$newNodeProps = @{

		IPAddress = $node.IP_Address;
		Caption = $node.Caption;
		EngineID = 1;

		ObjectSubType = "ICMP";
		DNS = "";
		SysName = "";

		Vendor = $node.Vendor;

	}

	$newNodeUri = New-SwisObject $swis -EntityType "Orion.Nodes" -Properties $newNodeProps
	$nodeProps = Get-SwisObject $swis -Uri $newNodeUri

	$poller = $null

	$poller = @{

		NetObject = "N:"+$nodeProps["NodeID"];
		NetObjectType = "N";
		NetObjectID = $nodeProps["NodeID"];

	}

	# Status
	$poller["PollerType"] = "N.Status.ICMP.Native";
	$pollerUri = New-SwisObject $swis -EntityType "Orion.Pollers" -Properties $poller

	# Response time
	$poller["PollerType"] = "N.ResponseTime.ICMP.Native";
	$pollerUri = New-SwisObject $swis -EntityType "Orion.Pollers" -Properties $poller

	Write-Output("Node " + $node.NodeName + " has been added (" + $newNodeUri + ")")

}