
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Is there any way "out of the box" to track how many times a template is used by operators? We want to see if there are old templates that are not being used.
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
No. You'd have to custom build something, either by writing back to the Template record itself to modify the sysmodcount value, or by changing the template to update some hidden value in the record that you could search on.
That second route would probably be easiest. Pick a field that isn't being used in your implementation of Service Manager. Update each Template record to populate that field in the ticket with the name of the Template being used. Then, you could search your tickets for that Template and get a count of how often tickets are created/updated using that template.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
No. You'd have to custom build something, either by writing back to the Template record itself to modify the sysmodcount value, or by changing the template to update some hidden value in the record that you could search on.
That second route would probably be easiest. Pick a field that isn't being used in your implementation of Service Manager. Update each Template record to populate that field in the ticket with the name of the Template being used. Then, you could search your tickets for that Template and get a count of how often tickets are created/updated using that template.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
I like your suggestion but I found that table TEMPLATEA1 in SQL counts the number of times a template is used. I am not sure if the data is daily, monthly or what but it seems to shed some like on the count for me.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Nope the table TEMPLATEM1 shows the sysmod field and you are correct that does show the number of times the record was altered. The TEMPLATEA1 shows Name (of the template) Record_Number (how many times recorded used - ROLE (who can use it) - TABLENAME (which table it was used on)
Here is an example...I added the dashes in the first line to indicate the breakes.
AD-Network - Unlock Generic Account – ChangeAuditor Alert - 14 - incident analyst - incidents
AD-Network - Unlock Generic Account – ChangeAuditor Alert 15 incident coordinator incidents
AD-Network - Unlock Generic Account – ChangeAuditor Alert 16 incident manager incidents
AD-Network - Unlock Generic Account – ChangeAuditor Alert 17 KCS I for KM incidents
AD-Network - Unlock Generic Account – ChangeAuditor Alert 18 KCS II for KM incidents
AD-Network - Unlock Generic Account – ChangeAuditor Alert 19 KCS III for KM incidents
AD-Network - Unlock Generic Account – ChangeAuditor Alert 20 MHC CR Local Analyst Group incidents
AD-Network - Unlock Generic Account – ChangeAuditor Alert 21 MHC Functional Groups incidents
AD-Network - Unlock Generic Account – ChangeAuditor Alert 22 MHC Help Desk incidents

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
I take that back... after looking closer it seems this list the different groups or ROLES that have access to the template... So your suggestion seems to be the better choice.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Yeah.. that a1 table is just one of the ways HPSM stores array-type values. Each of the "RECORD_NUMBER" values corresponds to that record's position in the array.