Reports or console items hold old cached data - How to clear stored user navigation history.

Products

• IT Management Suite

Issue/Introduction

The SMP (Symantec Management Platform or Notification Server) Console stores navigation history for users so that when they are accessing the SMP Console it will open up to the most recently visited page. Sometimes it might be necessary to clear this information.
For example, permissions have been changed so users shouldn't have access to certain pages or a custom view/menu item was deleted.

Another example of a problem is where old cached information is shown when loading reports.

This is also useful when resetting a user's console session back to default.

Environment

ITMS 8.x

Resolution

Note: Before deleting any entry from the database, make sure you have a recent backup of it just in case.

To clear all user settings and navigation history by truncating the Usersettings table:

truncate table usersettings

 

To delete cache on a per-user basis, run the following query to find the user name:

select distinct vi.Name, stu.Trustee from sec_Trustee stu
join vitem vi on vi.Guid = stu.TrusteeGuid
join UserSettings uss on uss.Sid = stu.Trustee​

Find the user and copy the value in the Trustee Column and copy to the next query:

delete from UserSettings
where Sid ='Trustee from previous query'

 

To delete a specific date range (per se, the last day that this user was able to access the SMP Console):

delete from UserSettings
where ModifiedDate = '2024-08-23%'
and Sid = 'Trustee from previous query'

 

The next time the user accesses the console after the settings have been deleted, it will load the first time set up page. 

It may be required to clear the local users' internet cache for the changes to be fully shown.