Query to find all the laptops in an SMS environment

select v_r_system.Name0
from v_R_System
inner join v_GS_SYSTEM_ENCLOSURE on v_GS_SYSTEM_ENCLOSURE.ResourceId = v_R_System.ResourceId
where v_GS_SYSTEM_ENCLOSURE.ChassisTypes0 in ('8','9','10','11','12','14','18','21')

Description:

The query lists laptops based on the chassis info from one of the SQL view in SMS DB.