Change template count

Change template count

SELECT    ct.NAME "Template", 
          Count(chdt.changeid) "count" FROM      changedetails chdt 
LEFT JOIN changetemplate ct 
ON        chdt.templateid=ct.templateid 
WHERE     chdt.createdtime >= <from_lastmonth> 
AND       chdt.createdtime <= <to_lastmonth> 

          • Related Articles

          • Incident and Service Catalog Template Frequency

            1 . This report is used to find the most used template in the application.   To make any changes to a query, refer to the KB article below. SELECT ...
          • How to assign CAB members to a change request automatically.

            This is a sample script to add CAB Members to a Change Request through Change Custom Triggers.The CAB Members can only be added manually to the Change Request ,under the Approval Tab, after it has been created.By using this script we will be able to ...
          • How to create a change automatically based on a schedule

            This is a sample python script that triggers the creation of a Change Request in ServiceDesk Plus using the Change API based on a schedule A short guide on setting up python is available here. Execution steps: 1. Download the attached zip 2. ...
          • How to automatically create a project and associate it to a change using change custom triggers.

            This script is applicable only for builds prior to 11138. This post describes the use of a sample python script you to create a Project automatically from a Change request and create a association between them.This script can be configured under ...
          • Template configuration

            This report will give you the complete list of templates configured in the application.  MSSQL SELECT serd.Name "Service Category", max(list.Templatename) "Template Name", STUFF( (SELECT ',' + tgm.QUEUENAME FROM TemplateToGroupMapping tgm WHERE ...