SCCM – Chassis Types Values

microsoft black logo

This is a quick reference guide to the Chassis Type values that are pulled from machine when using SCCM. 1 = ‘Other’ 2 = ‘Unknown’ 3 = ‘Desktop’ 4 = ‘Low Profile Desktop’ 5 = ‘Pizza Box’ 6 = ‘Mini Tower’ 7 = ‘Tower’ 8 = ‘Portable’ 9 = ‘Laptop’ 10 = ‘Notebook’ 11 = … Read more

SCORCH runbooks not showing in SCCM or SCSM

system center

When you create a new System Center Orchestrator Runbook and you have checked it in ready to use, you may not see it in systems that will want to use it, like Configuration Manager, Microsoft Deployment Toolkit or Service Manager. This is due to authorisation cache not updating and as so, not showing the newly … Read more

Use Powershell to download the latest offline definition updates for Microsoft Forefront Client Security, Microsoft Forefront Endpoint Protection 2010 and Microsoft System Center 2012 Endpoint Protection

powershell

This post will show you how to download the latest anti-malware definition updates for Microsoft Forefront Client Security, Microsoft Forefront Endpoint Protection 2010 and Microsoft System Center 2012 Endpoint Protection using Powershell commands. Step by Step Guide Windows x86 (32-bit) To download the definition updates files for 32-bit (x86-based) versions of Windows, run the following … Read more

Using Windows Expand Tool to Extract CAB Files

3

If you are a regular user of downloaded CAB driver packs then you are probably using something like 7-Zip to extract them. Well there is an alternative way of extracting the CAB file using a basic Windows tool. Download your CAB file and make note of the file location. Then open a command prompt and … Read more

Errors when trying to inject offline Windows Updates into a mounted WIM

WIMerror

If you are using WIM files for Operating System Deployments (OSD) you may be injecting Windows Updates in to the WIM to keep them up to date. If you are doing this, you may run into errors when processing through the updates like this: This is because the mounted WIM thinks that there are pending … Read more

System Center Orchestrator – SQL Query to show log file data

SystemCenter logo

If you are using System Center Orchestrator (SCORCH)  Runbooks then you may have run into issues where the database is increasing in size due to the large amount of log files being created. This typically occurs when monitoring event logs on servers amongst some other runbook options in SCORCH. If you want to check how … Read more

Extract and Save Program and Features Icons

1 2

If you are looking to extract an icon from your Programs and Features list to use in any programs, documentation or systems like Configuration Manager, then you can use this guide to do that. The icons are actually stored in the C:\Windows\Installer folder but to ensure that you get the correct one, you will need … Read more

Inject Windows Updates into WIM Image Files Using PowerShell

ssc 0

To inject Windows Updates into custom-built images that you are using in your Configuration Manager OSD environment, you may find that keeping them up to date is a real problem. If you are happy with the image itself and do not want to make any changes to it, why should you need to rebuild and … Read more

SCCM SQL Query – Google Earth Installs

google earth pro MSI logo

We have recently been asked to report on Google Earth installations within our SCCM environment. So, as we were already collecting the EXE file information within our hardware inventory, we could make use of the SoftwareFile data in the SCCM SQL database. Also, having spent some time Googling a query for Google Earth, we found that … Read more

SCCM – How to clear CCMCache content older than x days using Compliance Settings

sccm logo

If you are using SCCM for the deployment of software then you may find that with the smaller SSD’s that you may be using that free space is becoming an issue. This can be because the more an end user installs to their machine from your Software Catalog, the more data that is being downloaded … Read more

SCCM – OneDrive Next Generation Sync Client

onedrive logo

If you want to deploy the new OneDrive Next Generation Sync Client using SCCM, then there is a excellent guide available detailing how to do this over at scconfigmgr.com You can see the guide by clicking the link below: https://www.scconfigmgr.com/2016/05/24/deploy-onedrive-next-generation-sync-client-with-configmgr/ 594

SCCM – Apple iOS 10 Update for Configuration Manager 1606

apple logo

Microsoft have now released an update for Configuration Manager version 1606 to add Apple iOS 10 to the supported platforms list. This update adds the following platforms to the supported platforms list for Microsoft System Center Configuration Manager current branch, version 1606: All iOS 10 iPhone or iPod Touch devices All iOS 10 iPad devices … Read more

SCCM WQL Query – All Windows 10 Installs

ssc 0

If you are using Configuration Manager and you want to create a collection based on all Windows 10 installations, you can use this WQL query below: 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 where SMS_R_System.OperatingSystemNameandVersion like “%Microsoft Windows NT Workstation 10%” You can change the “%Microsoft Windows NT Workstation 10%” to create collections … Read more

SCCM SQL Query – Count Computers by Model

sql

If you are using Configuration Manager and want to run an SQL query on your database to count the number of different models you have in your organisation, you can use this SQL query below using SSRS to create a custom report: More Queries Our full range of SQL and WQL Collection queries are available here. … Read more

SCCM WQL Query – No ConfigMgr Client Installed

ssc 0

If you are using Configuration Manager and you want to create a collection of all devices that do not have the Configuration Manager Client installed, then you can use this WQL query: More Queries Our full range of SQL and WQL Collection queries are available here. Feedback If you have any questions or feedback about this post, or … Read more

SCCM WQL Query – Clients without latest version installed

sccm logo

If you want to create a collection in Configuration Manager to show you all the devices that are not up to a specified version, then you can use the WQL query below: 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 where SMS_R_System.ClientVersion != “5.00.8412.1007” Where “5.00.8412.1007” is the latest version number that you are … Read more

SCCM Task Sequence Error – Can’t find script engine VBScript

sccm logo

We have recently started to have problems with running a CScript command in one of our SCCM task sequences where we send the local computer description to Active Directory to automatically set the Active Directory computer name description. It has always worked fine but seemed to have stopped working after the latest hot fix. So, … Read more

WSUS Installation Errors on Microsoft Server 2012

Windows Server 2012

We have recently been installing WSUS on a rebuilt Microsoft Server 2012 and found that although the role would install without any issue, when we tried to run the configuration wizard we were getting an error and in the log file it stated: “Config file did not contain a value “ContentDirectory”” So, first of all, … Read more