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 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 Asset explorer license Explained
With the behavior change in the ServiceDeskPlus-MSP as mentioned in this post. Hope, you are aware that the Remote Asset explorer needs to be installed in each site, from where the assets will be pushed to ServiceDeskPlus-MSP. Considering the above, ...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 ...Query to show Asset state history ( MSSQL)
Tested in MSSQL build (14306) SELECT res.resourcename 'Asset Name', res.assettag 'Asset Tag',res.serialno 'Asset Serial No.', rs2.statedesc 'Previous State',rs1.statedesc 'Current State',DATEADD(s,DATEDIFF(s,GETUTCDATE() ,getdate()) + ...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 ...