OWSUG.ca

For full details please see:

http://www.myitforum.com/forums/query-to-report-OU-information-for-Machines-m235317.aspx

select 
  R.Name0,
  max(OU.System_OU_Name0)
From
  dbo.v_R_System R
  join dbo.v_RA_System_SystemOUName OU on OU.ResourceID = R.ResourceID
  join dbo.v_FullCollectionMembership FCM on FCM.ResourceID = R.ResourceID
Where 
  FCM.CollectionID = 'SMS00001'
group by
  R.Name0