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.
- SELECT PRODUCTTYPE.COMPONENTTYPENAME "Urun",
- PRODUCT.COMPONENTNAME "Ürün",
- COUNT(RESOURCE.RESOURCEID) "Adet",
- STATE.DISPLAYSTATE "Durum",
- AAOV.NAME "Depo"
- FROM RESOURCES RESOURCE
- LEFT JOIN COMPONENTDEFINITION PRODUCT ON RESOURCE.COMPONENTID = PRODUCT.COMPONENTID
- LEFT JOIN RESOURCELOCATION RESLOCATION ON RESOURCE.RESOURCEID = RESLOCATION.RESOURCEID
- LEFT JOIN SITEDEFINITION SITEDEF ON RESLOCATION.SITEID = SITEDEF.SITEID
- LEFT JOIN SDORGANIZATION AAOV ON SITEDEF.SITEID = AAOV.ORG_ID
- LEFT JOIN COMPONENTTYPE PRODUCTTYPE ON PRODUCT.COMPONENTTYPEID = PRODUCTTYPE.COMPONENTTYPEID
- LEFT JOIN RESOURCESTATE STATE ON RESOURCE.RESOURCESTATEID = STATE.RESOURCESTATEID
- LEFT JOIN RESOURCECOST RESC ON RESOURCE.RESOURCEID = RESC.RESOURCEID
- WHERE PRODUCTTYPE.COMPONENTTYPENAME != 'Software'
- AND PRODUCTTYPE.COMPONENTTYPENAME = 'Workstation'
- AND STATE.DISPLAYSTATE = 'In Store'
- AND AAOV.NAME ='Levent B3 Depo'
- GROUP BY PRODUCTTYPE.COMPONENTTYPENAME, PRODUCT.COMPONENTNAME, STATE.DISPLAYSTATE,AAOV.NAME ,ACQUISITIONDATE,EXPIRYDATE ORDER BY 2,3
New to ADSelfService Plus?