Objects with limiting collections

[RobeGrah]

I was wondering if anyone knew of a way to identify which objects have limiting collections set, and what those limiting collections are?

[Eswar Koneti]

you can try this from your SQL:

 

select collectionname,

LimitToCollectionID,LimitToCollectionName,MemberCount

from v_Collections

where LimitToCollectionName not like 'NULL'

[RobeGrah]

Excellent! Thank you very much Eswar. That worked great in 2012, now I need to figure out where those values reside in 2007 so I can compare the two.