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>
GROUP BY ct.NAME
ORDER BY 1
New to ADSelfService Plus?
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. https://pitstop.manageengine.com/support/manageengine/ShowHomePage.do#Solutions/dv/24000633501275 SELECT ...How to assign CAB members to a change request automatically.
Note: Attached script will not work beyond 11138 SDP Version. 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, ...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 Note: Attached script will not work beyond 11138 SDP Version. A short guide on setting up python is ...Add tasks with dependencies for a change request created with a particular template
Requirement: Add tasks with dependencies for a change request created with a particular template. UseCase: Four Predefined tasks will be added to every change request created with "Maintenance" Template. Task Details: Scheduling Snapshots Linux ...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 ...