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!!!


Happy Learning


Thanks & Regards,

Haresh Hirani

Email: hiraniconfigmgr@outlook.com

Follow me: https://www.linkedin.com/in/hiraniconfigmgr



0 Comments

    No Comments

Leave a Comment