Even Nerdier, Found a better way to query the above result (NOTE: in v11sp5 on up, this completely unnecessary, specially if you set up Media Agent Clusters).
in the below instance it uses commserv vs cvcloud, if you use cvcloud that only updates well the cloud gathering scheduler ran, for us it was like 2 to 3 times a day.
Also, I only return back the LOWEST gdsp with associations, i.e. if I had several global dedup policies, this query will return only the one with the lowest amount off associations.
select top 1 c.name as GDSP_name, b.id, a.SIDBStoreId, COUNT(*) as occurance
from archCopySIDBStore a
join archGroupCopy b
on a.SIDBStoreId =b.SIDBStoreId
join archGroup c
on b.archGroupId = c.id
where c.name like '%NAME_OF_YOUR_GLOBAL_DEDUPPOLICY%'
group by a.SIDBStoreId, b.id, c.name
order by occurance asc
) as z