27.6 C
Ahmedabad
Friday, July 4, 2025
type here...
Community ResourceTools

SQL Query laptops with Model

By Haresh Hirani
0
519

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 Haresh Hirani, I am the person behind this webpage. Welcome to my page, Thank you for visiting the website and my page! My website is all about Microsoft technologies. More about ConfigMgr and all other technologies which are interesting for me. However, larger percentage of my posts are related to SCCM. Normally, like to post the interesting issues which I came across in my day to day tech life. you will find only solutions which comes on my day to day life.

Previous article
Microsoft WSUS and Configuration Manager SUP Maintenance
Next article
How to launch a specific task sequence from the command prompt

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Search

Latest posts

I’m the person behind this webpage. Thank you for visiting the website and about me page! My website is all about Microsoft technologies. More about ConfigMgr and all other technologies which are interesting for me. However, larger percentage of my posts are related to SCCM. Normally, like to post the interesting issues which I came across in my day to day tech life. you will find only solutions which comes on my day to day life.

Hot Category

Popular Post

© COPYRIGHT Hiraniconfigmgr.com

Developed By : Deepcoder