I am trying to follow this article to enable Asset Inventory on my Servers (selected via Custom Property). We have some that have SAM templates applied (agents), some being monitored via WMI (most of them) and some monitored via SNMP. Currently on version 2023.4.2 with SAM installed and some licenses in use. I was told by a sales engineer that the node won't need to consume a SAM license to enable this feature. I have isolated the nodes in a query, used the Concat to put the NodeIDs into the format required for the "Orion.AssetInventory.Polling.EnablePollingForNodes" Invoke but when I paste the NODEID into the invoke command array I get a 'false' returned in the bottom window. I have tried multiple NodeIDs, both in bulk and singly. I have looked at the log that the article says to look at and I don't see errors related to this unless they are showing something different than expected (such as complaining about AIops or something). I have also tried to limit it down to just WMI polling nodes but that didn't seem to work either. The SDK shows this should be read-only with false for Create and Update but the article says it's possible. Any ideas? This is what the invoke looks like: 4958 5068 4949 5236 4951 5071 And returns this: false

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

Trying to Enable AssetInventory on Server Nodes via SDK

I am trying to follow this article to enable Asset Inventory on my Servers (selected via Custom Property). We have some that have SAM templates applied (agents), some being monitored via WMI (most of them) and some monitored via SNMP. Currently on version 2023.4.2 with SAM installed and some licenses in use.
I was told by a sales engineer that the node won't need to consume a SAM license to enable this feature.

I have isolated the nodes in a query, used the Concat to put the NodeIDs into the format required for the "Orion.AssetInventory.Polling.EnablePollingForNodes" Invoke but when I paste the <int>NODEID</int> into the invoke command array I get a 'false' returned in the bottom window. I have tried multiple NodeIDs, both in bulk and singly.
I have looked at the log that the article says to look at and I don't see errors related to this unless they are showing something different than expected (such as complaining about AIops or something).
I have also tried to limit it down to just WMI polling nodes but that didn't seem to work either.

The SDK shows this should be read-only with false for Create and Update but the article says it's possible. Any ideas?

This is what the invoke looks like:

And returns this:

false

Find more posts tagged with

Accepted answers

tporritt

SELECT [N].Caption
     , CONCAT('', [N].NodeID, '') AS col1
     , [N].AssetInventory.Enabled
     , [N].ObjectSubType
     , [N].Status
FROM Orion.Nodes AS [N]
WHERE [N].AssetInventory.Enabled IS NULL
     AND [N].ObjectSubType NOT IN ( 'ICMP', 'SNMP' )
     AND [N].Vendor = 'Windows'
     AND [N].Staus <> '9'
     -- This is my filter on the Node's Custom Property called 'NodeType'
     AND [N].CustomProperties.NodeType LIKE 'Server'
ORDER BY [N].Caption

All comments

KMSigma.SWI

The EnablePollingForNodes verb takes the nodeIds as an array. From the outside, it looks like the XML you provided does meet the necessary requirements.

That said, I'm not 100% sure the node selection script in the above support article is what you need.

The way I understand it, the Orion.AssetInventory.Polling entity contains only those elements which are already flagged for Asset Inventory. In other words, the Enabled value serves no purpose. If it's in the list, then it's being polled for assets.

Therefore, the code provided in the article (below) will return things with Asset Inventory already created.

SELECT CONCAT('', NodeID, '') AS col1
FROM Orion.AssetInventory.Polling

This would be fine if you wanted to remove something from Asset Inventory.

I think the query you are looking for to generate the list of IDs to be added to Asset Inventory might be closer to: (tweak to your needs)

SELECT [Nodes].NodeID
     , [Nodes].Caption
     , [Nodes].ObjectSubType
FROM Orion.Nodes AS [Nodes]
WHERE [Nodes].ObjectSubType IN ( 'Agent', 'WMI' )
  AND [Nodes].Vendor = 'Windows'
  AND [Nodes].NodeID NOT IN (SELECT [PolledNodes].NodeID
      FROM Orion.AssetInventory.Polling AS [PolledNodes]
  )

So for the XML you're trying to generate, it would be:

SELECT CONCAT('', [Nodes].NodeID, '') AS [XmlArrayEntry]
FROM Orion.Nodes AS [Nodes]
WHERE [Nodes].ObjectSubType IN ( 'Agent', 'WMI' )
  AND [Nodes].Vendor = 'Windows'
  AND [Nodes].NodeID NOT IN (SELECT [PolledNodes].NodeID
      FROM Orion.AssetInventory.Polling AS [PolledNodes]
      WHERE [PolledNodes].Enabled = 'TRUE'
  )

I only had one such in my environment and was able to get a return value of TRUE when I put it in the array list for Orion.AssetInventory.Polling.EnablePollingForNodes.

tporritt

Unfortunately this gives the same 'false' message that I had before (and of course no context about why).
Still not seeing anything in that log that seems to pertain to this action.
With my initial query I was seeing 110 nodes without AssetInventory polling enabled, your query returns 36 nodes.
After plugging the resulting 36 XML array into the Invoke and running it, still getting 36 returned when I re-run the query.

I should have posted my earlier query as well, I was filtering down to nodes that were not enabled for Asset Inventory polling

select caption, CONCAT('', NodeID, '') AS col1, N.AssetInventory.Enabled, N.ObjectSubType
from Orion.Nodes N
where N.CustomProperties.NodeType like 'Server'
and N.AssetInventory.Enabled is NULL
and N.ObjectSubType not like 'ICMP'
and N.ObjectSubType not like 'SNMP'
order by Caption

shuth

Not exactly what you're after but a workaround would be to run a Network Discovery against the nodes you want to enable Asset Inventory. Untick all of the interfaces, volumes, AppInsight apps that are detected and "re-import" the nodes. It shouldn't re-add the node as it already exists but will enable the CPU/memory monitoring and Asset Inventory automatically. If you are running multiple polling engines, you'll need to split it up per assigned engine.

KMSigma.SWI

Dumb question of the day: what happens if you only send one node?

Can you post the actual XML you are sending (Insert > Code : Type XML)?

tporritt

I spot checked 5 of the 36 nodes and got the same 'false'.

Here is the XML

tporritt

That is worth exploring if we can do it from Powershell but I cannot seem to find the flag that would include Asset Inventory.
The example for single node import doesn't include such a thing: https://github.com/solarwinds/OrionSDK/blob/master/Samples/PowerShell/CRUD.AddNode.ps1
Similar with the singe node discovery: https://github.com/solarwinds/OrionSDK/blob/master/Samples/PowerShell/DiscoverWmiNode.ps1

The issue with the gui discovery is having to manually add all of the servers into the list, as we add more servers I need to come back and update that list.
Ideally, if it is handled via Powershell that can be a scheduled task to catch em all as they are onboarded.
We are then using SolarWinds as a source of truth on server software that we push into our Ivanti Helpdesk/CMDB