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.
Recent Comments