powershell

Github & Youtube

Hi All, after long overdue, i’m now moving all my public “stuff” to github (https://github.com/dotraphael). All tools that i use will be under the tools repository (https://github.com/dotraphael/Tools) where you can find powershell, vbs and c# stuff. Most of the tools will be something i’ve created, but some will be from another author where i add information about where the source comes from… Everything about the SCCM e-Book Administration v3 is under https://github.com/dotraphael/SCCMAdminEbookv3. I’m also already preparing the v4 of the e-book that is available under the SCCMAdminEbookv4 repository https://github.com/dotraphael/SCCMAdminEbookv4 and if you want to help me write, there is a template word file that you can download froom https://github.com/dotraphael/SCCMAdminEbookv4/blob/master/chapter/xx.%20Template.docx. Scripts will also be available there. the repository EMS-with-Microsoft-Intune-E-Book (https://github.com/dotraphael/EMS-with-Microsoft-Intune-E-book) will have all the content that for my new e-book about Intune (once i have finished with the v4 SCCM e-book :)) and of course, you’re free to help out if…

SCCM – Updated E-book SCCM Administration v3

Hi All, my updated SCCM e-book has finally been released. It took some time to write up and test. With 130 pages divided in 37 chapters, you’ll find lots of good info about starting with SCCM. And it is free… In this version, I removed Linux related topics, Updated Windows 10 to 1709, added sections for Cloud Management Gateway (CMG), Windows 10 Express updates, SCCM Data warehouse, Office 365 Installer, Windows 10 Update Readiness, Pending Reboot, updated some other section for SCCM 1710 and updated/added some powershell scripts To download, click here. let me know if you have any feedback

SCCM-SCCM Validate Installation via PowerShell

Hi All, the 5th post of this series of SCCM via PowerShell, we’ll be looking at the validating the SCCM Installation… before we start, i’m assuming the site code is 001, if its not, you should change it 1st, we’ll check if the SMS_DATABASE_NOTIFICATION_MONITOR has any messageID 2420. this messageid is normal during the SCCM installation nbsp;

  2nd, check for the SMS_SITE_SQL_BACKUP, messageID 4959. If exist, check SPN nbsp;

  3rd, check for SMS_SITE_COMPONENT_MANAGER, messageID 1027. nbsp;

  4th, check for SMS_HIERARCHY_MANAGER messageID 3306 (everything is ok), 3323 (site is HTTP/HTTPS) and 4911 (system management container permissions correct) and 4913 (system management permissions issue, check it). nbsp;

  5th, check SMS_REPLICATION_CONFIGURATION_MONITOR messageID 4629 (working OK) and 620 (If found check performance on SQL Server) nbsp;

  6th, check SMS_DPM_DOWNLOADER messageID 4629 (ok), 9700 (check network) nbsp;

  finally, check SMS_WINNT_SERVER_DISCOVERY_AGENT messageID 4202 and…

Awesome news – Book & Software

Hi All, i have some awesome news to share with you. 1st news, yesterday my new SCCM e-book was finally released. It took some time to write up and test. With 197 pages divided in 33 chapters, you’ll find lots of good info. The book has also over 160 powershell scripts, so you can automate almost (if not all) SCCM tasks you’ll be performing on day to day basic. And on top of that, it is free. To download, access https://goo.gl/CmRTcm, fill up the form and download the PDF. 2nd news, yesterday we also released a new version of our Dashboard software, now called DataExplorer with modules for SCCM, SCSM, Hyper-V, Active Directory and Office365. To download a trial version of the software, access https://goo.gl/O0foHg, fill up the form and download the Setup file.

SCCM-SCCM Installation via PowerShell

Hi All, the 4th post of this series of SCCM via PowerShell, we’ll be looking at the SCCM Installation… 1st, we need to download the pre-requisite files (assuming you’ve copied the source files of SCCM to c:\SCCMCBSource).  

  2nd- Run the pre-requisite check to confirm there is o issues on the server to install (also, assuming the computer name is SRV0002.classroom.intranet)  

  3rd- Creating a firewall rule, so you can run the SCCM console from a remote machine  

  4th- Let’s perform the site installation. assuming here that you’ll be installing as evaluation, sitecode will be 001, site name will be Training Lab and the installation folder will be c:\ConfigMgr  

  that’s it for today. next post we’ll be looking at validations..see you soon

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…