:) From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Sherry Kissinger Sent: Tuesday, April 4, 2017 12:37 PM To: mssms@lists.myitforum.com Subject: Re: [mssms] RE: SQL Query question
I was thinking Henry was just asking a "in general, which sql query s!cks less". the fact that the subselect was using .net in there was just coincidence. On Tue, Apr 4, 2017 at 7:57 AM, Garth Jones <ga...@enhansoft.com<mailto:ga...@enhansoft.com>> wrote: Is there a reason why you are not using the MOF edit for this? I'm in the process of restoring my lab so I can't check this but.... I don't think that OS like Win 10 and Server 16 listed .Net 4.5 in the installed software. This maybe only anniversary edition too. From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> [mailto:listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com>] On Behalf Of henry.wil...@sanofi.com<mailto:henry.wil...@sanofi.com> Sent: Tuesday, April 4, 2017 8:33 AM To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com> Subject: [mssms] RE: SQL Query question Yes Best regards / Cordialement Henry E. WILSON Technical Expert Engineer Information Technology & Solutions Infrastructure Management Automation Services 55 Corporate Drive Bridgewater, NJ 08807 TEL.: +1 908 981 3288<tel:(908)%20981-3288> CELL.: +1 610 724 1169<tel:(610)%20724-1169> FAX: +1 908 635 5858<tel:(908)%20635-5858> System Center Technical Blog<http://wssamer.sanofi.com/ws/AutomationCenterProvTools/SCTechBlog/Lists/Posts/AllPosts.aspx> (for internal use only) SCCM 2012 Dashboard<http://xspw10w201w/Reports/Pages/Report.aspx?ItemPath=%2fUnRestricted+Reports%2fInfrastructure+Health+Status%2fConfigMgr+2012+Dashboard> (for internal use only) Provisioning Tools & Lifecycle Sharepoint Site<http://wssamer.sanofi.com/ws/AutomationCenterProvTools/Documents/Forms/AllItems.aspx> (for internal use only) From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> [mailto:listsad...@lists.myitforum.com] On Behalf Of Garth Jones Sent: Tuesday, April 04, 2017 7:32 AM To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com> Subject: [mssms] RE: SQL Query question Hi Henry, what exactly is the goal? Is it to find all computers without .net 4.5.2? From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> [mailto:listsad...@lists.myitforum.com] On Behalf Of henry.wil...@sanofi.com<mailto:henry.wil...@sanofi.com> Sent: April 4, 2017 6:16 AM To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com> Subject: [mssms] SQL Query question Hello SQL Guru's We're having a discussion with some Admin's in Europe and I would like an opinion on 2 Collection queries looking for the same result: Which one is more efficient? Collection Query #1: 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 not in ( select SMS_R_System.ResourceId from SMS_R_System inner join SMS_G_System_INSTALLED_SOFTWARE on SMS_G_System_INSTALLED_SOFTWARE.ResourceID = SMS_R_System.ResourceId where SMS_G_System_INSTALLED_SOFTWARE.ARPDisplayName in ("Microsoft .NET Framework 4.5.2","Microsoft .NET Framework 4.6.1","Microsoft .NET Framework 4.6","Microsoft .NET Framework 4.6.2") ) ================================================================= Collection Query #2: 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 NOT IN (SELECT sms_r_system.resourceid FROM sms_r_system INNER JOIN sms_g_system_installed_software ON sms_g_system_installed_software.resourceid = sms_r_system.resourceid WHERE sms_g_system_installed_software.arpdisplayname = "microsoft .net framework 4.5.2" or sms_g_system_installed_software.arpdisplayname = "microsoft .net framework 4.6.1" or sms_g_system_installed_software.arpdisplayname = "microsoft .net framework 4.6" or sms_g_system_installed_software.arpdisplayname = "microsoft .net framework 4.6.2" ====================================================================== A DCM has also been mentioned to achieve the same result. Comments or recommendations? Thanks Best regards / Cordialement Henry E. WILSON Technical Expert Engineer Information Technology & Solutions Infrastructure Management Automation Services 55 Corporate Drive Bridgewater, NJ 08807 TEL.: +1 908 981 3288<tel:(908)%20981-3288> CELL.: +1 610 724 1169<tel:(610)%20724-1169> FAX: +1 908 635 5858<tel:(908)%20635-5858> System Center Technical Blog<http://wssamer.sanofi.com/ws/AutomationCenterProvTools/SCTechBlog/Lists/Posts/AllPosts.aspx> (for internal use only) SCCM 2012 Dashboard<https://urldefense.proofpoint.com/v2/url?u=http-3A__xspw10w201w_Reports_Pages_Report.aspx-3FItemPath-3D-252fUnRestricted-26-2343-3BReports-252fInfrastructure-26-2343-3BHealth-26-2343-3BStatus-252fConfigMgr-26-2343-3B2012-26-2343-3BDashboard&d=DQMFAg&c=Dbf9zoswcQ-CRvvI7VX5j3HvibIuT3ZiarcKl5qtMPo&r=rYU1OkDK6KGNCD3HQmVUxzwASyVld-wfgoG00ci6xjA&m=MMFkG-9PwzSKzcY5ZyvS_IAhrJY9YN2NUUSFFLHMgAc&s=YEfQW7Q-RoYf6tErPTwoZiC7byWKjKLfFhVaDQdT2zY&e=> (for internal use only) Provisioning Tools & Lifecycle Sharepoint Site<http://wssamer.sanofi.com/ws/AutomationCenterProvTools/Documents/Forms/AllItems.aspx> (for internal use only) -- Thank you, Sherry Kissinger My Parameters: Standardize. Simplify. Automate Blogs: http://www.mofmaster.com, http://mnscug.org/blogs/sherry-kissinger, http://www.smguru.org