Asset System tab

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 ADManager Plus?

          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", ...