Query to show asset monitor details

Query to show asset monitor details

SELECT si.workstationname "Asset Name", si.workstationname  "Asset Name", mi.monitortype "Monitor Type", mi.serialnumber "Monitor Serial Number" from systeminfo si LEFT JOIN monitorinfo mi ON si.workstationid=mi.workstationid ORDER BY 1

          • Related Articles

          • Contract and Service Plans details - Query Report

            PGSQL & MSSQL: select ac.contractno "Contract Number", ac.contractname "Contract Name", sp.serviceplanname "Service Plan Name",sp.plantype "Service Plan Type", sp.timeperiod "Bill Cycle",fixedmonthlycharges "Fixed Base Charge",sp.fixedmonthlyunits ...

          • Query to show Asset details with Warranty Expiry Date

            SELECT productType.COMPONENTTYPENAME AS "Product Type", resource.RESOURCENAME AS "Asset Name", product.COMPONENTNAME AS "Product", productType.COMPONENTTYPENAME AS "Product Type", state.DISPLAYSTATE AS "Asset State", rtype.TYPE AS "Asset Type", ...

          • Query to show all asset details_ MSSQL

            MSSQL: SELECT MAX("resource"."RESOURCENAME") AS "Asset Name", MAX("resource"."ASSETTAG") AS "Asset Tag",MAX(resource.SERIALNO) AS "Org Serial Number", MAX("product"."COMPONENTNAME") AS "Product", MAX("productType"."COMPONENTTYPENAME") AS "Product ...

          • Query to show workstation details. PGSQL & MSSQL

            Below query will show Only workstations and its details.  SELECT Max(workstation.workstationname) "Workstation",         Max(workstation.servicetag)      "Service Tag",        Max(workstation.model)           "Model",         Max(osinfo.osname)      ...

          • Query to find asset history

            Use Case  The below will provide a report on the updates made on an asset  Query  select resources.resourcename as "Asset Name" ,auditoperation.operationstring as "Operation Performed", cihistorydetails.attribute as "Altered ...