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 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 ...Query to show number of tickets created per template with their status (MSSQL & PGSQL)
Tested in build PGSQL (14300) and MSSQL (14306) SELECT reqtl.TEMPLATENAME "Request Template", count(wo.WORKORDERID) "Request Count", count(case when std.ispending='0' THEN 1 ELSE NULL END) "Completed", count(case when std.ispending='1' THEN 1 ELSE ...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 ...