Your company's ad could live here and reach over 50,000 people a month!

Share This Post

Query to report OU information for Machines

For full details please see:

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


Share This Post

Leave a Reply