How to clear all settings for a specific user
|Article:HOWTO1003|||||Created: 2005-08-24|||||Updated: 2007-01-09|||||Article URL http://www.symantec.com/docs/HOWTO1003|
How do I clear a single users Helpdesk settings including (but not limited to) recents, grid layouts, records per page etc...
All user specific settings used by Helpdesk are stored in the tag table.
Run this query to remove all tag entries for a specific user:
Delete from tag where Tag_collection_id =
(Select Tag_collection_id from contact where NT_ID = 'Domain\User')
Substitute the user's information in the above query where it says Domain\User
If you are unsure of the users NT_ID value run this query:
select nt_id from contact where name like '%UserName%'
where UserName is a string that matches all or part of the user.
Article URL http://www.symantec.com/docs/HOWTO1003