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 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…

Automation Backup in a Hyper-v for Small Business/Start up

Hi All, small business and start up’s are always looking for ways to save money. As you should know, small companies they don’t have money to buy fancy products and when people decide to open their business, they have a small amount of money to do some X (this could be buy a PC, server, etc) and keep it running for a couple of months/year without need to invest anymore. When I started RFLSystems while ago, I had the same, a money to start the business and keep it running for some time. in my case, I needed an environment that would be used to do demos to customers as well as running production stuff like CRM, SCCM, File Share, etc. As you can imagine, for me going to cloud was easy, I could add some vm’s, buy services from provides, etc. but, money was a restriction. for me, having…

old 2015 and new 2016

Hi All, I would like to start this post talking about last year, 2015. 2015 started great, with renewing my MVP award. as you can imagine, this is the 1st email I look for on the 1st day of the year, being part of this community is just something that I cannot explain in works, but if I had to choose one it would be: WOW. 2015 was a crazy year for me, in both professional and personal lives. I had been working as CTO/Principal Consultant (and I also was a non-executive directory) for a company called xinfra, but unfortunately, the owner/director decided to close the company down and, so I decided to take my take the risk and take my own business (RFL Systems) to the next level, instead of working of behalf of other companies. And I hope the RFL Systems brand will only grow this year, with…