Quick post on how to get count of list of updates or count of updates in your Configuration Manager with severity categorised as Critical,Important,Moderate and Low. In order to get this information count of updates with severity, you first need to identify what the SQL views that store this information about software updates. Get the SQL views documentation for all Configmgr versions starting from SCCM 2012 to Current Branch 1702 from https://gallery.technet.microsoft.com/SCCM-Configmgr-2012-R2-SQL-5fefdd3b Severity of the software updates is stored in v_UpdateInfo .This SQL view stores lot of other information like title,article ID,bulletin ID,date posted and lot more. Most of the…
Author: Eswar Koneti
Setting up Configuration Manager current branch (1702) lab for testing. While running the Configmgr reports using IE browser ,http://servername/Reports/Pages/Folder.aspx ,it failed with error code HTTP 500 Internal Server Error. SQL server installed locally on Configmgr box . I have seen this error couple of time but i don't remember what was the solution to get it fix. So ,in this blog post, we will try to troubleshoot the issue by going through the log files and solve it. Following the error snippet while while browsing Configmgr reports : When you get this error, the first place to look at…
Installing the distribution point on workstation or server is straight forward method from console .All you need is ,an account that has local admin rights on remote computer to install IIS components and install DP role. To install Distribution point role on remote computer, Open configuration manager ,go to administration node, expand site configuration ,right click on servers and site system role ,choose create site system server and from there ,all self explained. Installing DP role on 1 or 2 computers can be done using the console GUI ,but what if you have more than 10 or 50 or 100…
While i was checking the software update compliance reports for Microsoft and Non-Microsoft (3rd party updates ,SCUP integrated) ,i see that ,compliance report looks good for Microsoft but not for 3rd party updates. SCCM Version: Configmgr Current Branch 1702 with SCUP integrated for 3rd party updates. During the investigation on 1 client, found that ,it is failing to install only adobe & Java updates but rest of the 3rd party updates (Chrome, Filezilla,Firefox etc) installed successfully. Initially when i ran the software update report and compliance % was not at at good shape ,so my thinking was ,it could be…
Other day,I was trying to create my first SCCM Configmgr SSRS report with RBA (role based administration) what it means is ,data for all reports included with Configuration Manager is filtered based on the permissions of the administrative user who runs the report. Administrative users with specific roles can only view information defined for their roles. The report which was trying to create : Get the Status of Bitlocker for all physical devices(Laptop and desktops) for specific collection .The main difference between the normal SQL code and SQL code that you use for RBA reports is ,you simply replace…
Microsoft released April update 1704 for SCCM Configmgr Technical preview with some new features and improvements to the existing features that are reported through user voice . These technical preview updates will help you to test in lab environment and report feedback to Microsoft before they make into current Branch (Production Version). You can install this version to update and add new capabilities to your existing Configuration Manager technical preview site. To see these preview updates in your Configmgr console,you must have the base version of SCCM Configmgr Technical preview 1703 (not applicable to current branch).These Technical Preview updates are…
Since few days ,i have been working on the SCCM console connectivity issues from remote box. This is completely new setup replacing the existing CAS with primaries and going with flat design (1 Primary site.There is blog post coming soon on the SCCM design considerations and notes from the field ) As part of setting up SCCM current branch ,was creating RBAC for the team and for testing ,I have installed the current branch console (1702) on citrix and remote boxes (server/workstation) to try with different user accounts. When i try to launch the console ,it failed with generic error…
In this blog post, we will see how to use compliance item in configuration manager to check specific server role or feature installed on server or not .This request has come up to due to the fact that ,one of the engineer has enabled desktop experience feature on some of the servers which leads to install/enable flash player components in C:\windows\System32\Macromed\Flash folder. Qualys is is a provider of cloud security, compliance services which scan your network, servers, desktops or web apps for security vulnerabilities ,more at https://www.qualys.com/ If you install desktop experience feature on server, it will try to install…