Orion Asset Inventory

pagenw142

Hi,

I'm working on a project to script the creation of Nodes in Orion.  I have everything worked out with REST calls, except for adding the Asset Inventory.  I create the Asset Inventory poller with

$body =

@"

{
     "PollerType":"N.Asset.Inventory.Wmi.Generic",

     "NetObject":"N:$($NodeID)",

     "NetObjectType":"N",

     "NetObjectID":"$($NodeID)"

}

Invoke-RestMethod -Credential $cred -Uri "https://$($orionComputerName):17778/SolarWinds/InformationService/v3/Json/Create/Orion.Pollers" -ContentType "Application/json" -Body $body -Method POST

That creates the Asset Inventory Poller and I can see it in SWQL the same way one would see it as if the Asset Inventory were added from the UI. However, I can't seem to get the node added to the AssetInventory_Polling Table, which seems like is the place that the node has to be for it have the Asset Inventory actually functional in the UI.

Am I missing something?  Has anyone had any experience with this?  I've done a lot of searching on the subject, but haven't come up with much.

Thanks everyone!

rlibby

Hope this is not too late.

When you add the Asset Inventory poller via SWIS, the poller is not enabled by default. I added a quick PowerShell SQL Insert routine after adding the node that adds the Asset Inventory poller and set it to enabled. Since you are using WMI change line 24 from ServerSNMP to WindowsServerWMI.

1.  $ConnectionString = "server=<YourSQLServer>;database=<SolarWinds Database>;trusted_connection=true;"

2.  $Connection = New-Object System.Data.SQLClient.SQLConnection

3.  $Connection.ConnectionString = $ConnectionString

4.  $Connection.Open()

5.  $Command = New-Object System.Data.SQLClient.SQLCommand

6.  $Command.Connection = $Connection

7.  $SQLCMD = "SELECT COUNT(NodeID) FROM AssetInventory_Polling WHERE NodeID=$NodeID"

8.  $Command.CommandText = $SQLCMD

9.  $Result = $Command.ExecuteReader()

10. while ($Result.Read()) {

11.      $Count = $Result.GetValue($1)

12.  }

13.  $Connection.Close()

14.  IF ($Count -gt 0) {

15.      Write-Host "Node already configured for Asset Inventory"

16.  }

17.  ELSE {

18.      Write-Host "Configuring Node for Asset Inventory"

19.      $Connection = New-Object System.Data.SQLClient.SQLConnection

20.      $Connection.ConnectionString = $ConnectionString

21.      $Connection.Open()

22.     $Command = New-Object System.Data.SQLClient.SQLCommand

23.      $Command.Connection = $Connection

24.     $SQLCMD1 = "Insert into AssetInventory_Polling (NodeID, PollingDescriptionName, Enabled) Values ($NodeID,'ServerSNMP','1')"

25.      $Command.CommandText = $SQLCMD1

26.      $Result = $Command.ExecuteNonQuery()

27.  }

28.  $Connection.Close()