All articles about Microsoft System Center range of products.
If you are looking for a SQL query to pull back hardware inventory information and the SCCM client version, then you can use the below to pull all this information together. SELECT S.Name0 as Name, S.Client_Version0 as [Cient Version], OS.Caption0 as [Operating System], CS.Manufacturer0 as Manufacturer, CS.Model0 as Model, PB.SMBIOSBIOSVersion0 as BIOS, PR.Name0 as CPU,…
If you are looking for an SCCM SQL query to create a report to search for machines which do not have a particular software installed, you can use the following: Then you can use the variable @displayname to choose from a drop down of software that is in the SCCM database pulled from client machines….
We had seen a few posts around the internet where people are asking the differences between the various Add_Remove_Programs data within the System Center Configuration Manager database. So we thought we would post a quick reference here to confirm which table of data means what. There are five different tables of data available to you…
If you are looking for an SQL query to use against your System Center Configuration Manager database to give you the ability to report on server CPU information, this is the query for you! You can use the below to get various information on the CPU or you can use SELECT * to bring back…
If you have been using System Center Endpoint Protection and you now want to move away from it, you will need to carry out an uninstall of the software. This can be very easily carried out either through a manual process of uninstalling using the Programs and Features within the Windows Control Panel or if…
Some time ago there was a bug within SCCM where when you deployed an application, you had to change the deployment date back a day to make it work. This seemed to have been fixed when moving over to current branch but this issue has raised it’s head again. This will cause clients trying to…
When using System Center Service Manager (SCSM) you can sometimes end up with Incidents, Change Management items or Service Requests that need to be deleted individually. You an carry this out by using a combination of SMLets and PowerShell. INSTRUCTIONS The first thing you will need to do is to download and install SMLets on your…
This guide assumes that you use Microsoft Deployment Toolkit (MDT build 8443) or Microsoft System Center Configuration Manager (SCCM) capturing Windows 10. You capture a task sequence, and the capture computer does not have Internet access. When the task sequence is running and the computer is checking for updates (pre-application installation), the installation freezes for…
If you are using Configuration Manager, you will be aware that you can create a number of custom reports using the SCCM SQL data and SSRS to produce the reports. The best way to start creating a custom report is to ensure that you get your SQL query correct first. We have written hundreds of…
We recently had put together a SCCM Build and Capture task sequence to update our images up to Windows 10 version 1709. We copied the install.wim from the sources folder of the Windows 10 v1709 ISO and added this as our operating system capture image. We took our existing task sequence (which has lots of…
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 =…
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…
If you are using System Center Operations Manager (SCOM) then you may have Management Packs in your system that you may longer want – especially if, like me, you go and add as many as you can in blissful ignorance expecting to get lots of tasty data. Then realising that this is a terrible idea…
If you have started a task sequence in Configuration Manager and you hit a problem, the last thing you want to do is to have to go through the reboot process back into Windows PE. So, if you want to just restart the task sequence without rebooting, carry out the following steps: Press F8 to…
If you are using System Center Operations Manager (SCOM) then you may want to enable agent proxy on all your agents. If you want to do this then you can use the power of Powershell to carry this out. Just open up a Powershell command box and use the following command: get-SCOMagent | where {$_.ProxyingEnabled…
If you are trying to install System Center Service Manager Data Warehouse then you may run into an issue on the Configure Analysis Services for OLAP cubes wizard page where it states that The server is not available: We ran into this issue a while ago and we checked everything that we could find on…
If you are using System Center Configuration Manager (SCCM) then you will probably be making use of the Application Catalog feature. This allows IT departments to give a software shop front to its end users freeing up IT staff from the tedious installations of 7-Zip and Adobe Reader. But, the standard URL for the Application…
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…
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…
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…
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…
If you are using System Center Service Manager and creating custom management packs then you will want to seal them with a strong name signature. To do this, you will need to first of all generate the key file to allow you to use it when sealing your management pack. You need to use the…
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…
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) –…
If you are using SCCM and you want to delete a device from your database (for example if you are using OSD and only deploying to Unknown Devices) then you would normally have to go into the SCCM Console, Devices, search for the device and then right click and delete the device which would remove…
We have recently been using a new script that we came across which allows you to run a PowerShell script on your SCCM environment and it looks for all the Dell hardware models that you have and then automatically downloads all the latest drivers and BIOS’s for each machine found. This is an excellent way…
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…
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…
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/
If you are using our Autodesk 2017 serial number collection guide, you may notice that some of your machines are not correctly reporting the serial numbers that are on your client machines. This can be because the hardware delta has found a mismatch in the information and gets itself into a bit of a mess….
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…
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…
