Query to report OU information for Machines

For full details please see:

https://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