Dear Support,

I have a report that generates all laptop and desktop present in Asset category, I need to specify only in use computers for the report

SELECT CASE WHEN (compDefLaptop.ISLAPTOP IS NULL) THEN 'Desktop'
ELSE 'Laptop' END AS "Type", 
COUNT(workstation.WORKSTATIONNAME) "Number" FROM SystemInfo workstation 

LEFT JOIN Resources res ON workstation.WORKSTATIONID=res.RESOURCEID 
LEFT JOIN ComponentDefinition product ON res.COMPONENTID=product.COMPONENTID 
LEFT JOIN ComponentDefinitionLaptop compDefLaptop ON product.COMPONENTID=compDefLaptop.COMPONENTID 

WHERE (ISSERVER='0')  
GROUP BY compDefLaptop.ISLAPTOP
ORDER BY 1

please send the report

Regards

Mooez