what OU’s the systems are in?

Use this SQL query to find all WS within an OU.

 

SELECT

v_RA_System_SystemOUName.System_OU_Name0,

v_R_System.Name0

FROM

v_R_System v_R_System,

v_RA_System_SystemOUName v_RA_System_SystemOUName

WHERE v_R_System.ResourceID = v_RA_System_SystemOUName.ResourceID

ORDER BY v_RA_System_SystemOUName.System_OU_Name0

 

 

and to populate views needed for this query you need to enable AD System
Group Discovery in addition to AD System Discovery.

Leave a Reply

Your email address will not be published. Required fields are marked *