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", 
          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>

          • Related Articles

          • How to assign CAB members to a change request automatically.

            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, after it has been created.By using this script we will be able to ...
          • 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 A short guide on setting up python is available here. Execution steps: 1. Download the attached zip 2. ...
          • How to automatically create a project and associate it to a change using change custom triggers.

            This script is applicable only for builds prior to 11138. This post describes the use of a sample python script you to create a Project automatically from a Change request and create a association between them.This script can be configured under ...
          • How to automatically assign users to different roles in a change request.

            This script is applicable only for builds prior to 11138. This is a sample python script to read the value in the Change Owner field, when a Change Request is created and set him/her as the Change Implementer automatically, using Change Custom ...
          • Requester details

            This report is used to find the Requester complete details.  SELECT AaaUser.USER_ID, AaaUser.FIRST_NAME "FullName", AaaLogin.NAME "LoginName", AaaLogin.DOMAINNAME "Domain", AaaContactInfo.EMAILID "Email", DepartmentDefinition.DEPTNAME "Department", ...