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

        Resources

            • 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. ...