powershell

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…

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: http://www.rflsystems.co.uk/software/healthcheck-toolkit/ 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)…

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…

SCCM-Create wifi profile with password

Hi All, Today I would like to talk about the Wi-Fi profile. SCCM has this great feature that you can manage Wi-Fi profile on all managed computers, make changes, etc, without need for the user to do anything, this is great. however, one of the limitation on a wifi profile is the fact that you cannot set a password when using WAP/WEP. For many large organizations that have a 802.1x or a network where you need to somehow authenticate (certificate, ad username/password, etc), this is not a problem, however, for smaller organizations or organizations that have not implemented this security yet, not having the option to add the password is a pain. i recall that some of the chat i had with some customers where they have deployed the wifi profile and had to e-mail everyone the password, as you can imagine, big security risk… anyway, how can i add…

SCCM-Software Update Compliance taking long time

Hi All, have you ever wonder why the Software Update Compliance takes long time to report the correct date? often that I get this question from a customer that wants to know what the status just after a software update deployment, but when I mean just after, I mean just few minutes. there are lots of things that could cause the status not being showing correctly, like network, etc. that is outside ConfigMgr, but in this post, lets talk about the main one, state messages. When using SCCM 2012/2012 R2, the default detailed level setting when deployment a software update group is to report only success and errors messages. this is quite ok for most environments where you go to the deployment node and check things from there, but you’ll not get the compliance for each update. there are 3 options: all messages, only errors messages and the default one…

SCCM-Windows Update 6.2.x on Windows 10?

Hi All, I have been reviewing a report I did for a customer where all Windows 10 machines were reporting Windows Update Agent 6.2.x. what caused my customer to send few people on few windows 10 machines and try to troubleshoot windows update issues where it did not exist. of course, after couple of hours/day, they realise this was a data issue instead of their environment issue. When I started to review, I looked at my lab and I had the same. Executing a query on fn_rbac_UpdateScanStatus, I saw all my windows 10 machines also reporting Windows Update Agent 6.2.x So something was wrong. but why? 1st step was to check if the files on the client where the correct version. if you want to know where I discovered which file to look, click here. As you can see, the file was with the windows 10 version…so I checked Powershell…