Is there a way to compare 2 collections. A query or report? Thanks daveDkozlowski@kai.com

What do you want to compare? The resources listed in the collection, inventory data, software installed?Kent Agerlund | http://scug.dk/ | The Danish community for System Center products

You want to compare objects ? like Computers ? Regards

Example I have a collection of computers runnning symantec. I remove symantec and I want to compare the systems without symanctec against the original collection or the all systems collection Thanks DaveDkozlowski@kaig.com

Hi , try below, ------------------------------------------------------ select SYS.NetBIOS_Name0 From v_R_System SYS INNER JOIN v_FullCollectionMembership FCM ON SYS.ResourceID = FCM.ResourceID Where SYS.ResourceID not in (select v_R_SYSTEM.ResourceID from v_R_System INNER JOIN v_FullCollectionMembership FCM ON v_R_System.ResourceID = FCM.ResourceID where FCM.CollectionID = 'CP0010E7' <Collection ID 1> ) and FCM.CollectionID = 'CP0010DE' <Collection ID 2> --------------------------------------------------------------

I think,you are looking for a collection which pulls all the computers from the given(selected) collection which doesnt have symantec software ? am i correct Here is the guide how you can create collection on this http://www.windows-noob.com/forums/index.php?/topic/768-collection-all-computers-that-dont-have-a-specific-application-installed/ another query collection which gives you all the computers which doesnt have specific application installed select SMS_G_System_SYSTEM.Name from SMS_R_System inner join SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SYSTEM.Name not in (select SMS_G_System_SYSTEM.Name from SMS_R_System inner join SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like “Adobe acrobat reader“) Dont forget to change name of application.//Eswar Koneti @ http://eskonr.wordpress.com/

what I want to do is compare the 2 collections. One has 486 sytems in it and the other only 224 system. I want to see the difference. whats missing. Thanks Dave Dkozlowski@kaig.com

Try the following query: Collection1 with 486 systems and Collection2 with 224. This query lists the systems that are in collection1, but not in Collection2. In the following query replace XYZ00001 with the collection ID of Collection2 and replace SMS00001 with collection ID of Collection1. select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceId = SMS_R_System.ResourceId where SMS_R_System.ResourceId not in (select sys.resourceid from sms_cm_res_coll_XYZ00001 AS coll, sms_r_system as sys where sys.resourceid = coll.resourceid) and SMS_G_System_SYSTEM.ResourceID in (select sys.resourceid from sms_cm_res_coll_SMS00001 AS coll, sms_r_system as sys where sys.resourceid = coll.resourceid) You can modify this query as per your requerement. http://www.madanmohan.com/2010/10/creating-dynamic-collection-by.htmlRegards, Madan

Fantastic thanks Dkozlowski@kaig.com