Change
Cab
SELECT changetocab.changeid "ChangeID", chdt.title AS "Title", ctdef.NAME AS "Change Type", ownaaa.first_name AS "Change Owner", ...
Change approval
SELECT chdt.CHANGEID AS "Change ID", chdt.TITLE AS "Title", orgaaa.FIRST_NAME AS "Change Requester", qd.QUEUENAME AS "Group", ownaaa.FIRST_NAME AS "Change Owner", catadef.CATEGORYNAME AS "Category", priodef1.PRIORITYNAME AS "Priority", ...
Change details
SELECT chdt.changeid "Change ID", chdt.title "Title", Longtodate(chdt.createdtime) "Created Time", Longtodate(chdt.scheduledstarttime) "Scheduled Start Time", ...
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> ...
Change roles
SELECT chdt.changeid "Change ID", chdt.title "Title", orgaaa.first_name "Change Requester", ownaaa.first_name "Change Owner", ...
Change stage history
SELECT chdt.changeid "Change ID", chdt.title "Title", orgaaa.first_name "Requested by", ownaaa.first_name "Technician", ...
Change Status history
SELECT chdt.changeid "Change ID", chdt.title "Title", orgaaa.first_name "Requested by", ownaaa.first_name "Technician", ...
Change asset involved
SELECT chdt.changeid AS "Change ID", chdt.title AS "Title", orgaaa.first_name AS "Change Requester", ownaaa.first_name AS "Change Owner", catadef.categoryname AS "Category", ...
Changes that were caused by Incidents
SELECT chdt.changeid "Change ID", chdt.title "Change Title", Longtodate(chdt.createdtime) "Change Created Time", Longtodate(chdt.completedtime) "Change Completed Time", ...
Incidents caused by Change
SELECT chdt.changeid "Change ID", chdt.title "Change Title", Longtodate(chdt.createdtime) "Change Created Time", Longtodate(chdt.completedtime) "Change Completed Time", ...