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