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
Change Risk Assessment Questionnaire using Custom module - Implementation steps
We’re excited to share a step-by-step guide( Attached) on implementing a Change Risk Assessment Questionnaire in ServiceDesk Plus using the Custom Module feature. This solution leverages Custom Modules, Change Additional Fields, and Field & Form ...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 ...Integrating Zoho Projects with SDP MSP change management
Overview: Automatically creating projects in Zoho Projects based on the changes in SDP MSP keeps everything in sync without manual updates. This means all tasks and updates on a Change are automatically reflected in Zoho Projects, making it easier to ...How to change CI type of an Asset
- Navigate to CMDB->Servers. - Search for the asset to which you need the CI type to be changed. - Choose the asset with their corresponding checkbox from the list and click on Actions->Modify CI type. - Choose the CI type from the list and click on ...Remote AE (Asset Scanning) Behavior changes
You can download the compatible version of Remote AE from the installed version of ServiceDeskPlus-MSP. Please go to Admin > Distributed Asset Scan and make use of the below highlighted. If you already have Asset Explorer in older versions, please ...