For full details see: https://social.technet.microsoft.com/Forums/en-US/configmgrinventory/thread/4d84e5f9-fd48-4fcb-b490-d0a64052aa08
selectSMS_R_System.NamefromSMS_R_SystemwhereSMS_R_System.ResourceId not in(selectSMS_G_System_PARTITION.ResourceIdfromSMS_G_System_PARTITIONwhereSMS_G_System_PARTITION.DeviceID = "Disk #0, Partition #1"
)
Recent Comments