Software Deployment Query
Create a dynamic query. The class is called Add Remove Programs and the attribute name is Displayname. http://technet.microsoft.com/en-us/library/bb680674.aspxKent Agerlund | My blogs: http://blog.coretech.dk/author/kea/ and http://scug.dk/ | Twitter @Agerlund | Linkedin: /kentagerlund
February 26th, 2011 5:21am

Background - Have a new SCCM server in place. I have 100 machines which have been OSD'd with client and 100 machines waiting to be OSD'd. I have one collection which displays all my machines. All machines will have all the same software on. A new piece of software has arrived and needs installed on all 200 machines. Now I want to put this in the image and recapture the image ready for deployment to new machines. However for the existing 100 machines already deployed I will need to create an advertisament for the software (no problem I can do that) The query is what will happen to new machines that have the software on (because its in the WIM) and are part of the collection where the new osftware is Advertised?
Free Windows Admin Tool Kit Click here and download it now
February 26th, 2011 6:24am

Hi Andrew, If you add the software in the Task Sequence then it wont be installed again even if you advertise it to a collection where the computer is a member. If you add the software directly to the reference image then it will be installed again unless you create a collection based on inventory data. A query like this will list all clients without a specific SW installed: Select distinct SMS_R_System.Name from SMS_R_System where SMS_R_System.Name not in (select distinct SMS_R_System.Name 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 = "Microsoft .NET Framework 3.5 SP1") Kent Agerlund | My blogs: http://blog.coretech.dk/author/kea/ and http://scug.dk/ | Twitter @Agerlund | Linkedin: /kentagerlund
February 26th, 2011 7:02am

Thanks Kent. May just add it to the TS - saves having to create the image again and having to create a separate collection. If I were to do a new collection where would I find the DisplayName of the software? Add/Remove Programs?
Free Windows Admin Tool Kit Click here and download it now
February 26th, 2011 7:04am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics