@mangamanga
Fill the dataset uid accordingly
Try using this sql below:
SELECT
ou.uid as orgunituid,
ou.name as orgunitname,
ds.name as datasetname
FROM
dataset ds,
datasetsource dss,
organisationunit ou
WHERE
ds.datasetid = dss.datasetid AND
dss.sourceid = ou.organisationunitid
AND ds.uid = ‘xxxxxxxx’;
Let us know if this helps!
Cheers,
Emma.