SCCM Tips, Scripts and Tools

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…

I just released a new update to my ISOtoUSB tool. The tool now has some better notifications and some bug fixes.

you can get more info and download the update from the ISOtoUSB page
http://www.sccmtst.com/2018/01/isotousb.html

Some of you may have had the issue where the ISS Application pool for WSUS keeps stopping. In most cases the stop is do the the Application Pool needs to use more memory then it is configured to use.

1. The way to resolve this is to open IIS expand the node and click on application pools in the list find the Application Pool called WsusPool and right click on it choosing Advanced settings.

2. In the Advanced Settings window scroll to the bottom, You are looking for "Private Memory Limit (KB)"

3. Once you find the settings change it to a larger amount be sure you do not set it higher then the memory you have installed on the server. Settings the amount to 0 will get it to unlimited.

That's it once you click ok you should stop having this issue.

SCCM is able to do a lot but sometimes you need to sometimes you need to Install software uninstall the old version move some config files then remove a old shortcut and this all needs to be done as an application deployment. By default SCCM isn't able to handle all of that as an application deployment so you will need a scrip to do it. A while ago I was given a scrip that dose all of that and more the script was old and not all parts of it functioned  so I doctored it up and made it a little more user friendly. The scrip is called Install-Wrapper.ps1 is very easy to use. 

You can get all the scripts from HERE

To start enter the appropriate information under Software Information



and uncommnet the actions you want to run.


Then in SCCM create an Application for the script and for the install parameter enter.

powershell.exe-ExecutionPolicyBypass-NoProfile -File Install-Wrapper.ps1
The msi file should also be in the same folder as the script.

If you need to deploy multiple applications…