A bit of code from MyITForum.com with a report that lists all collections for a specific machine.
http://www.myitforum.com/forums/All_Collections_for_a_specific_computer/m_163312/tm.htm
select FCM.SiteCode as 'SMS Site', FCM.CollectionID, COL.Name as 'Collection' from v_R_System SYS join v_FullCollectionMembership FCM on FCM.ResourceID = SYS.ResourceID join v_Collection COL on COL.CollectionID = FCM.CollectionID where SYS.Name0 = @Computer
Prompt Query:
begin if (@__filterwildcard = '') SELECT DISTINCT SYS.Netbios_Name0 from v_R_System SYS WHERE SYS.Client0=1 ORDER By SYS.Netbios_Name0 else SELECT DISTINCT SYS.Netbios_Name0 from v_R_System SYS WHERE SYS.Client0=1 and SYS.Netbios_Name0 like @__filterwildcard ORDER By SYS.Netbios_Name0 end