Cs16ProConfigConfig. Mgr SQL queries for helping the IT Pro report on KBs related to MS1. Update 0. 51. 52. Initial post. Update 0. KB2. 91. 93. 55 Queries were updated to address incorrect results. Update 0. 52. 22. Baseline Script updated to determine compliance based on versions of SRV. Update 0. 61. 32. Updated recommendations after June Updates are released. Official Customer Guidance for Wanna. Crypt attacks https blogs. Cs1 6 Pro Config' title='Cs1 6 Pro Config' />General information on ransomware https www. Microsoft Malware Protection Center blog https blogs. MS1. 7 0. 10 Security Update https technet. The simplest and most generally recommended approach is to deploy the latest Cumulative Update to Windows 1. Server 2. 01. 6 systems the latest Monthly Rollup to pre Windows 1. Config. Mgr Compliance reports to determine overall compliance. This blog post originally referenced SQL queries that could be leveraged to determine devices without MS1. SQL queries would need to get updated every month to include newer Article IDs as new updates are released. A better approach to determine compliance is to use a Power. Shell script sample script posted below in a Configuration Baseline to check version of SRV. KB4. 02. 32. 62. The original SQL queries are still posted in the blog for reference, but these queries cannot be used without modification after 0. Sample script provided by Aaron Harris to compare versions of SRV. This script applies to Windows XP and Windows Server 2. CONFIG. SYS is the primary configuration file for the DOS and OS2 operating systems. It is a special ASCII text file that contains useraccessible setup or. It requires Windows Power. Shell 2. 0 or later. Load. With. Partial. NameSystem. Version. This article describes using an RFM01 or RFM12b FSK RF transceiver with a Raspberry Pi to receive sensor data from a Fine Offset WH1080 or WH1081 specifically a. Get Wmi. Object class Win. Operating. System. Name os. Caption. System. Environment Expand. Environment. Variabless. If Test Path v. Info Get Item v. Version. Info. version. String version. Info. File. Major. Part. Info. File. Minor. Part. version. Info. File. Build. Part. Info. File. Private. Part. file. Version New Object System. Versionversion. String. Return state. state null. Return state. if os. Name. ContainsVista or os. Name. Contains2. Name. ContainsR2. OS os. Name GDR. Version New Object System. Version6. 0. 6. OS os. Name LDR. Version New Object System. Version6. 0. 6. OS os. Name. Version New Object System. Version9. 9. 9. Name. ContainsWindows 7 or os. Name. Contains2. R2. OS os. Name LDR. Version New Object System. Version6. 1. 7. Name. ContainsWindows 8. Name. Contains2. R2. OS os. Name LDR. expected. Version New Object System. Version6. 3. 9. Name. ContainsWindows 8 or os. Name. Contains2. OS os. Name LDR. Version New Object System. Version6. 2. 9. Name. ContainsWindows 1. Build. Number eq 1. OS os. Name TH1. Version New Object System. Version1. 0. 0. Build. Number eq 1. OS os. Name TH2. Version New Object System. Version1. 0. 0. Build. Number eq 1. OS os. Name RS1. Version New Object System. Version1. 0. 0. Build. Number eq 1. OS os. Name RS2. No need to Patch. RS2 is released as patched. Patched. return state. Name. Contains2. OS os. Name. Version New Object System. Version1. 0. 0. Name. ContainsWindows XP. OS os. Name. Version New Object System. Version5. 1. 2. Name. ContainsServer 2. OS os. Name. Version New Object System. Version5. 2. 3. OS os. Name. Version New Object System. Version9. 9. 9. If file. Version. Compare. Toexpected. Version lt 0. Not. Patched version. String. state Patched. Sample Configuration Item implementing the script KB2. Confusion KB2. 91. Windows 8. 1 and Server 2. R2 systems. These devices without KB2. MS1. 7 0. 10 as applicable. KB2. 91. 93. 55 was released in April 2. KB2. 91. 94. 42 to be installed for KB2. KB2. 91. 94. 42 was released in March 2. KB3. 17. 34. 24. KB3. KB2. 91. 93. 55 to be installed, introducing a circular dependency and as a result, neither of these updates show as Required on Windows 8. Server 2. 01. 2 R2 clients. Current recommendation for this scenario is to install KB3. KB3. 17. 34. 24 supersedes KB3. KB2. 91. 93. 55 applicable. To identify Windows 8. Server 2. 01. 2 R2 systems that do not report KB2. Installed, following query can be used Any Windows 8. Server 2. 01. 2 R2 machines which do not report KB2. Installed. DECLARE KB2. SRV NVARCHAR5. 0 8. DECLARE KB2. 91. WSx. NVARCHAR5. DECLARE KB2. WSx. 64 NVARCHAR5. Windows Server 2. R2 machines that do not report KB2. Installed. distinct RS. Name. 0. UI. Article. ID as Article. ID. UI. Bulletin. ID as Bulletin. ID. KB2. 91. 93. Title. Update is not Installed AS State. How Old Is Ricky Bell From New Edition. NULL AS Last. State. Received. NULL AS Last. State. Changed. KB2. AS Unique. Update. ID. FROM vUpdateCompliance. Status. Reported UCS. JOIN vUpdate. Info UI ON UCS. CIID UI. CIID. JOIN vRSystem RS ON RS. Resource. Type5 AND RS. Resource. ID UCS. Resource. ID. JOIN vState. Names SN ON SN. Topic. Type5. 00 AND SN. State. ID UCS. Status AND SN. State. ID lt 3. JOIN vGSOPERATINGSYSTEM OS ON RS. Resource. ID OS. Resource. ID AND OS. Build. Number. 0 9. AND OS. Caption. 0 like Server 2. R2 Server 2. R2. WHERE UI. CIUnique. ID KB2. SRV Server 2. R2. Windows 8. KB2. 91. Installed. RS. Name. UI. Article. ID as Article. ID. UI. Bulletin. ID as Bulletin. ID. KB2. 91. 93. Title. Update is not Installed AS State. NULL AS Last. State. Received. NULL AS Last. State. Changed. KB2. AS Unique. Update. ID. FROM vUpdateCompliance. Status. Reported UCS. JOIN vUpdate. Info UI ON UCS. CIID UI. CIID. JOIN vRSystem RS ON RS. Resource. Type5 AND RS. Resource. ID UCS. Resource. ID. JOIN vState. Names SN ON SN. Topic. Type5. 00 AND SN. State. ID UCS. Status AND SN. State. ID lt 3. JOIN vGSOPERATINGSYSTEM OS ON RS. Resource. ID OS. Resource. ID AND OS. Build. Number. 0 9. AND OS. Caption. 0 like Windows 8. Windows 8. 1. JOIN vGSCOMPUTERSYSTEM CS1 ON CS1. Resource. ID RS. Resource. ID AND CS1. System. Type. 0 X8. PC x. WHERE UI. CIUnique. ID KB2. WSx. 86. Windows 8. KB2. 91. 93. 55 as Installed. RS. Name. 0. UI. Article. ID as Article. ID. UI. Bulletin. ID as Bulletin. ID. KB2. 91. 93. Title. Update is not Installed AS State. NULL AS Last. State. Received. NULL AS Last. State. Changed. KB2. AS Unique. Update. ID. FROM vUpdateCompliance. Status. Reported UCS. JOIN vUpdate. Info UI ON UCS. CIID UI. CIID. JOIN vRSystem RS ON RS. Resource. Type5 AND RS. Resource. ID UCS. Resource. ID. JOIN vState. Names SN ON SN. Topic. Type5. 00 AND SN. State. ID UCS. Status AND SN. State. ID lt 3. JOIN vGSOPERATINGSYSTEM OS ON RS. Resource. ID OS. Resource. ID AND OS. Build. Number. 0 9. AND OS. Caption. 0 like Windows 8. Windows 8. 1. JOIN vGSCOMPUTERSYSTEM CS1 ON CS1. Resource. ID RS. Resource. ID AND CS1. System. Type. 0 X6. PC x. WHERE UI. CIUnique. ID KB2. WSx. 64 Installation of KB3. KB3. 17. 34. 24 was revised on 0. KB3. 02. 19. 10 can be deployed via Config. Mgr by customers with Supersedence rule set to Expire after X number of days, provided X is a value that allows Config. Mgr to still synchronize the superseded update KB3. Some customers may need to un decline set the update to Not Approved KB3. WSUS, if this update has been declined manually or by cleanup tasks.