Change details

Change details




SELECT    chdt.changeid "Change ID", 
          chdt.title "Title", 
          Longtodate(chdt.createdtime) "Created Time", 
          Longtodate(chdt.scheduledstarttime) "Scheduled Start Time", 
          Longtodate(chdt.scheduledendtime) "Scheduled End", 
          Longtodate(chdt.completedtime) "Completed Time", 
          orgaaa.first_name "Requested by", 
          ownaaa.first_name "Technician", 
          priodef1.priorityname "Priority", 
          urgdef.NAME "Urgency", 
          ctdef.NAME "Change Type", 
          stagedef.NAME "Change Status", 
          approvaldef.statusname "Approval Status", 
          catadef.categoryname "Category", 
          subcatadef.NAME "Subcategory", 
          itemdef1.NAME "Item", 
          chandes.full_description "Description", 
          cr.rolloutplan "Roll Out Plan", 
          cr.backoutplan "Back Out Plan", 
          cr.impactdesc "Impact Descritpion", 
          cr.checklist "Check List", 
          cr.review "Review", 
          sdo.NAME "Site" 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 prioritydefinition priodef1 
ON        chdt.priorityid=priodef1.priorityid 
LEFT JOIN urgencydefinition urgdef 
ON        chdt.urgencyid=urgdef.urgencyid 
LEFT JOIN changetypedefinition ctdef 
ON        chdt.changetypeid=ctdef.changetypeid 
LEFT JOIN stagedefinition stagedef 
ON        chdt.stageid=stagedef.stageid 
LEFT JOIN approvalstatusdefinition approvaldef 
ON        chdt.appr_statusid=approvaldef.statusid 
LEFT JOIN categorydefinition catadef 
ON        chdt.categoryid=catadef.categoryid 
LEFT JOIN subcategorydefinition subcatadef 
ON        chdt.subcategoryid=subcatadef.subcategoryid 
LEFT JOIN itemdefinition itemdef1 
ON        chdt.itemid=itemdef1.itemid 
LEFT JOIN changeresolution changeResol 
ON        chdt.changeid=changeresol.changeid 
LEFT JOIN changetocharge changeCharge 
ON        chdt.changeid=changecharge.changeid 
LEFT JOIN chargestable chargeTable 
ON        changecharge.chargeid=chargetable.chargeid 
LEFT JOIN aaauser ownaaa1 
ON        chargetable.technicianid=ownaaa1.user_id 
LEFT JOIN changetodescription chandes 
ON        chdt.changeid=chandes.changeid 
LEFT JOIN sitedefinition siteDef 
ON        chdt.siteid=sitedef.siteid 
LEFT JOIN sdorganization sdo 
ON        sitedef.siteid=sdo.org_id 
LEFT JOIN changeresolution cr 
ON        chdt.changeid=cr.changeid 
WHERE     chdt.createdtime >= <from_thisweek> 
AND       chdt.createdtime <= <to_thisweek>



                  New to ADSelfService Plus?

                    • Related Articles

                    • Query to retrieve the Change Details

                      Tested in: 14504, 14610 QUERY: SELECT chdt.CHANGEID AS "Change ID", cmDef.FIRST_NAME AS "Change Manager", ownaaa.FIRST_NAME AS "Change Owner", approvaldef.STATUSNAME AS "Approval Status", qd.QUEUENAME AS "Group", statusDef.STATUSDISPLAYNAME AS ...
                    • Change Submission and Planning stage details (PGSQL)

                      Tested in build PGSQL (14300) SELECT cdt.changeid "Change Request ID", orgaaa.FIRST_NAME AS "Change Requester", ownaaa.FIRST_NAME AS "Change Owner", cmDef.FIRST_NAME AS "Change Manager", manager.name "Line Manager", implementer.name "Change ...
                    • 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 ...
                    • How to assign CAB members to a change request automatically.

                      Note:  Attached script will not work beyond 11138 SDP Version. ​ This is a sample script to add CAB Members to a Change Request through Change Custom Triggers.The CAB Members can only be added manually to the Change Request ,under the Approval Tab, ...
                    • How to create a change automatically based on a schedule

                      This is a sample python script that triggers the creation of a Change Request in ServiceDesk Plus using the Change API based on a schedule Note:  Attached script will not work beyond 11138 SDP Version. ​ A short guide on setting up python is ...