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
Article Type
How To


Question
How do I clear a single users Helpdesk settings including (but not limited to) recents, grid layouts, records per page etc...

Answer
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.


Legacy ID



1043


Article URL http://www.symantec.com/docs/HOWTO1003


Terms of use for this information are found in Legal Notices