How do you mass disabled List Resources > Asset Inventory?

I don't remember it completely but then this points to multiple tables, its not just AssetInventory_Polling. 

jbiggley‌ - from what I understand you want to disable asset inventory on all of them,why do you need WHERE clause , try the below query:

UPDATE [instance_name].[dbo].[AssetInventory_Polling] SET Enabled = 0;

OR

UPDATE [dbo].[AssetInventory_Polling] SET Enabled = 0;

OR

UPDATE [instance_name].[dbo].[AssetInventory_Polling] set Enabled = 0;

OR

UPDATE [dbo].[AssetInventory_Polling] set Enabled = 0;

Hope it works

Try the below query: do not use a where clause

UPDATE [dbo].[AssetInventory_Polling] set Enabled = 0

Yeah, I tried that one -- it doesn't work.  It might actually disable the updates of that device via the AIP processes but it doesn't 'uncheck' the list resources box.

DELETE * FROM  [dbo].[AssetInventory_Polling]

Have you seen this KB?

SolarWinds Knowledge Base :: How to Disable Warranty and Asset Inventory Polling‌

Jeff

Where's my ignore button?

Dang -- I didn't.  Correct answer to jeff.stewart‌!  On the up side, I managed to figure out how to disable it all on my own - I just didn't know that I did