sccmug

Select Distinct     sys.Netbios_Name0,     fcm.SiteCode,      sys.User_Domain0,     sys.User_Name0,     sys.Operating_System_Name_and0,     arp.DisplayName0,     Col.Name FROM     dbo.v_R_System sys     JOIN dbo.v_Add_Remove_Programs arp ON sys.ResourceID = arp.ResourceID     JOIN dbo.v_FullCollectionMembership fcm on sys.ResourceID=fcm.ResourceID     join dbo.v_Collection Col on Col.CollectionId = fcm.CollectionID WHERE     DisplayName0 = @displayname and     fcm.CollectionID=@CollID

select     NAC.DNSHostName0,     count(NAC.ResourceID) from     dbo.v_GS_NETWORK_ADAPTER_CONFIGUR NAC Where     IPAddress0 is NOT NULL Group by     NAC.ResourceID,     NAC.DNSHostName0 Having     count(NAC.ResourceID)>1 Order by     NAC.DNSHostName0