maffef Posted February 12, 2011 Report post Posted February 12, 2011 Hi I have a Software Collection where I manually adding Computers if they need an specific Software. Time to Time the Collection contains more than 30 or 30 Computers. Removing manually takes so much time. Is there a tool which removes by a button the computers from the specific collection or do you have any other suggestions? Thanks in advance. Quote Share this post Link to post Share on other sites More sharing options...
0 Peter van der Woude Posted February 12, 2011 Report post Posted February 12, 2011 Just create a Query-Based collection, which checks wether or not the software is already installed. Quote Share this post Link to post Share on other sites More sharing options...
0 maffef Posted February 13, 2011 Report post Posted February 13, 2011 Just create a Query-Based collection, which checks wether or not the software is already installed. Hi Peter Thank you very much. Can you give me an example how the query should look like? Thx maffef P.S: Your blog is really good!! Quote Share this post Link to post Share on other sites More sharing options...
0 Peter van der Woude Posted February 13, 2011 Report post Posted February 13, 2011 This is an example of all machines that have Office installed (Keep in mind that this is a query based on information from ADD/REMOVE PROGRAMS. To get this information you need to run Hardware Inventories): 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 where SMS_R_System.ResourceId in (select SMS_R_System.ResourceId from SMS_R_System 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 "Microsoft Office Professional%") and SMS_R_System.Client = 1 Quote Share this post Link to post Share on other sites More sharing options...
0 Eswar Koneti Posted February 14, 2011 Report post Posted February 14, 2011 You can also do this Via AD SEC groups (removing applications atomatically) : http://www.windows-noob.com/forums/index.php?/topic/677-automatic-removal-of-applications/ How to deploy applications Automatically Via AD sec Groups : http://www.windows-noob.com/forums/index.php?/topic/892-deploy-software-through-ad-groups-linked-to-collections-in-sccm/ Quote Share this post Link to post Share on other sites More sharing options...
0 maffef Posted February 16, 2011 Report post Posted February 16, 2011 This is an example of all machines that have Office installed (Keep in mind that this is a query based on information from ADD/REMOVE PROGRAMS. To get this information you need to run Hardware Inventories): 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 where SMS_R_System.ResourceId in (select SMS_R_System.ResourceId from SMS_R_System 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 "Microsoft Office Professional%") and SMS_R_System.Client = 1 Hi Peter how should the query look like if whether or not the software is installed? Query above shows only specific software installed Quote Share this post Link to post Share on other sites More sharing options...
0 Peter van der Woude Posted February 16, 2011 Report post Posted February 16, 2011 Hi Peter how should the query look like if whether or not the software is installed? Query above shows only specific software installed That sounds like All Systems. Quote Share this post Link to post Share on other sites More sharing options...
Hi
I have a Software Collection where I manually adding Computers if they need an specific Software.
Time to Time the Collection contains more than 30 or 30 Computers. Removing manually takes so much time.
Is there a tool which removes by a button the computers from the specific collection or do you have any other suggestions?
Thanks in advance.
Share this post
Link to post
Share on other sites