Sccm Chassis Type

Örnek Query;

Tüm notebookları sorgulamak için; 

select SMS_R_System.ResourceId, SMS_R_System.ResourceType, SMS_R_System.Name, SMS_R_System.SMSUniqueIdentifier, SMS_R_System.ResourceDomainORWorkgroup, SMS_R_System.Client from  SMS_R_System inner join SMS_G_System_SYSTEM_ENCLOSURE on SMS_G_System_SYSTEM_ENCLOSURE.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SYSTEM_ENCLOSURE.ChassisTypes in ( “8”, “9”, “10”, “11”, “12”, “14”, “18”, “21” )

Belirli bir modele ait notebookları sorgulamak; 

select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceId = SMS_R_System.ResourceId where SMS_G_System_COMPUTER_SYSTEM.Model = “HP EliteBook Folio 1040 G3“

# Other (1)

# Unknown (2)

# Desktop (3)

# Low Profile Desktop (4)

# Pizza Box (5)

# Mini Tower (6)

# Tower (7)

# Portable (8)

# Laptop (9)

# Notebook (10)

# Hand Held (11)

# Docking Station (12)

# All in One (13)

# Sub Notebook (14)

# Space-Saving (15)

# Lunch Box (16)

# Main System Chassis (17)

# Expansion Chassis (18)

# SubChassis (19)

# Bus Expansion Chassis (20)

# Peripheral Chassis (21)

# RAID Chassis (22)

# Rack Mount Chassis (23)

# Sealed-case PC (24)

# Multi-system chassis (25)

# Compact PCI (26)

# Advanced TCA (27)

# Blade (28)

# Blade Enclosure (29)

# Tablet (30)

# Convertible (31)

# Detachable (32)

# IoT Gateway (33)

# Embedded PC (34)

# Mini PC (35)

# Stick PC (36)s