Hello,

Is it possible to add the windows version to this query?

SELECT MAX("resource"."RESOURCENAME") AS "Asset Name", MAX("product"."COMPONENTNAME") AS "Product", MAX("aaaUser"."FIRST_NAME") AS "User", MAX("deptDef"."DEPTNAME") AS "Department"  FROM "Resources" "resource" LEFT JOIN "ComponentDefinition" "product" ON "resource"."COMPONENTID"="product"."COMPONENTID" LEFT JOIN "ComponentType" "productType" ON "product"."COMPONENTTYPEID"="productType"."COMPONENTTYPEID" LEFT JOIN "ResourceState" "state" ON "resource"."RESOURCESTATEID"="state"."RESOURCESTATEID" LEFT JOIN "ResourceOwner" "rOwner" ON "resource"."RESOURCEID"="rOwner"."RESOURCEID" LEFT JOIN "ResourceAssociation" "rToAsset" ON "rOwner"."RESOURCEOWNERID"="rToAsset"."RESOURCEOWNERID" LEFT JOIN "SDUser" "sdUser" ON "rOwner"."USERID"="sdUser"."USERID" LEFT JOIN "AaaUser" "aaaUser" ON "sdUser"."USERID"="aaaUser"."USER_ID" LEFT JOIN "DepartmentDefinition" "deptDef" ON "rOwner"."DEPTID"="deptDef"."DEPTID" WHERE  (("state"."DISPLAYSTATE" COLLATE Latin1_General_CI_AS = N'In Use') AND ("productType"."COMPONENTTYPENAME" COLLATE Latin1_General_CI_AS = N'Workstation'))   GROUP BY "resource"."RESOURCEID" ORDER BY 4, 1