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 ...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 ...Increase/decrease Log Count
It is possible to increase/decrease the log files count, however increasing the files will have an impact on the performance of the application. Also it is not recommended to increase the count more than 30. The serverout count can be decreased in ...How to resize the fields in a change template
1. Under Admin >> Change Template >> Select Field and Form Rules 2. Create a rule on Form load and use the below script jQuery('#s2id_Change_REASONFORCHANGEID').attr("style","width:50%!important"); To send an acknowledgement email notifications to change owner for every reply conversation in change.
Overview The below document explains the steps that need to be configured for sending notifications to change owner for every reply conversation in changes. (i.e) When a reply is sent and a conversation is added to a change then the acknowledgment ...