Get Laptop model by SQL query

SELECT
se.ChassisTypes0 AS ‘Chassis’,
rs.Name0 AS ‘Name’,
rs.Description0 AS ‘Description’,
rs.Operating_System_Name_and0 AS ‘OS’,
se.Manufacturer0 AS ‘Manufacturer’,
cs.Model0 AS ‘Model’

FROM

v_R_System RS
JOIN v_GS_SYSTEM_ENCLOSURE SE on rs.ResourceID = SE.ResourceID
JOIN v_GS_COMPUTER_SYSTEM CS on rs.ResourceID = cs.ResourceID

Where ChassisTypes0 in ( ‘8’, ‘9’, ’10’,’11’, ’12’, ’14’,’18’,’21’)

Happy Learning!!!

Thanks & Regards,
Haresh Hirani
Email: hiraniconfigmgr@outlook.com
Follow me: https://www.linkedin.com/in/hiraniconfigmgr

Advertisements