4 Replies Latest reply on Nov 22, 2016 11:04 AM by RichardLetts

    SQL - Bulk update Interface Statistics interval

    wlipford

      Hey Guys,

       

      I have a requirement to change interface statistics collection to a non global setting based on a custom property on the node level. I have the query where I pull the NodeID that match the criteria and I know the Interface properties to key on, (these are backup interfaces so we don't need the frequency of stats that are global default)

       

      I want to know if its simply changing the column value StatCollection in the Orion.NPM.Interfaces table.

       

      Something along the lines of

       

      update Orion.NPM.Interfaces

      set StatCollection = '30'

      where NodeID = 'XYZ'