automation

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.

PowerShell – How to name Functions

Hi All, In development world, we normally re-use code. More experienced developers, re-use more code than developers that are starting. It is not just PowerShell, this is also used when coding on any language but with PowerShell, you have the option to create a function within your script or inside modules, but the problem is always the same, how to name these functions. Before writing a function, you need to know what the function will do and what is the expected return of the function. So lets look at an example: I discovered in a code, that I use, lots of time, writing text to a file. if the file does not exist, it will be created and if it does exist, i’ll append text. as you can imagine, the function could be called SaveToFile, AppendToFile, WriteToFile, etc. instead of something like MyFunction. You may be thinking, who would write…

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 .http://www.rflsystems.co.uk/training/ 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…

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…