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!!!
Haresh Hirani
Email: [email protected], [email protected]
Facebook https://www.facebook.com/Hiraniconfigmgr-120189361980772/
Follow us: https://www.linkedin.com/in/hiraniconfigmgr
Twitter: https://twitter.com/hiraniconfigmgr
X
0 Comments
No Comments