SQL Query to get all System discovery containers OU

[lalajee]

Hi,

 

I need an sql query to get OU list for every primary site within CAS

I have following piwershell script but need sql query to do same

 

cls

$listAdContainers = (get-cmdiscoveryMethod -name ActiveDirectorySystemDiscovery -sitecode xxx).proplists | where-Object {$_.PropertyListName -eq "AD Containers"} 

($listAdContainers.values -like 'ldap*')

[GarthMJ]

everything that you need is listed within the online docs. SQL Server views - Configuration Manager | Microsoft Docs