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
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 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()) + ...