Does anyone have any SQL query to find MS14-045 related patch installed details
with server names? I have the below but it works only on SCCM 2007. I need the
same type of query for CM 2012.
SELECT DISTINCT
v_R_System.Name0 AS 'Machine Name',
v_RA_System_SMSAssignedSites.SMS_Assigned_Sites0 AS 'Site Code',
v_GS_PatchStatusEx.ID AS 'Bulletin ID#',
v_GS_PatchStatusEx.QNumbers AS 'KB#', v_GS_PatchStatusEx.Title,
v_GS_PatchStatusEx.LastStateName AS 'Last State',
v_GS_PatchStatusEx.LastStatusMessageIDName AS 'Last Status',
v_GS_PatchStatusEx.LastStatusTime AS 'Last Status Time',
v_FullCollectionMembership.CollectionID
FROM v_GS_PatchStatusEx INNER JOIN
v_R_System ON v_R_System.ResourceID =
v_GS_PatchStatusEx.ResourceID INNER JOIN
v_ClientCollectionMembers ON
v_ClientCollectionMembers.ResourceID = v_R_System.ResourceID INNER JOIN
v_UpdateComplianceStatus ON
v_UpdateComplianceStatus.ResourceID = v_R_System.ResourceID INNER JOIN
v_RA_System_SMSAssignedSites ON v_R_System.ResourceID =
v_RA_System_SMSAssignedSites.ResourceID INNER JOIN
v_FullCollectionMembership ON v_R_System.ResourceID =
v_FullCollectionMembership.ResourceID
WHERE (v_GS_PatchStatusEx.ID <> 'None') AND (v_GS_PatchStatusEx.Title LIKE
'%Security%') AND
(v_GS_PatchStatusEx.LastStateName NOT LIKE 'No Status')
AND (v_GS_PatchStatusEx.ID LIKE 'MS14-045') AND
(v_FullCollectionMembership.CollectionID = 'SMS00001')
ORDER BY 'Machine Name', 'Bulletin ID#' DESC
Thanks in Advance
From: [email protected] [mailto:[email protected]] On
Behalf Of H.T. Vermeer
Sent: Wednesday, August 20, 2014 10:52 PM
To: '[email protected]'
Subject: [mssms] RE: ms14-045
Hi,
Yesterday I have rolled this out (back;-)) via TS , ca. 800 PC's success.
To avoid TS errors I have added WMI query to check if update was installed
already.
Regards,
Hanna
From: [email protected]<mailto:[email protected]>
[mailto:[email protected]] On Behalf Of Taxter, Latisha
Sent: Wednesday, August 20, 2014 7:10 PM
To: [email protected]<mailto:[email protected]>
Subject: [mssms] RE: ms14-045
Thanks. Ours didn't go out to many pcs.
From: [email protected]<mailto:[email protected]>
[mailto:[email protected]] On Behalf Of
[email protected]<mailto:[email protected]>
Sent: Wednesday, August 20, 2014 10:01 AM
To: [email protected]<mailto:[email protected]>
Subject: [mssms] RE: ms14-045
We tested a silent rollback CM package/program and have it ready to go if
needed. Fortunately the patch did not disseminate out far before it was
expired.
c:\windows\sysnative\cmd.exe /c "wusa.exe /uninstall /kb:2982791 /quiet
/norestart"
Regards,
Gregory L. Reilly, CISSP CEH ITILF MCP
Workstation Security Specialist | Workstation Engineering & Operations | Global
Service Operations
Technology | Infrastructure Services | Infrastructure Services for Accenture
This message is for the designated recipient only and may contain privileged,
proprietary, or otherwise private information. If you have received it in
error, please notify the sender immediately and delete the original. Any other
use of the email by you is prohibited.
From: [email protected]<mailto:[email protected]>
[mailto:[email protected]] On Behalf Of Taxter, Latisha
Sent: Tuesday, August 19, 2014 4:37 PM
To: [email protected]<mailto:[email protected]>
Subject: [mssms] ms14-045
How are you guys handling this for pcs that already have this update installed?
Luckily I haven't' pushed this out to all pcs yet.
http://support.microsoft.com/kb/2982791<https://urldefense.proofpoint.com/v1/url?u=http://support.microsoft.com/kb/2982791&k=%2FbkpAUdJWZuiTILCq%2FFnQg%3D%3D%0A&r=29CGw0FLmvm9zusO71hppmbSyI7WC4xlwL9K0rW1DgI%3D%0A&m=CRJAY%2FKxJhQji7fkBPzqeQGrmxuiHLvCj2dKva%2BdPBc%3D%0A&s=364a658a8680436a151d614b4beda2e4ebd2a73ebbc27924ee9e5c7df166502f>
Latisha Taxter
Server Administrator III
Kootenai Health
2003 Kootenai Health Way
Coeur D'Alene, Idaho 83814
* 208-625-4192
[email protected]<mailto:[email protected]>
http://www.kh.org<https://urldefense.proofpoint.com/v1/url?u=http://www.kh.org&k=%2FbkpAUdJWZuiTILCq%2FFnQg%3D%3D%0A&r=29CGw0FLmvm9zusO71hppmbSyI7WC4xlwL9K0rW1DgI%3D%0A&m=CRJAY%2FKxJhQji7fkBPzqeQGrmxuiHLvCj2dKva%2BdPBc%3D%0A&s=6eadd96ffa384d8fb6c7c69160ba756d7c4765c2da431892114973636eaca402>
[cid:[email protected]]
________________________________
This message is for the designated recipient only and may contain privileged,
proprietary, or otherwise confidential information. If you have received it in
error, please notify the sender immediately and delete the original. Any other
use of the e-mail by you is prohibited. Where allowed by local law, electronic
communications with Accenture and its affiliates, including e-mail and instant
messaging (including content), may be scanned by our systems for the purposes
of information security and assessment of internal compliance with Accenture
policy.
______________________________________________________________________________________
www.accenture.com<https://urldefense.proofpoint.com/v1/url?u=http://www.accenture.com&k=%2FbkpAUdJWZuiTILCq%2FFnQg%3D%3D%0A&r=29CGw0FLmvm9zusO71hppmbSyI7WC4xlwL9K0rW1DgI%3D%0A&m=CRJAY%2FKxJhQji7fkBPzqeQGrmxuiHLvCj2dKva%2BdPBc%3D%0A&s=c7926cdd1557d2213fe4eaf2d46578ba99c5174e969d2d3b029fbce6efda3016>
_____________
The information contained in this message is proprietary and/or confidential.
If you are not the intended recipient, please: (i) delete the message and all
copies; (ii) do not disclose, distribute or use the message in any manner; and
(iii) notify the sender immediately. In addition, please be aware that any
message addressed to our domain is subject to archiving and review by persons
other than the intended recipient. Thank you.
