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
Change Risk Assessment Questionnaire using Custom module - Implementation steps
We’re excited to share a step-by-step guide( Attached) on implementing a Change Risk Assessment Questionnaire in ServiceDesk Plus using the Custom Module feature. This solution leverages Custom Modules, Change Additional Fields, and Field & Form ...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 ...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 ...Update schedule start and end time for a change request
Requirement: When a Change request is submitted, the schedule start date must be set to current date and completion date to be set 10days after the current date This must be reflected in the created change request. Steps to follow: Goto Admin > ...Add and trigger predefined tasks to a change
Requirement: Add a set of tasks to a change and trigger them all at once. Steps to configure: Goto Admin > Developer Space > Global function > New > Paste the content from the attachment GF_4 - Configuration.txt and save it with a name. Update the ...