SMSUG.ca

...your virtual communITy
Welcome to SMSUG.ca Sign in | Join | Help
in Search

Garth Jones

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"
		)

Comments

No Comments

This Blog

Syndication

News

Training

Powered by Community Server (Non-Commercial Edition), by Telligent Systems