Wednesday, June 3, 2026

SQL Query laptops with Model

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

Author

  • Hi, I’m Haresh Hirani the mind behind Hiraniconfigmgr.com. I’m a seasoned IT professional with deep expertise in Microsoft technologies, especially in Configuration Manager (ConfigMgr/SCCM). Over the years, I’ve expanded my skill set to cover a broader range of modern device management platforms like Microsoft Intune, Jamf Pro, ManageEngine Endpoint Central, and VMware AirWatch (Workspace ONE UEM), I use this blog to document real-world, tested, working fixes and walkthroughs from my daily technical experiences. The 💡idea is simple: if it helped me, it might help someone like you. My goal is to create a living repository of practical IT solutions for the community. If you find something useful, or if you want to collaborate, feel free to connect with me on LinkedIn or drop a message through the Contact page. Happy to help.

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Latest posts