SELECT s.Name0 FROM v_R_System s WHERE s.ResourceID NOT IN (SELECT ResourceID FROM v_GS_QUICK_FIX_ENGINEERING WHERE HotFixID0 LIKE '%3112343%')
Try this From: [email protected] [mailto:[email protected]] On Behalf Of David McSpadden Sent: Friday, January 22, 2016 10:21 AM To: Patch Management Mailing List ([email protected]) <[email protected]>; [email protected] Subject: [mssms] Finding all machines that do not have. I am running this sql query to find all machines that have 3112343 SELECT n.[DNSHostName0],n.IPAddress0, q.[HotFixID0],q.Description0,q.InstalledOn0 FROM [CM_SC1].[SCCM_Ext].[vex_GS_QUICK_FIX_ENGINEERING] q, [CM_SC1].SCCM_Ext.vex_GS_NETWORK_ADAPTER_CONFIGURATION n where q.ResourceID=n.ResourceID and q.HotFixID0 like '%3112343%' and n.IPAddress0 != '' order by n.IPAddress0 I would like to know which machines do not have the patch. Is there a better query in SQL or a report in SCCM 2012 R2? David McSpadden System Administrator Indiana Members Credit Union P: 317.554.8190 [Description: Description: imcu email icon]<http://imcu.com/> [Description: Description: facebook email icon] <https://www.facebook.com/IndianaMembersCU> [Description: Description: twitter email icon] <https://twitter.com/IndMembersCU> [Description: Description: email logo] [http://www.amuletsolutions.com/images/mcp.gif]<http://www.google.com/url?sa=i&rct=j&q=&esrc=s&source=images&cd=&cad=rja&uact=8&ved=0ahUKEwjFztf-tePJAhXK5iYKHcPtAxEQjRwIBw&url=http://www.amuletsolutions.com/awards.aspx&bvm=bv.110151844,d.amc&psig=AFQjCNHkrx8CednTEOOq4zUxYyrRUGzUsg&ust=1450459757284499> This e-mail and any files transmitted with it are property of Indiana Members Credit Union, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing, or copying of this email is strictly prohibited. Please consider the environment before printing this email. ******************************************************************************************** Note: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. ********************************************************************************************
