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
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 ...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", ...How to check System Info using WBEMTEST
There are issues where the Service Tag , Serial Number or other system information are not correct in the scan results.We can get BIOS & other setting from the wbemtest tool (Inbuild Microsoft WMI tool) and compare it with the results ...Asset group
SELECT max(resgrp.GROUPNAME) AS "Group Name", MAX(resource.RESOURCENAME) AS "Asset Name", MAX(state.DISPLAYSTATE) AS "Asset State", MAX(rCategory.CATEGORY) AS "Asset Category", MAX(product.COMPONENTNAME) AS "Product", ...Request deleted by technician
This report is used to find the deleted request in the application. We can get the data from the Trash and system log viewer. To make any changes to a query, refer to the KB article below. ...