SystemCenter

All about System Center Articles and Tutorials

Check if Specific Hotfix installed on a Collection – SCCM

Posted by on Aug 11, 2017 in SCCM, SQL

Check if Specific Hotfix installed on a Collection – SCCM

Recently we got a request from our Platform Team whether we can fetch any report from System Center Configuration Manager to check if specific Hotfixes installed on all the servers managed by them. After further discussion, we got to know that they wanted to check all the systems that miss the WannaCry related hotfixes. Let’s create the report using Microsoft SQL Server Report Builder. Before...

Read More

Build SCCM Report to check Installed Hotfixes on a System

Posted by on Jul 11, 2017 in SCCM, SQL

Build SCCM Report to check Installed Hotfixes on a System

Recently after couple of Ransomware attacks, we have got a requirement from our Server Operations team whether they can get a report wherein they can get a list of installed Hotfixes on a system. There are sites which provides the PowerShell scripts to check this information, however they wanted us to author a report in SCCM through which they can get list of installed Hotfixes on a system. So,...

Read More

Configure Reporting Services & Install Reporting Services Point Role – Configuration Manager

Posted by on Jul 5, 2017 in SCCM, SQL

Configure Reporting Services & Install Reporting Services Point Role – Configuration Manager

System Center Configuration Manager provides Reporting feature using advanced reporting capabilities of SQL Server Reporting Services (SSRS). It uses SQL Server Report Builder as the exclusive authoring and editing tool for model-based and SQL-based reports through which we can author desired reports to gather, organize and present the information about users, hardware, software inventory,...

Read More

Install stand-alone Primary Site – SCCM (Current Branch)

Posted by on Jul 4, 2017 in SCCM

Install stand-alone Primary Site – SCCM (Current Branch)

In our previous post, Step by Step Prerequisites Installation – SCCM (Current Branch) we have fulfilled all the prerequisites required for System Center Configuration Manager installation. Now let’s proceed with the first SCCM Primary Site installation. A stand-alone primary site is suitable for smaller deployments, and can be used to manage devices without having to install additional sites. It...

Read More

Fix – The SQL server name specified during setup must match the Name in sys.servers of the SQL server

Posted by on Jun 30, 2017 in SCCM, SQL

Fix – The SQL server name specified during setup must match the Name in sys.servers of the SQL server

Recently we got into a situation wherein we were trying to install a stand-alone Primary Site by running system Center Configuration Manager setup in our staging environment. The setup passed all the prerequisite checks however the installation got stuck while setting up the SQL Server database. Below is the error message: The SQL server name specified during setup must match the Name in...

Read More

Step by Step Prerequisites Installation – SCCM (Current Branch)

Posted by on Jun 23, 2017 in SCCM

Step by Step Prerequisites Installation – SCCM (Current Branch)

In our previous post Install SQL Server 2016 for System Center Configuration Manager we have installed the SQL Server for our SCCM environment. Now it’s time to move a step further and satisfy certain prerequisites which are required before running the SCCM setup else we will get errors during SCCM installation. The environment which is being used for this demo is a two server farm wherein one...

Read More