Portables with more than one partition on the primary hard drive

select s.ResourceID ,s.Name0, s.Resource_Domain_OR_Workgr0,s.Client0
from v_R_System s
inner join v_GS_Disk d on d.ResourceId = s.ResourceId 
inner join v_GS_SYSTEM_ENCLOSURE se on se.ResourceId = s.ResourceId 
where d.MediaType0 = 'Fixed hard disk media' and
d.Partitions0 > 1 and
d.Name0 = '\\\\.\\PHYSICALDRIVE0' and
d.Model0 not like '%virtual%' and
s.Operating_System_Name_and0 like 'microsoft windows nt workstation%' and
se.ChassisTypes0 in ('8','9','10','21')

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s