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 

        New to ADManager Plus?

          New to ADSelfService Plus?

            • 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 ...
            • Asset Module Custom Functions

              Sample Scripts for custom schedule. Steps to configure: 1. Copy the respective query and save the query report with a name. 2. Update the query report name in the custom schedule function script. 3. Configure a custom schedule with the custom ...
            • 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", ...