ServiceDesk

 View Only

Update Incident Templates to Make Public If Created as User Only 

Sep 18, 2012 01:31 PM

One of our Help Desk leads created several incident templates to standardize common tickets but forgot to uncheck the box for "User Only Template".  This made the templates only available to him and no one else.  This is something that can't be fixed from the console and must be done from the database directly.  As I spent a few hours today working on this I figured I'd share the fix in hopes of helping someone else.  This was performed in 7.1 SP2, but I would assume its the same for 7.0 and 7.1 SP1, but you should test in Dev first always!

Find the Incident Template

Login to your SQL server and run the following query: select * from dbo.ServiceDeskIncidentTemplate

This will give you a list of all the templates in your system.  Look at the template_user column and find the user that created the template.  If the template_user is anything besides System, then it will only show for the listed user.  You can also look at the template_name column for the name of the template, which might be easier.

Update the template_user column

To update the template_user with System so all technicians can see the template use the query below.

update dbo.ServiceDeskIncidentTemplate
set template_user='System' where template_user='TemplateCreatorsEmail@YourCompany.com'

I was also able to make a similar change based off of the template_name field by using:

update dbo.ServiceDeskIncidentTemplate
set template_user='System' where template_name='TemplateName'

 

I hope this helps someone!

 

Statistics
0 Favorited
0 Views
0 Files
0 Shares
0 Downloads

Tags and Keywords

Related Entries and Links

No Related Resource entered.