SCCM-SQL Server via PowerShell

Hi All, the 3rdpost of this series of SCCM via PowerShell, we’ll be looking at the SQL Server Installation & Configuration for SCCM… 1st, we need to create the firewall rules for SQL. I’m assuming the installation will be done using default instance, so the default port will be TCP 1433 and assuming the SSB Port (for SCCM Data replication if you have a hierarchy) will be 4022 (default).  

  2nd- Install the SQL Server. For this, you’ll need to have access to the SQL Server 2016 RTM source files. Copy the content of the DVD to c:\SQLSource. I’m also assuming the installation will happen on the C:\SQLServer and C:\SQLServer (x86) for the shared x86 files. I’m using the SYSTEM account for the services and will add the CLASSROOM\SCCM Admins as sysadmin (change as required)  

  3rd- Install SQL Management Studio. I’ve downloaded the file to…

SCCM-Site Server Requirements via PowerShell

Hi All, the 2nd post of this series of SCCM via PowerShell, we’ll be looking at the Site Server Requirements… 1st, it is .net framework 3.5. For this, you’ll need to have access to the Windows Server (2012 or 2016) source files. Copy the content of the DVD to c:\WSSource  

  2nd- Confirm the .Net Framework 4.6 is installed. On the default installation, it is already installed, so we only need to check, so running the below powershell, you’ll see the Installed under Install State  

  3rd- Install the RDC windows feature  

  4th- Windows ADK. 1st, we need to download the ADK Setup File to a location in the hard drive (so create a folder called c:\TrainingFiles\Source\ADK and c:\TrainingFiles\Source\ADKW10). After that, we’ll download the ADK Files using the downloaded ADK Setup file. once it is completed (it will take a while), we’ll install…

SCCM-Schema Extension via PowerShell

Hi All, life as consultant has to be always quick and without any mistakes, so automation is the key here. and to start, lets do something that we don’t do every day…Extend the Active Directory for SCCM 1st, execute Extadsch.exe (source from c:\SCCMCBSource)  

  2nd- Create the System Management Container and assign the correct security rights (Group is SCCM Servers)  

  that’s it for today.

SCCM-Script to get some MDT Variables

Hi All, Every time when I go to customer to perform Operating System Deployment, customer always ask about MDT, so I’m here to try to clarify things: – MDT is a great tool, however, it only does OS Deployment, nothing else. It also only does LTI (or Little Touch) – SCCM does what MDT does and much more, it does application deployment, inventory, compliance, as well as OSD (LTI as well as ZTI – Zero Touch) But why there is always this talk?!?! For companies that do not have any tool that can do OS Deployment, MDT can be used. it is really easy to install and configure, in couple of hours you can have an environment ready to start deploying your 1st Windows. But remember what i said, for companies that do not have any tool that can do OS Deployment. If you have SCCM, MDT is not for…

SCCM Administration Free E-book

Hi All, in the past few months, I have dedicated to update a manual that I have been using on my SCCM courses. This manual is now a free e-book and focus on the step-by-step of the basics administration of an sccm environment, so this is the exercises manual. I still development my own material and delivering many sccm courses based on the material, as you can imagine, the courses I provide the “why” click here and there, so if you’re new to SCCM and want to learn more about it, you will be more than welcome to attend to one of our curses. Check them out at . Anyway, this e-book focus on the basics of the administration. In this e-book you’ll be guided since the creation of the lab (that is based on Windows Server 2012 R2 Hyper-V). And we cover topics like, installing SQL, SCCM, Installing Site…

ConfigMgr HealthCheck toolkit – Beta 04

Hi All, after long, long time, we are happy to announce that the HealthCheck toolkit is once again available for download and we released a new version, beta 04 with some small fixes… What is the System Center Configuration Manager HealthCheck Toolkit? The System Center Configuration Manager HealthCheck Toolkit (CMHealthCheck) has been created to check for problem and/or misconfiguration in the SCCM environment and, when possible, will provide you with some solutions for problems. You can download it for free from: how to use it: 1- CollectData.ps1 (This script will collect information from a CM12/R2 Infrastructure). Open the powershell (64 bits) and run with an account that has admin rights on the cm boxes as it will connect remotely to registry, wmi, etc. CollectData.ps1 -smsprovider servername (ie. CollectData.ps1 -smsprovider srv0003) Once it collect data, it will create a CollectData.log under _Logs and will create a Date\servername folder (ie. 2013-12-05\srv0003)…

RFL Systems’ BI Dashboard v1.0 release

Hi All, today we are proud to be releasing the v1.0 of the RFL Systems’BI Dashboard, a cutting-edge SCCM-focused platform that streamlines the access, control and management of strategic data. Compliance for software updates, application deployment, client health and anti-malware monitoring are some of the key indicators that you can manage through the BI Dashboard. We take care of simplifying your SCCM data analysis whilst focus on making effective and well-grounded decisions CustomisableYou can tailor how you want to access your data anytime, anywhere. Crystal-clearOur technology makes it easier to convert data into business value. SecureYour data security is a priority through our on-premises software. Easy-to-useStraightforward and simple software and interface. Trial it now! Make sure you download the software here and enjoy a 45 days trial. Hope you will enjoy and feel free to ask questions and provide feedback.

Book Review – Windows-noob OSD guides

Hi All, today I would like to comment about a book that I have read in the last few weeks that is the “The Windows-noob OSD Guides for Configuration Manager 2012 R2, by Niall Brady”. the 1st thing to say is the author, if you don’t know him, I suggest you access Niall has been publishing tutorials there for quite some time and it is a must-stop for those that are stating with SCCM as well as for those that has more experience. The book is well written and clear of what you need to do to achieve the goal, if it is to integrate SCCM with MBAM, deploy a surface pro, custom windows 8.1 start menu or anything else that is related with OSD. Customising boot image, creating custom forms to be using during OSD (HTA forms), drivers, etc. those are things that you need to know to…

Microsoft Policy Analyzer

I love group policy. I believe this is one of the main reasons why companies use Windows instead of an alternative OS like Linux or Mac OS. Group Policy gives you control over your environment, enabling, disabling, configuring, restricting and enforcing settings for the OS or any application you want. If a machine is on the domain, you know the settings will apply. I provide Active Directory consulting very often and in most cases I have to troubleshoot Group Policy settings. This can prove challenging in some environments as the way they were created is not easy to grasp. Microsoft just released (22 Jan 2016) a tool to help you analyse group policy settings. You can choose a group of policies and the tool will treat it as one, highlighting conflicts and duplication. The tool is still in its early stages, but it is a great start. Find out more…

RFLSystems-New Website and updated tool

Hi All, Today I’m proud to announce that RFL Systems’ new website is finally live and more content will be added soon. This is a great milestone for the company and I only have to say thanks to everyone that helped us until now. With the release of the site, we are also releasing the 1st public beta of our professional version of the dashboard, now renamed to Business Intelligence Dashboards for System Center Configuration Manger (or what we are calling BI Dashboards for SCCM), with the final version to be released in the next few of weeks. The development of the BI Dashboards for SCCM started last year and it is a cutting-edge data visualization platform which helps enterprises to streamline the access, control and management of strategic business information. The BI Dashboards for SCCM makes it possible by displaying the status of key metrics and indicators in one…