Query for computers with single partition

For full details see: http://social.technet.microsoft.com/Forums/en-US/configmgrinventory/thread/4d84e5f9-fd48-4fcb-b490-d0a64052aa08

select
SMS_R_System.Name
from
SMS_R_System
where
SMS_R_System.ResourceId not in
(
select
SMS_G_System_PARTITION.ResourceId
from
SMS_G_System_PARTITION
where
SMS_G_System_PARTITION.DeviceID = “Disk #0, Partition #1″
)

email

Written by , Posted .