Query for Workstations Division to Desktop & Laptop

Query for Workstations Division to Desktop & Laptop

I have some assets in my warehouse including worksations (desktop/laptop), PC monitors, switches etc.
I run the following query in order to retrieve some data about my warehouse.
The problem is that  in the exported xls I cannot divide the workstations into desktop/laptop.

  1. SELECT PRODUCTTYPE.COMPONENTTYPENAME "Urun",
  2. PRODUCT.COMPONENTNAME "Ürün",
  3. COUNT(RESOURCE.RESOURCEID) "Adet",
  4. STATE.DISPLAYSTATE "Durum",
  5.         AAOV.NAME "Depo"
  6. FROM RESOURCES RESOURCE
  7. LEFT JOIN COMPONENTDEFINITION PRODUCT ON RESOURCE.COMPONENTID = PRODUCT.COMPONENTID
  8. LEFT JOIN RESOURCELOCATION RESLOCATION ON RESOURCE.RESOURCEID = RESLOCATION.RESOURCEID
  9. LEFT JOIN SITEDEFINITION SITEDEF ON RESLOCATION.SITEID = SITEDEF.SITEID
  10. LEFT JOIN SDORGANIZATION AAOV ON SITEDEF.SITEID = AAOV.ORG_ID
  11. LEFT JOIN COMPONENTTYPE PRODUCTTYPE ON PRODUCT.COMPONENTTYPEID = PRODUCTTYPE.COMPONENTTYPEID
  12. LEFT JOIN RESOURCESTATE STATE ON RESOURCE.RESOURCESTATEID = STATE.RESOURCESTATEID
  13. LEFT JOIN RESOURCECOST RESC ON RESOURCE.RESOURCEID = RESC.RESOURCEID
  14. WHERE PRODUCTTYPE.COMPONENTTYPENAME != 'Software'
  15. AND PRODUCTTYPE.COMPONENTTYPENAME = 'Workstation'
  16.         AND STATE.DISPLAYSTATE = 'In Store'
  17.         AND AAOV.NAME ='Levent B3 Depo'
  18. GROUP BY PRODUCTTYPE.COMPONENTTYPENAME, PRODUCT.COMPONENTNAME, STATE.DISPLAYSTATE,AAOV.NAME ,ACQUISITIONDATE,EXPIRYDATE ORDER BY 2,3

                  New to ADSelfService Plus?