How to disable auto list refreshing for an SCM console user. (NETIQKB72037)

Unable to login to the SCM console completely with it hanging up and or freezing on me.

If a customer is unable to access the tools\settings\Config and uncheck autorefresh enabled then a script will need to be run on the database.  The script requires that the id for the user from the SCM database be input before running the script.  To locate the PSUserID in the Vigilent Database under tables select the PSUsers Table and return all rows.  Locate the userid and corresponding ID number and replace the number in this script.

sp_SaveVigUserProperty @PSUserID = 123, @PropertyScope ='VSOCMisc' , @PropertyName = 'RefreshEnabled', @PropertyValue = 'false'

 

The refresh rate in SCM is set to 2 seconds by default which can cause a constant state of refresh if the lists are large.  The console will constantly send refresh requests and never complete a load of the screen since it is refreshing other screens at the same time.

Formerly known as NETIQKB72037