Change asset involved

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", 
       subcatadef.NAME      AS "Subcategory", 
       itemdef1.NAME        AS "Item", 
       res.ciname           "Asset" 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 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 changetoci cta 
              ON cta.changeid = chdt.changeid 
       LEFT JOIN ci res 
              ON cta.ciid = res.ciid 
ORDER  BY 1 


      New to ADSelfService Plus?

        Resources

            • Related Articles

            • 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 ...
            • How to auto-create change request(s) for unplanned changes on Assets

              This post describes the use of a python script to auto-create change requests for unplanned modifications on Assets using Custom Schedules. This script is applicable only for builds prior to 11138. UseCase: Multiple assets are inventoried in ...
            • Change roles

              SELECT chdt.changeid               "Change ID",         chdt.title                  "Title",         orgaaa.first_name           "Change Requester",         ownaaa.first_name           "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",  ...