#configmgr 2012

[techdirectarchive]

How to install Endpoint Configuration Manager on HyperV VM

Microsoft integrates Configuration Manager into the Intune family of products, offering an integrated solution for managing all devices. This integration simplifies licensing and eliminates the need for complex migrations. Users can continue leveraging their existing Configuration Manager investments while tapping into the capabilities of the Microsoft cloud at their own pace. This is a…

[ajguides]

Cisco VPN Client Silent Installation for SCCM 2007 & 2012 Distribution

Cisco VPN Client Silent Installation for SCCM 2007 & 2012 Distribution | https://tinyurl.com/28r5tvxx | #Cisco #Guide #MSI #VPN #Windows Once you have downloaded and extracted your exe file for Cisco VPN Client, you will notice that there is a MSI file in there, this means that we can use this in SCCM 2007 as a package, or as a catalog item in ConfigMgr 2012. Just package up all the extracted files and use the below MSI install script to run the installation without a restart. You can now distribute and deploy this package without fear of it automatically restarting your clients machine! Read more... https://tinyurl.com/28r5tvxx

[megasoft012]

Download SCCM ConfigMgr and Intune slide decks and videos from Ignite 2019

Download SCCM ConfigMgr and Intune slide decks and videos from Ignite 2019

Microsoft Ignite is an event to learn innovative ways to build solutions and migrate and manage your infrastructure. You connect with over 25,000 individuals focused on software development, security, architecture, and IT. Explore new hands-on experiences that will help you innovate in areas such as security, cloud, and hybrid infrastructure and development.

For those of you, who would like to…

[les2t]

SCCM – Le certificat pour Asset Intelligent expire le 10 Mars

SCCM – Le certificat pour Asset Intelligent expire le 10 Mars

Le certificat d’authentification servant à la fonctionnalité Asset Intelligent expire le 10 mars 2017. Si vous possédez une version 2007, 2012, 1511,1602 ou 1606, il va vous falloir le mettre à jour.

(more…)

[johnlmangum84]

Stealing with Pride, Vol. 1: Advanced OSD Customizations for MDT 2013 and ConfigMgr 2012 R2

Product Description This is the ultimate source for the working IT Pro who wants to develop and customize deployment solutions based on MDT 2013 and/or ConfigMgr 2012 R2. This is a HOW TO GET IT DONE book, solely focused on customizing deployment solutions with roots in the real world. In addition to well-proven step-by-step guides, you also get access to sample scripts and source code, allowing you to quickly test the solutions in your own environment. As far as the title goes, we don’t mean you should steal things, literally. In this book, stealing is a metaphor for not reinventing the wheel. We don’t want you to waste time developing solutions that are already available for free. Discover how to Setup MDT 2013 Lite Touch for OSD - Setup ConfigMgr 2012 R2 for OSD - Work with drivers in MDT 2013 and ConfigMgr 2012 R2 - Customize MDT 2013 Lite Touch and ConfigMgr 2012 R2 OSD - Select the right development tools for OSD customizations - Use version control for your scripts and source code - Advanced customization of the MDT 2013 Lite Touch wizard - Master the rules (CustomSettings.ini) - Create UserExit scripts - Configure user-driven installation (UDI) - Create and extend the MDT database - Use a custom frontend for the MDT database - Create and debug custom scripts and frontends - Create web services in both VB.NET and C# - Extend the MDT Monitoring feature - Setup and configure Orchestrator 2012 R2 - Integrate MDT 2013 and ConfigMgr 2012 R2 with Orchestrator 2012 R2

The post Stealing with Pride, Vol. 1: Advanced OSD Customizations for MDT 2013 and ConfigMgr 2012 R2 appeared first on Top Seller Website.

from Top Seller Website https://topsellers.website/stealing-with-pride-vol-1-advanced-osd-customizations-for-mdt-2013-and-configmgr-2012-r2/ from Top Sellers https://topsellerswebsite.tumblr.com/post/175247425683

[htmdcommunity]

Learn How to Configure ConfigMgr Preferred MP | SCCM

[New Post By Kannan] Learn How to Configure #ConfigMgr Preferred Management Point | #SCCM

In this post, let’s learn How to Configure ConfigMgr Preferred MP. You can learn more about Preferred Management Points selection Criteria from the client perspective.

Introduction – Configure ConfigMgr Preferred MP

Microsoft official released Preferred Management points in SCCM 2012 R2 SP1 or SCCM 2012 SP2 version.

Official description from Technet: Preferred management points enable a…

[sanmansp]

Tweeted

ConfigMgr : Query to find SCCM client versions (ConfigMgr 2012) https://t.co/HirRnRoMp5

— sanmansp (@sanmansp) January 23, 2019

[gfisoftwareuz-blog]

Новый сборник подсказок системного администратора

Наш сборник подсказок системного администратора стал настоящим хитом среди читателей. Мы предлагаем новый сборник подсказок, быстрых ссылок и справочников. На этот раз мы включили некоторых запросы читателей, в том числе, справочники для System Center Configuration Manager (SCCM). Что касается других тем, их количество увеличилось в разы. Узнайте, какие новые закладки вы можете добавить к вашему браузеру.

System Center Configuration Manager (SCCM)

Некоторые подсказки для SCCM/ConfigMgr (Менеджера ��правления) и связанных продуктов. Этот продукт недостаточно хорошо описан в сети, так что если вы отлично в нем разбираетесь — заводите блог и делитесь опытом! Благодарная аудитория вам обеспечена. коды ошибок http://windowsandsms2003.blogspot.com/2012/05/cheat-sheet-for-sccm-software-updates.html WMI (Интерфейс управления окнами) в PowerShell 3.0 http://blogs.msdn.com/b/powershell/archive/2012/10/28/wmi-cheat-sheet-for-ps-users.aspx SC VMM 2012: PowerShell http://blogs.technet.com/b/jonjor/archive/2012/04/04/sc-vmm-2012-powershell-cheat-sheet.aspx SCCM 2012: распределение ролей http://technet.microsoft.com/en-us/library/64aa34e1-c465-4eb8-820b-5c1702ab55ae#Plan_Where_to_Install_Sites Системный центр 2012: самоучитель http://social.technet.microsoft.com/wiki/contents/articles/12726.system-center-2012-self-study-guide-complete-edition.aspx

Разработка веб-приложений

Это пригодится для тех из вас, кто работает с веб-приложениями. Прежде чем отправлять на печать, убедитесь, что в принтере достаточно чернил, — информации много! WordPress http://www.cheat-sheets.org/saved-copy/wpcs.png Карманные справочники HTML 5 http://adactio.com/extras/pocketbooks/html5/ Безопасность HTML 5 http://html5sec.org/ Поддержка HTML 5 браузерами http://www.inmotionhosting.com/img/infographics/html5_cheat_sheet_browser_support.png Тэги HTML 5 http://www.inmotionhosting.com/img/infographics/html5_cheat_sheet_tags.png Обработчик событий HTML 5 http://www.inmotionhosting.com/img/infographics/html5_cheat_sheet_event_attributes.png Быстрый гайд по HTML 5 http://www.smashingmagazine.com/wp-content/uploads/images/html5-cheat-sheet/html5-cheat-sheet.pdf

Сеть

tcpdump http://packetlife.net/media/library/12/tcpdump.pdf nmap http://www.cheat-sheets.org/saved-copy/Nmap5.cheatsheet.eng.v1.pdf netcat http://www.sans.org/security-resources/sec560/netcat_cheat_sheet_v1.pdf Быстрый гайд по подсетям http://quest4.org/ccna/subnet_cheat_sheet.htm Подсказки по маске подсетей http://www.aelius.com/njh/subnet_sheet.html

Базы данных

Если базы данных — ваша специализация, следующие подсказки будут очень полезными! Они помогли мне окончательно разобраться в SQL. MySQL http://csnipp.com/s/510/-MySQL-Cheat-Sheet SQL на одной странице http://www.sql.su/ Быстрый гайд по SQL http://cse.unl.edu/~sscott/ShowFiles/SQL/CheatSheet/SQLCheatSheet.html Синтаксическое дерево для SQLite http://www.cheat-sheets.org/own/sqlite/Syntax.Diagrams.For.SQLite.html Карта ссылок Oracle SQL http://www.cheat-sheets.org/saved-copy/oracle_sql_reference.pdf Подсказки для PostgreSQL http://www.cheat-sheets.org/saved-copy/postgresql-cheat-sheet.pdf

Linux/Unix

Выпытать информацию у системных администраторов Linux бывает непросто. К счастью, вы найдете здесь множество подсказок Linux. Их стало значительно больше. Безопасность Linux http://www.digilife.be/quickreferences/QRC/Linux%20Security%20Quick%20Reference%20Guide.pdf Администрирование Linux http://www.digilife.be/quickreferences/QRC/LINUX%20Admin%20Quick%20Reference.pdf Набор инструментов Unix http://cb.vu/unixtoolbox.xhtml Учебник и подсказки по графическим визуальным редакторам http://www.viemu.com/a_vi_vim_graphical_cheat_sheet_tutorial.html Регулярные выражения http://www.addedbytes.com/cheat-sheets/download/regular-expressions-cheat-sheet-v2.pdf Bash History http://www.catonmat.net/download/bash-history-cheat-sheet.pdf Консоль Linux http://www.pixelbeat.org/cmdline.html Ubuntu http://www.cheat-sheets.org/saved-copy/ubunturef.pdf Unix/Linux Shell http://www.cheat-sheets.org/saved-copy/shellscripcheatsheet.pdf Надеемся, что вам понравилась третий выпуск нашего сборника подсказок. Будем рады рассмотреть все ваши предложения и замечания. Понравился этот пост? Поделитесь с коллегами с помощью кнопок, расположенных справа. Источник: GFI Read the full article

[enterinit]

SCCM SQL queries for KBs related to WannaCrypt

SCCM SQL queries for KBs related to WannaCrypt. The following is shared by CSS Support Escalation Engineer Vinay Pamnani, to help give the IT Pro some sample queries that may assist them in their security update compliance reporting as it relates to WannaCrypt. It is provided as a sample and NOT to be taken as a definitive compliance posture information source. As with all Software Update compliance information, the queries below rely on current and accurate scan result information in the ConfigMgr database. The sample queries below have had limited testing against ConfigMgr version 1702 and SQL Server 2016. The simplest and most generally recommended approach is to deploy the latest CU to Windows 10 or Server 2016 systems, and to deploy the latest Monthly Rollup to pre-Windows 10 machines, and use the built-in ConfigMgr Compliance reports to determine overall compliance. Official Customer Guidance for WannaCrypt attacks: https://blogs.technet.microsoft.com/msrc/2017/05/12/customer-guidance-for-wannacrypt-attacks/ General information on ransomware: https://www.microsoft.com/en-us/security/portal/mmpc/shared/ransomware.aspx Microsoft Malware Protection Center blog: https://blogs.technet.microsoft.com/mmpc/2017/05/12/wannacrypt-ransomware-worm-targets-out-of-date-systems/ MS17-010 Security Update: https://technet.microsoft.com/en-us/library/security/ms17-010.aspx However, the following queries can also enable admins to report on MS17-010 compliance. What do these queries do? Pre-Windows 10 machines: Windows 8.1 and Server 2012 R2 machines that do not report KB2919355 as installed will be returned by the query. This is because KB2919355 is required for the later KBs to be reported as applicable. So, these systems can be considered at risk and require further investigation. For Windows Vista, Windows 7, Windows 8.1, Windows Server 2008 R2 SP1, Windows Server 2008 SP2, Windows Server 2012, and Windows Server 2012 R2 query below, the systems returned will be those that do not have either the March, April, or May monthly rollups installed -AND- are reporting the following specific ‘Security Only’ updates as ‘Required’: Windows Vista and Server 2008 SP2: KB4012598 Windows 7 and Server 2008 R2 SP1: KB4012212 Windows Server 2012: KB4012214 Windows Server 2012 R2 and Windows 8.1: KB4012213 -- For Windows 7, Server 2008 R2 SP1, Windows Server 2012, Server 2012 R2 and Windows 8.1, Windows Vista and Server 2008 SP2 -- This query lists machines that are reporting any of the 'Security Only' updates as 'Required'. -- If any machine has either March, April or May Monthly Rollup installed, then they wouldn't report March 'Security Only' update as 'Required', but look for the Monthly updates anyway. -- Also include any Windows 8.1 and Server 2012 R2 machines which do not report ‘KB2919355’ as Installed. DECLARE @MarchSecurityOnly TABLE (ArticleID NVARCHAR(20)) INSERT INTO @MarchSecurityOnly VALUES ('4012212') INSERT INTO @MarchSecurityOnly VALUES ('4012213') INSERT INTO @MarchSecurityOnly VALUES ('4012214') INSERT INTO @MarchSecurityOnly VALUES ('4012598') DECLARE @MarchMonthly TABLE (ArticleID NVARCHAR(20)) INSERT INTO @MarchMonthly VALUES ('4012215') INSERT INTO @MarchMonthly VALUES ('4015549') INSERT INTO @MarchMonthly VALUES ('4019264') INSERT INTO @MarchMonthly VALUES ('4012216') INSERT INTO @MarchMonthly VALUES ('4015550') INSERT INTO @MarchMonthly VALUES ('4019215') INSERT INTO @MarchMonthly VALUES ('4012217') INSERT INTO @MarchMonthly VALUES ('4015551') INSERT INTO @MarchMonthly VALUES ('4019216') DECLARE @KB2919355 NVARCHAR(10) = '2919355'-- Pre-req SELECT        RS.Name0,        UI.ArticleID as ArticleID,        UI.BulletinID as BulletinID,        UI.Title as Title,        SN.StateDescription AS State,        UCS.LastStatusCheckTime AS LastStateReceived,        UCS.LastStatusChangeTime AS LastStateChanged,        UI.CI_UniqueID AS UniqueUpdateID FROM v_Update_ComplianceStatusReported UCS JOIN v_UpdateInfo UI ON UCS.CI_ID = UI.CI_ID JOIN v_R_System RS ON RS.ResourceType=5 AND RS.ResourceID = UCS.ResourceID JOIN v_StateNames SN ON SN.TopicType=500 AND SN.StateID=2 AND SN.StateID = UCS.Status WHERE UI.ArticleID IN (SELECT ArticleID FROM @MarchSecurityOnly) AND RS.Name0 NOT IN (        -- Monthly is installed        SELECT distinct RS.Name0        FROM v_Update_ComplianceStatusReported UCS        JOIN v_UpdateInfo UI ON UCS.CI_ID = UI.CI_ID        JOIN v_R_System RS ON RS.ResourceType=5 AND RS.ResourceID = UCS.ResourceID        JOIN v_StateNames SN ON SN.TopicType=500 AND SN.StateID=3 AND SN.StateID = UCS.Status        WHERE UI.ArticleID IN (SELECT ArticleID FROM @MarchMonthly) ) UNION -- Windows 8.1 and Server 2012 R2 machines that do not report KB2919355 as Installed. SELECT        distinct RS.Name0,        UI.ArticleID as ArticleID,        UI.BulletinID as BulletinID,        'KB2919355' as Title,             'Update is not Installed' AS State,        NULL AS LastStateReceived,        NULL AS LastStateChanged,        'KB2919355' AS UniqueUpdateID FROM v_Update_ComplianceStatusReported UCS JOIN v_UpdateInfo UI ON UCS.CI_ID = UI.CI_ID JOIN v_R_System RS ON RS.ResourceType=5 AND RS.ResourceID = UCS.ResourceID JOIN v_StateNames SN ON SN.TopicType=500 AND SN.StateID = UCS.Status AND SN.StateID 3 JOIN v_GS_OPERATING_SYSTEM OS ON RS.ResourceID = OS.ResourceID AND OS.BuildNumber0 = '9600' -- Windows 8.1 and Server 2012 R2 WHERE UI.ArticleID = @KB2919355 Windows 10 and Server 2016 For the Windows 10 and Server 2016 queries, there are 2 scenarios that may apply depending on an environment’s configuration on the expiry of superseded updates in ConfigMgr. For more information on this, see the Supersedence rules section on TechNet and this. Scenario 1: Customers with Supersedence rule NOT set to ‘Immediately expire’: If the superseded updates are not expired and therefore still available in ConfigMgr, you can use the following query to help identify Windows 10 and Windows Server 2016 systems that do not have the March CU or a subsequent CU installed. Please note that for the March CU data to be evaluated, the months to wait before an update is expired value in ConfigMgr must be set to a high enough value such that the March update was not expired. The same consideration applies to the subsequent updates. If this does not apply to your environment, the information in Scenario 2: Customers with Supersedence rule set to ‘Immediately expire’ (or not long enough) can be tried. For the following Windows 10 and Server 2016, the query below returns systems that do not have any of the following monthly CUs, released in March or later (through the date of this post), installed: Win10  RTM: KB4012606, KB4019474, KB4015221, KB4016637 Win10 1511: KB4013198, KB4015219, KB4016636, KB4019473 Win10 1607/Server 2016: KB4013429, KB4015217, KB4015438, KB4016635, KB4019472 -- Windows 10 machines that do not have the March (or any of the superseding updates) installed, and could be 'at risk'. -- These queries are OS dependent, since we are querying individual KB's, and need to compare those KB's against proper builds to prevent getting inaccurate results. -- Windows 10 RTM DECLARE @BuildNumberRTM INT = '10240' DECLARE @MarchWin10 TABLE (ArticleID NVARCHAR(20)) INSERT INTO @MarchWin10 VALUES ('4012606') -- March Cumulative INSERT INTO @MarchWin10 VALUES ('4019474') INSERT INTO @MarchWin10 VALUES ('4015221') INSERT INTO @MarchWin10 VALUES ('4016637') SELECT RS.Name0, OS.BuildNumber0 FROM v_R_System RS JOIN v_GS_OPERATING_SYSTEM OS ON RS.ResourceID = OS.ResourceID AND OS.BuildNumber0 = @BuildNumberRTM WHERE RS.Name0 NOT IN (        SELECT RS.Name0        FROM v_Update_ComplianceStatusReported UCS        JOIN v_UpdateInfo UI ON UCS.CI_ID = UI.CI_ID        JOIN v_R_System RS ON RS.ResourceType=5 AND RS.ResourceID = UCS.ResourceID        JOIN v_StateNames SN ON SN.TopicType=500 AND SN.StateID=3 AND SN.StateID = UCS.Status        JOIN v_GS_OPERATING_SYSTEM OS ON OS.ResourceID = RS.ResourceID AND OS.BuildNumber0 = @BuildNumberRTM        WHERE UI.ArticleID IN (SELECT ArticleID FROM @MarchWin10) ) -- Windows 10 1511 DECLARE @BuildNumber1511 INT = '10586' DECLARE @MarchWin101511 TABLE (ArticleID NVARCHAR(20)) INSERT INTO @MarchWin101511 VALUES ('4013198') -- March Cumulative INSERT INTO @MarchWin101511 VALUES ('4015219') INSERT INTO @MarchWin101511 VALUES ('4016636') INSERT INTO @MarchWin101511 VALUES ('4019473') SELECT RS.Name0, OS.BuildNumber0 FROM v_R_System RS JOIN v_GS_OPERATING_SYSTEM OS ON RS.ResourceID = OS.ResourceID AND OS.BuildNumber0 = @BuildNumber1511 WHERE RS.Name0 NOT IN (        SELECT RS.Name0        FROM v_Update_ComplianceStatusReported UCS        JOIN v_UpdateInfo UI ON UCS.CI_ID = UI.CI_ID        JOIN v_R_System RS ON RS.ResourceType=5 AND RS.ResourceID = UCS.ResourceID        JOIN v_StateNames SN ON SN.TopicType=500 AND SN.StateID=3 AND SN.StateID = UCS.Status        JOIN v_GS_OPERATING_SYSTEM OS ON OS.ResourceID = RS.ResourceID AND OS.BuildNumber0 = @BuildNumber1511        WHERE UI.ArticleID IN (SELECT ArticleID FROM @MarchWin101511) ) -- Windows 10 1607 DECLARE @BuildNumber1607 INT = '14393' DECLARE @MarchWin101607 TABLE (ArticleID NVARCHAR(20)) INSERT INTO @MarchWin101607 VALUES ('4013429') -- March Cumulative INSERT INTO @MarchWin101607 VALUES ('4015217') INSERT INTO @MarchWin101607 VALUES ('4015438') INSERT INTO @MarchWin101607 VALUES ('4016635') INSERT INTO @MarchWin101607 VALUES ('4019472') SELECT RS.Name0, OS.BuildNumber0 FROM v_R_System RS JOIN v_GS_OPERATING_SYSTEM OS ON RS.ResourceID = OS.ResourceID AND OS.BuildNumber0 = @BuildNumber1607 WHERE RS.Name0 NOT IN (        SELECT RS.Name0        FROM v_Update_ComplianceStatusReported UCS        JOIN v_UpdateInfo UI ON UCS.CI_ID = UI.CI_ID        JOIN v_R_System RS ON RS.ResourceType=5 AND RS.ResourceID = UCS.ResourceID        JOIN v_StateNames SN ON SN.TopicType=500 AND SN.StateID=3 AND SN.StateID = UCS.Status        JOIN v_GS_OPERATING_SYSTEM OS ON OS.ResourceID = RS.ResourceID AND OS.BuildNumber0 = @BuildNumber1607        WHERE UI.ArticleID IN (SELECT ArticleID FROM @MarchWin101607) ) Scenario 2: Customers with Supersedence rule set to ‘Immediately expire’ (or not long enough): Since CUs are superseded each month, and expired due to the ConfigMgr Supersedence Rules option being set to ‘Immediately Expire’, compliance data is not available on the expired update – in this scenario, you will, however, have compliance data on the newest CU available, so the simplest path forward would be to deploy the latest CU and report against it. Alternate Options (for Windows 10 and Server 2016): Alternative options to the above, that may help determine ‘at risk’ machines, by reporting on the expired CU, are as follows: A. Extend Hardware Inventory to include Win32_QuickFixEngineering, and use this data to identify ‘at risk’ machines. If any machine has neither March, April or May CU installed, they’re ‘at risk’. NOTE that if you do not have this already enabled and enable it now, you would need to wait for all the clients to report Hardware Inventory. -- Customers with Win32_QuickFixEngineering class enabled for HINV can use these queries. -- Windows 10 machines that do not have the March (or any of the superseding updates) installed and could be 'at risk'. -- These queries are OS dependent, since we are querying individual KB's, and need to compare those KB's against proper builds to prevent getting inaccurate results. -- Query limits results for machines that have at least one row in v_GS_Quick_Fix_Engineering class to ensure there is some HINV data for the machine for this class. -- Windows 10 RTM DECLARE @BuildNumberRTM INT = '10240' DECLARE @MarchWin10 TABLE (ArticleID NVARCHAR(20)) INSERT INTO @MarchWin10 VALUES ('4012606') -- March Cumulative INSERT INTO @MarchWin10 VALUES ('4019474') INSERT INTO @MarchWin10 VALUES ('4015221') INSERT INTO @MarchWin10 VALUES ('4016637') SELECT RS.Name0, OS.BuildNumber0, QFE.HotFixID0, COUNT(QFEALL.HotFixID0) AS TotalHotfixes FROM v_R_System RS JOIN v_GS_OPERATING_SYSTEM OS ON OS.ResourceID = RS.ResourceID AND OS.BuildNumber0 = @BuildNumberRTM JOIN v_GS_QUICK_FIX_ENGINEERING QFEALL ON QFEALL.ResourceID = RS.ResourceID LEFT JOIN v_GS_QUICK_FIX_ENGINEERING QFE ON QFE.ResourceID = RS.ResourceID AND QFE.HotFixID0 IN (SELECT 'KB' + ArticleID FROM @MarchWin10) WHERE QFE.HotFixID0 IS NULL GROUP BY RS.Name0, OS.BuildNumber0, QFE.HotFixID0 HAVING COUNT(QFEALL.HotFixID0) > 0 -- Windows 10 1511 DECLARE @BuildNumber1511 INT = '10586' DECLARE @MarchWin101511 TABLE (ArticleID NVARCHAR(20)) INSERT INTO @MarchWin101511 VALUES ('4013198') -- March Cumulative INSERT INTO @MarchWin101511 VALUES ('4015219') INSERT INTO @MarchWin101511 VALUES ('4016636') INSERT INTO @MarchWin101511 VALUES ('4019473') SELECT RS.Name0, OS.BuildNumber0, QFE.HotFixID0, COUNT(QFEALL.HotFixID0) AS TotalHotfixes FROM v_R_System RS JOIN v_GS_OPERATING_SYSTEM OS ON OS.ResourceID = RS.ResourceID AND OS.BuildNumber0 = @BuildNumber1511 JOIN v_GS_QUICK_FIX_ENGINEERING QFEALL ON QFEALL.ResourceID = RS.ResourceID LEFT JOIN v_GS_QUICK_FIX_ENGINEERING QFE ON QFE.ResourceID = RS.ResourceID AND QFE.HotFixID0 IN (SELECT 'KB' + ArticleID FROM @MarchWin101511) WHERE QFE.HotFixID0 IS NULL GROUP BY RS.Name0, OS.BuildNumber0, QFE.HotFixID0 HAVING COUNT(QFEALL.HotFixID0) > 0 -- Windows 10 1607 DECLARE @BuildNumber1607 INT = '14393' DECLARE @MarchWin101607 TABLE (ArticleID NVARCHAR(20)) INSERT INTO @MarchWin101607 VALUES ('4013429') -- March Cumulative INSERT INTO @MarchWin101607 VALUES ('4015217') INSERT INTO @MarchWin101607 VALUES ('4015438') INSERT INTO @MarchWin101607 VALUES ('4016635') INSERT INTO @MarchWin101607 VALUES ('4019472') SELECT RS.Name0, OS.BuildNumber0, QFE.HotFixID0, COUNT(QFEALL.HotFixID0) AS TotalHotfixes FROM v_R_System RS JOIN v_GS_OPERATING_SYSTEM OS ON OS.ResourceID = RS.ResourceID AND OS.BuildNumber0 = @BuildNumber1607 JOIN v_GS_QUICK_FIX_ENGINEERING QFEALL ON QFEALL.ResourceID = RS.ResourceID LEFT JOIN v_GS_QUICK_FIX_ENGINEERING QFE ON QFE.ResourceID = RS.ResourceID AND QFE.HotFixID0 IN (SELECT 'KB' + ArticleID FROM @MarchWin101607) WHERE QFE.HotFixID0 IS NULL GROUP BY RS.Name0, OS.BuildNumber0, QFE.HotFixID0 HAVING COUNT(QFEALL.HotFixID0) > 0 B. Create a Configuration Item and Baseline which queries the March, April and May CU’s from Win32_QuickFixEngineering and reports Compliance. Here’s a sample PowerShell script written by Umair Khan that can be used in a DCM Baseline: $InstalledKBList = Get-Wmiobject -class Win32_QuickFixEngineering -namespace "root\cimv2" | select-object -Property HotFixID | Out-String $WannaCryList = "KB4012598", "KB4012212", "KB4012215", "KB4012213", "KB4012216", "KB4012214", "KB4012217", "KB4012606", "KB4013198", "KB4013429", "KB4015219", "KB4015221", "KB4016636", "KB4015438", "KB4015550", "KB4015551", "KB4016637", "KB4019473", "KB4016635", "KB4018466", "KB4015552", "KB4019215", "KB4019216", "KB4019474", "KB4019472", "KB4019264" 　　 $Compliant = 0; foreach ($elem in $WannaCryList) { 　　 　　　　if ($InstalledKBList -match $elem) 　　　　{ 　　　　#Write-Output "$elem Found" 　　　 $Compliant = 1 　　　　break 　　　 } } $Compliant Click to Post

[megasoft012]

How to find custom hardware inventory classes imported (MOF) into ConfigMgr database

How to find custom hardware inventory classes imported (MOF) into ConfigMgr database

Configuration Manager site database contains a large collection of information about the network, computers, users, user groups, and many other components of the computing environment. Being SCCM Admin, you need to understand the different categories of the SQL views, what information is stored in each view, and how the SQL views can be joined to one another to create reports that return the…

[les2t]

SCCM – Pas d’accès au compte IUSR après l’installation du client sur serveur DP multicast

SCCM – Pas d’accès au compte IUSR après l’installation du client sur serveur DP multicast

Microsoft a publié un billet sur un problème survenant sur les version 2012 à CB de SCCM. Lorsque le client SCCM est installé où supprimé d’un point de distribution Multicast, l’autorisation au compte IUSR (compte d’accès anonyme pour IIS) est retiré du dossier du client (CCM ou SMS_CCM). Cela provoque l’arrêt de la fonction Multicast.

(more…)

[vonkrugger]

Creating VHD from Configuration Manager

http://dlvr.it/3zwMBT #msv

[megasoft012]

Clean up your WSUS database for better performance and SCCM software update compliance

Clean up your WSUS database for better performance and SCCM software update compliance

  Introduction:

With the recent Current Branch updates starting from 1806 , Microsoft is making good improvement on Software updates maintenance but there is lot to come in the near future. Read the Software updates maintenance tasks available in SCCM https://docs.microsoft.com/en-us/sccm/sum/deploy-use/software-updates-maintenance

Many SCCM Admins think that ,installing WSUS ,doing initial…

[megasoft012]

SCCM Configmgr collection SQL identify duplicate computer records with different GUID

SCCM Configmgr collection SQL identify duplicate computer records with different GUID

I was working on SCCM report for client health dashboard. During this report creation ,found that ,device appear twice with different GUID ID and resource ID but with same hostname.

So i started looking at this issue to see how identify the records with duplicate hostnames.

SCCM clients are uniquely identified by a GUID. A GUID is a combination of the client’s media access control (MAC) address…

[megasoft012]

SCCM Report Get list of devices with pending reboot in a collection with different states

SCCM Report Get list of devices with pending reboot in a collection with different states

Beginning with the release of SCCM ConfigMgr Build 1710 or later , you can use the SCCM Console to identify client devices that require a restart, and then use a client notification action to restart them. If you want get this feature enabled on the client side ,you must also upgrade clients to version 1710 or later for this capability to function

This become so much easier for SCCM engineers to…

[megasoft012]

SCCM ConfigMgr Compliance status of client for multiple software update groups

SCCM ConfigMgr Compliance status of client for multiple software update groups

After long-time ,i am back with quick SCCM Configmgr software update compliance report .A friend of mine asked me today morning that ,he wants to check the compliance report for specific computer (could be VIP ) against one or multiple software update groups that they have created/deployed.

How do you check the compliance status of computer for specific software update groups ONLY and not for…