RE: [mssms] Query for x86 and x64 software that is 'not' installed

2014-02-05 Thread Dzikowski, Michael
uesday, February 04, 2014 05:22 PM Central Standard Time To: 'mssms@lists.myitforum.com' Subject: RE: [mssms] Query for x86 and x64 software that is 'not' installed Yeah I need to deploy a package (not an app) within CM 2012 R2 to clients that don’t have it installed thus the request

RE: [mssms] Query for x86 and x64 software that is 'not' installed

2014-02-04 Thread Daniel Ratliff
y 04, 2014 07:23 PM Eastern Standard Time To: 'mssms@lists.myitforum.com' Subject: RE: [mssms] Query for x86 and x64 software that is 'not' installed Ok I have managed to resolve this by first creating collections for all x86 and x64 based systems, Them creating a collecti

RE: [mssms] Query for x86 and x64 software that is 'not' installed

2014-02-04 Thread Johns, Damon (DoJ)
7;; 'mssms@lists.myitforum.com' Subject: RE: [mssms] Query for x86 and x64 software that is 'not' installed Yeah just duplicate your first where. ...where resourceid not in (query for x86) and resourceid not in (query for x64) -Daniel Ratliff -Original Message- From:

RE: [mssms] Query for x86 and x64 software that is 'not' installed

2014-02-04 Thread Daniel Ratliff
014 06:23 PM Eastern Standard Time To: 'mssms@lists.myitforum.com' Subject: RE: [mssms] Query for x86 and x64 software that is 'not' installed Yeah I need to deploy a package (not an app) within CM 2012 R2 to clients that don’t have it installed thus the request for a

RE: [mssms] Query for x86 and x64 software that is 'not' installed

2014-02-04 Thread Johns, Damon (DoJ)
le and the SMS_G_SYSTEM_ADD_REMOVE_PROGRAMS_64 table ? From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Dzikowski, Michael Sent: Wednesday, 5 February 2014 10:07 AM To: 'mssms@lists.myitforum.com'; 'mssms@lists.myitforum.com' Subject: RE: [mssms] Query fo

RE: [mssms] Query for x86 and x64 software that is 'not' installed

2014-02-04 Thread Dzikowski, Michael
I know you asked for a query, but what about using the application deployment simulation (assuming you're on CM12)? http://technet.microsoft.com/en-us/library/hh508773.aspx Sent with Good (www.good.com) -Original Message- From: Johns, Damon (DoJ) [damon.jo...@justice.tas.gov.au

RE: [mssms] Query for x86 and x64 software that is 'not' installed

2014-02-04 Thread Daniel Ratliff
Look into subselect queries. You can't do a 'not installed'. You have too say any machines not in this query, this query being the one with the software installed. -Daniel Ratliff -Original Message- From: Johns, Damon (DoJ) [damon.jo...@justice.tas.gov.au