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 Module Custom Functions
Sample Scripts for custom schedule. Steps to configure: 1. Copy the respective query and save the query report with a name. 2. Update the query report name in the custom schedule function script. 3. Configure a custom schedule with the custom ...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", ...