Sccm Inventory Query

Sccm’de custom query ile basit bir envanter raporu almak için aşağıdaki query’i kullanabilirsiniz.

select SMS_G_System_COMPUTER_SYSTEM.Name, SMS_G_System_COMPUTER_SYSTEM.UserName, SMS_G_System_OPERATING_SYSTEM.Description, SMS_G_System_SYSTEM_ENCLOSURE.ChassisTypes, SMS_G_System_OPERATING_SYSTEM.Name from  SMS_R_System inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_SYSTEM_ENCLOSURE on SMS_G_System_SYSTEM_ENCLOSURE.ResourceID = SMS_R_System.ResourceId