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

    SQL - Bulk update Interface Statistics interval


      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'