SCCM Tips, Scripts and Tools

By default Windows 10 and Server 2016 dosnt have the install files needed to add .net 3.5. So when you try to install it like any other feature it fails. In order to install .net 3.5 you will need windows 10 or server 2016 install media. Then you can do the fallowing to install .net 3.5

1. Mount windows 10 install media

2. Open a administrator command line

3. Run the fallowing command
Replace D:\ with the drive letter of your install media 

DISM /Online /Enable-Feature /FeatureName:NetFx3 /All /LimitAccess /Source:D:\sources\sxs
4. Once the install has completed you will want to restart the computer.

You could also copy the files from the install media and place them on a share to use this in a Task Sequence.  Simple place the command in a run command task.

Queries that can be used for SCCM collections

All Windows 7 Computers

select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name, SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup, SMS_R_SYSTEM.Client from SMS_R_System innerjoin SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceId = SMS_R_System.ResourceId where SMS_G_System_OPERATING_SYSTEM.Caption like"Microsoft Windows 7%"
Windows 7 x86 Computers

select SMS_R_SYSTEM.ResourceID, SMS_R_SYSTEM.ResourceType, SMS_R_SYSTEM.Name, SMS_R_SYSTEM.SMSUniqueIdentifier, SMS_R_SYSTEM.ResourceDomainORWorkgroup, SMS_R_SYSTEM.Client from SMS_R_System innerjoin SMS_G_System_PROCESSOR on SMS_G_System_PROCESSOR.ResourceID = SMS_R_System.ResourceId innerjoin SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceId = SMS_R_System.ResourceId where SMS_G_System_PROCESSOR.AddressWidth = 32and SMS_G_System_OPERATING_SYSTEM.Caption like"Microsoft Windows 7%"
…

Introducing PEBuilder version 3.2.2.2 with the below changes to the Builder gui, script and image
Added the ability to have BrowsForFolder .net Support in application, Some application that show a folder list would not always show this was due to a missing dll and registry keys in WinPEAdded a copy function to the PEbuilder script to copy the needed dllAdded a few lines to the  PowerShell Profile to add the needed keys these keys are not accessible when the image is offline so you must load them on each startup Added a add addition components button that allows you to add more components then the presets for PowerShell and Bitlocker.  Fixed  a issue that would stop the image from being dismounted if another image was already mountedReworked the process to save to a iso fileYou can now choose the location you want the iso to be save to If the file already exist it will save the file with a number increment  Fixed a issue that prevented ProduKey from launching with its run command A…

CSV Viewer is the latest addition to my self made tool box, as always the tool is written in PowerShell and converted into a exe. CSV Viewer is a light tool that you can use on any windows device that has PowerShell 2.0 and .net framework installed. The tool will open a browse for file dialog box that will only allow you to choose a CSV file then once you choose a file a data grid will open the file allowing you to view the content, you can even filter and sort the content of the csv file.







<#.SYNOPSIS View CSV files.DESCRIPTION Opens a browes box to select a CSV file, once a file is chosen a data grid will open the file .NOTES Created By: Kris Gross Contact: Krisgross@sccmtst.com Twitter: @kmgamd Version 1.0.0.0.LINK You can get updates to this script and others from here http://www.sccmtst.com/#>Function Hide-PowerShellWindow() { <#.SYNOPSIS Hides the PowerShell Console Window.DESCRIPTION Hides the PowerShell Console Window.PARAME…