cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post

Possibility to activate the Asset Inventory View for all Nodes

Possibility to activate the Asset Inventory View for all Nodes

Hello there,

in my company, we have more than 2000 Server-Nodes (Not to Mention all of the Network-Nodes).

In the phase of the initial configuration of solarwinds, we didn't activate the Asset Inventory-Tab for our Nodes.

Now, after the initial configuration, we wanted to turn our attention to the other features of solarwinds and recognized that it isn't possible to activate the Asset Inventory-Tab for all nodes simultaneously. I think you understand that we can't manually check the box for every single node. I asked the support if maybe there's a way through a Database command, but they weren't able to help me.

I think I'm not the only one wo want to activate some settings like this for specific/all nodes at once.

Is there a way to solve my problem?

Thank you!

Greetings Dominic

10 Comments
Product Manager
Product Manager

Asset Inventory is enabled, even for existing nodes that are re-imported using the Network Sonar Discovery Wizard.

Level 12

Someway to do it other than NSD. In my inherited environment, we do not have any NSDs set up. From what I can tell, this only works per poller, so the more pollers you have, the more discoveries you have to run.  If I am wrong, let me know.

It would be nice to enable this via a Powershell script.

Level 8

Wouldn't this work:

UPDATE [main Orion database name].[dbo].[AssetInventory_Polling] set Enabled = 1;

Just found this post, so I am aware I respond to a rather old question:

i guess you would need to add the assets-poller as well. Just enabling it in the database is not enough.

there are some API/SDK discussions in the forum, you might want to check out those.

it's a good feature request.

Level 12

blitzsonik  wrote:

Wouldn't this work:

UPDATE [main Orion database name].[dbo].[AssetInventory_Polling] set Enabled = 1;

This will not work. If the node has not been assigned Asset Inventory, then there is no such record in the table.

Record in [AssetInventory_Polling] is not the only change, which happens when AI assigned using List Resources or discovery ...

Level 12

In recent versions of Asset Inventory, It is possible to disable multiple nodes using SWIS verb Orion.AssetInventory.Polling.DisablePollingForNodes.

So you can call it in SWQL studio like this:

2020-02-14 07_35_56-SWQL Studio.png

To generate a list of NodeIDs, which are required here you can use SWIS query similar to this:

SELECT  CONCAT('<int>', NodeID,'</int>') AS col1

FROM Orion.AssetInventory.Polling

Product Manager
Product Manager

tomasv  wrote:

In recent versions of Asset Inventory, It is possible to disable multiple nodes using SWIS verb Orion.AssetInventory.Polling.DisablePollingForNodes.

So you can call it in SWQL studio like this:

2020-02-14 07_35_56-SWQL Studio.png

To generate a list of NodeIDs, which are required here you can use SWIS query similar to this:

SELECT  CONCAT('<int>', NodeID,'</int>') AS col1

FROM Orion.AssetInventory.Polling

Marking this feature request as implemented per Tomas' instructions.

Level 12

I would recommend not to enable Asset Inventory for many hundreds of agentless nodes in single bulk.

If the nodes are polled via the Orion agent, then it is not an issue. But if all they are WMI agentless nodes, enabling them in one step could cause overloud of poller server in the time of polling (once per 24 hours or what polling frequency for AI is configured)