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 


          • 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",  ...
          • Change details

            SELECT    chdt.changeid "Change ID",            chdt.title "Title",            Longtodate(chdt.createdtime) "Created Time",            Longtodate(chdt.scheduledstarttime) "Scheduled Start Time",  ...