I have a case where I need to update IIS Application Pools by marking them unmanaged. I load up the msssql client and run a query
UPDATE [Solarwinds].[dbo].[APM_IisBbApplicationPools] SET [ManagedPipelineMode] = 0 WHERE [ID] IN (531,534,535)
This runs fine and updates the database. However Solarwinds does not update the webpage. Is there a way to tell Solarwinds to update itself once a SQL query is performed? Is there another query, trigger or procedure that needs to run to push the update to Solarwinds?