Category Archives: System Center

All articles about Microsoft System Center range of products.

Bulk Delete Multiple Operations Manager Management Packs [2020 Updated]

By | March 30, 2023

If you are using System Center Operations Manager and you want to bulk remove multiple Management Packs, then you can use the power of the Operations Manager Shell to carry it out. First of all, you need to open up the Operations Manager Shell. Then you should run the following command: where: “*Microsoft.SQLServer*” = the… Read More »

System Center Orchestrator – SQL Query to show log file data

By | June 10, 2023

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 »

System Center Operations Manager – Apply Licence using PowerShell

By | April 17, 2023

If you are using System Center Operations Manager (SCOM) then you will find that you will need to apply your correct licence key to take it from an evaluation version up to a full version. To make this a simple process, you can run the following PowerShell command on your Operations Manager server: #Import Module import-module… Read More »

System Center Operations Manager – Pre-Requisites Powershell Script

By | April 17, 2023

If you are installing System Center Operations Manager, there are a number of pre-requisites that you need to install before running the installer. To make the pre-requisites installation easier, you can run the below Powershell command which will download and install all of the pre-reqs for you. Import-Module ServerManager Add-WindowsFeature NET-Framework-Core,AS-HTTP-Activation,Web-Static-Content,Web-Default-Doc,Web-Dir-Browsing,Web-Http-Errors,Web-Http-Logging,Web-Request-Monitor,Web-Filtering,Web-Stat-Compression,AS-Web-Support,Web-Metabase,Web-Asp-Net,Web-Windows-Auth –restart ##This section will… Read More »

SCCM SQL Query – Google Earth Installs

By | March 30, 2023

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 »

HP Driver Pack Matrix

By | March 30, 2023

If you are looking for HP driver packs then you can use the HP Driver Pack Matrix below: Notebooks & Tablets Windows 10 64-bit Windows 8.1 64-bit HP Elite x2 1012 G1 Tablet HP Elite x2 1012 G1 Tablet with Travel Keyboard sp77863.exe (Updated: 2016-10-07) – HP EliteBook 1030 G1 Notebook PC sp77666.exe (Updated: 2016-10-07) –… Read More »

SQL Server Management Studio (SSMS) 2016 Released

By | March 30, 2023

Microsoft have now released SQL Server Management Studio (SSMS) 2016 and is ready to download and use. You can get the download by clicking the button below: Download SSMS 2016 SQL Server Management Studio (SSMS) is an integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server. SSMS combines a broad group… Read More »

SCCM – OneDrive Next Generation Sync Client

By | March 30, 2023

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/ Free Subscription If you want to be notified when we post more quality guides like this… Read More »

SCCM – Apple iOS 10 Update for Configuration Manager 1606

By | March 30, 2023

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

By | March 30, 2023

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 »

SQL Server Version Numbers

By | March 30, 2023

Below is a full list of SQL Server version numbers dating from version 7.0 through to the current 2016 RTM release. Codename RTM Service Pack 1 Service Pack 2 Service Pack 3 Service Pack 4 SQL Server 2016 NA 13.0.1601.5 SQL Server 2014 SQL14 12.0.2000.8 12.0.4100.1 12.0.5000.0 SQL Server 2012 Denali 11.0.2100.60 11.0.3000.0 11.0.5058.0 11.0.6020.0… Read More »

SCCM WQL Query – Clients without latest version installed

By | March 30, 2023

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

By | April 17, 2023

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 hotfix. So, after… Read More »