How to clear all settings for a specific user

Article:HOWTO1003  |  Created: 2005-08-24  |  Updated: 2007-01-09  |  Article URL
Article Type
How To

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.

Legacy ID


Article URL

Terms of use for this information are found in Legal Notices