Asset System tab
SELECT workstation.workstationname "Workstation",
ua.username "User Name",
ua.domainname "Domain Name",
ua.description "Description",
ua.status "Status",
state.displaystate "Asset State" FROM usersaccountinfo ua
LEFT JOIN systeminfo workstation
ON ua.workstationid = workstation.workstationid
LEFT JOIN resources resource
ON workstation.workstationid = resource.resourceid
LEFT JOIN resourcestate state
ON resource.resourcestateid = state.resourcestateid order by 1
New to ADSelfService Plus?
Related Articles
Hide Asset
Use case If Technicians want to hide Asset field during template loading, then the same can be achieved using Execute Script option in Field and Form Rules. Solution Edit the incident/service template from which the asset needs to be hidden, choose ...Asset Scan Issues
1. Either access denied for the user or the remote DCOM option might be disabled in the workstation. 2. User does not have the access privileges to perform this operation. 3. One of the WMI components is not registered properly. 4. Execution failure ...Asset Ownership History Report
Please use the below query to get the report on Asset Ownership History. SELECT r.resourcename AS "Workstation Name", ct.componenttypename AS "Product type", rs.displaystate AS "Asset State", aa.first_name AS "Assigned User", LONGTODATE(sh.starttime) ...MSP - Remote Asset Explorer Compatible Versions
Remote Asset Explorer-MSP Compatible Version From MSP 14000 - Compatible RAE version 6970-6985 From MSP 13000 - Compatible AE version (6900-6979). But RAE - DC integration, - If 6900,6901 RAE is used, then latest DC will not work. Bundled DC in RAE ...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", ...