0 Replies Latest reply on Aug 9, 2016 12:58 PM by jkofoed

    Update Solarwinds via SQL query

    jkofoed

      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?

       

      Thanks!

       

      Jason