Change stage history
SELECT chdt.changeid "Change ID",
chdt.title "Title",
orgaaa.first_name "Requested by",
ownaaa.first_name "Technician",
Longtodate(chdt.createdtime) "Created Time",
Longtodate(chdt.scheduledstarttime) "Scheduled Start Time",
Longtodate(chdt.scheduledendtime) "Scheduled End",
Longtodate(chdt.completedtime) "Completed Time",
stagedef.NAME "Change Status",
aau1.first_name "Changed By",
Longtodate(cdh.operationtime) "Changed On",
stdp.NAME "Changed From",
stdc.NAME "Changed To" FROM changedetails chdt
LEFT JOIN sduser orgsd
ON chdt.initiatorid = orgsd.userid
LEFT JOIN aaauser orgaaa
ON orgsd.userid = orgaaa.user_id
LEFT JOIN sduser ownsd
ON chdt.technicianid = ownsd.userid
LEFT JOIN aaauser ownaaa
ON ownsd.userid = ownaaa.user_id
LEFT JOIN change_stagedefinition stagedef
ON chdt.stageid = stagedef.wfstageid
LEFT JOIN changehistory cdh
ON chdt.changeid = cdh.changeid
LEFT JOIN changehistorydiff cdhd
ON cdh.historyid = cdhd.historyid
LEFT JOIN aaauser aau1
ON aau1.user_id = cdh.operationownerid
LEFT JOIN change_stagedefinition stdp
ON Cast(cdhd.prev_value AS VARCHAR) = Cast(
stdp.wfstageid AS VARCHAR)
LEFT JOIN change_stagedefinition stdc
ON Cast(Cast(cdhd.current_value AS VARCHAR) AS
INT) = stdc.wfstageid
WHERE cdhd.columnname IN ( 'WFSTAGEID' )
ORDER BY 1
New to ADSelfService Plus?
Related Articles
Change Status history
SELECT chdt.changeid "Change ID", chdt.title "Title", orgaaa.first_name "Requested by", ownaaa.first_name "Technician", ...Automating change stage transition based on task completion
PURPOSE: To automatically move to the next change stage when all tasks are closed, using task custom function and task custom trigger. The attached script triggers upon the closure of each task, verifying whether all tasks within the current stage ...Remove change stage comment box and rename actions buttons
Is it possible to remove the comment boxes that appear when moving to the next stage? Yes, navigate to Admin->Change Template->Edit the necessary template->Field Status comments->Disable Mandatory option. Is it possible to rename the action buttons ...Query to retrieve users login and logout history and find their current status
REQUIREMENT: To generate a report that contains the login and logout history of users and to determine the current user status. TESTED IN: Builds 14503 (Postgres) QUERY 1: The following query provides the login and logout history of users. SELECT ...Change Auto closure
This will be helpful in auto closing change request after X days it is in review stage. This use case is more suitable in environments where ONLY Requesters (customers) are the Change Reviewers and they want the Change to be closed if no review is ...