Bulk edit nodes

Question

Hello experts,

i've a thousand servers wich the "asset inventory" is not enabled.

is there any way to buk edit these nodes and check the "asset inventory" box?

victorg89 · Answer

This only works to disable, when it's enabled the line doesn't exist in the database.

CourtesyIT · Answer

Yes, it will take some SQL querying.  You will need to find the location in the database that contains this field and edit nodes for them.

Actually, it might be easier and safer if you use Orion SDK and the consult @KMSigma.SWI posts on best practices.

s-bolyard · Answer

I found this article on disabling it, but you can change it from 0 to 1.  Test it on one to make sure it works.

https://support.solarwinds.com/SuccessCenter/s/article/Disable-Remove-Asset-Inventory-data-collection

UPDATE [dbo].[AssetInventory_Polling]                                                                                                                                                                       SET Enabled = 1