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.
