sql/cmpivot query

Hi Experts, we are looking to get client OU for all the devices present in a particular collection. Please suggest way to achieve this from SCCM (either cmpivot or SQL query)