All articles about Microsoft System Center range of products.
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….
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…
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…
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…
If you want to create a Configuration Manager Collection with all inactive devices in it, you can use the following WQL query. You can also change the last “0” to “1” to create a collection of active devices.
If you are using System Center Service Manager (SCSM) you may want to delete all your incidents. This may sound strange but if you are setting up and testing and then want to remove all those test incidents – this can sometimes be the case. So, all you need to do is to start up…
We recently came across a great guide on how to setup a DCM item to detect if any users machines had the Windows Firewall turned off and how to report on it. So, we thought we would share this guide with our visitors, so head on over to MyITForum to check out how to carry…
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…
This is more of a reminder for ourselves, but if you are looking to download Microsoft SQL Server 2012 express, for which you can use to install the SQL Console Management Tools as well, then the download link is below: Microsoft SQL Server 2012 Express Download
We have been carrying out some work on various HTA’s for SCCM OSD processes lately and that has included automatically setting time zones. We struggled to find a comprehensive list of the time zone settings so thought that we would share that information here. If you find anything that we may have missed, please let…
So you may have seen our previous post on how to set the local computer description during SCCM OSD. Well now, with a little help from a script and MDT, we can take that local computer description and make that the Active Directory computer description. To do this, you first need the required script, which…
If you are using Configuration Manager to deploy your operating systems, then you may want to set the local computer description during the task sequence phase. To do that is a very simple process and you can use a manual method of inputting the computer name on the task sequence step or use a HTA…
If you are trying to deploy an operating system using SCCM and you are getting an error 80220005 at the “Apply Windows Settings” step, then there can be two reasons for this. One is that the computer name that you are trying to give to the machine is over 16 characters long and will cause…
If you are setting up some distribution points for Configuration Manager (SCCM) then you will need to ensure that you have all the correct server features installed and also the correct firewall ports opened. To do this, we have created a quick PowerShell script to carry this all out for us. To download this script…
If you are deploying Microsoft Office 2013 then you will have used the Microsoft Office Customization Tool (OCT) to tell your installer what parts of Office to actually install. So what if you have setup your installer to carry out the standard Word and Excel installs but you also want Skype for Business (or Lync…
Autodesk DWG Trueview 2017 was released back in March but we have only just got around to deploying it to our System Center Application Catalog for users to install. The process is pretty simple and the below guide will show you how to add it to your own Application Catalog. Prerequisites First thing you need…
We have been looking into getting our OSD process to automatically change the computer name to what we want it to be for a while now but never really had much luck with it. Reading various forums and blogs, many people have said to use WSNAME and many others saying use scripts, all of which…
We have now updated our Autocad 17 serial number collection script to include the recently released AutoCAD 2017 and AutoCAD LT 2017. The following additions have been made to the script: AutoCAD 2017 – English AutoCAD 2017 – Polish AutoCAD 2017 – Italian AutoCAD 2017 – Hungarian AutoCAD LT 2017 – English AutoCAD LT 2017 –…
This is a guide on how to capture Microsoft Office updates from a machine and then use these captured updates to either streamline a fully updated installation of Microsoft Office, or it can be used with Configuration Manager to ensure that you are pushing out the software fully patched. The reason we started using this…
There is an excellent Powershell download available giving you 52 operational collections within SCCM. You should go over to the link below and take a look: 52 SCCM Powershell Collections Full list of collections created using the Powershell script are: All Clients All Clients Active All Client Inactive All Clients R2 CU0 All Clients R2…
System Center Configuration Manager 1602 has now been released and you can easily upgrade to it by going into your Configuration Manager 1511 console and browsing to: Administration > Cloud Features > Updates and Servicing Then in there you should see the new version available for pre-req checks and installation: To install, simply highlight the update…
You may have seen our previous post about adding a local user to a machine during SCCM OSD using a “Run Command Line”. Well in this guide we will show you how to add a local user into the Administrators Group on the local machine. This means that you can add a local user and…
If you are using SCCM for your operating system deployments across different countries, then you may want to set the time zone within the task sequence. To do this, you can take advantage of the built in Windows tool call tzutil.exe. In this example we will set the time zone for a computer deployment based…
If you are looking for a SCCM collection query for virtual machines in your environment, then you can use this query below:
If you are looking at setting up your System Center Configuration Manager (SCCM) with PKI, then there is an excellent step by step guide that you can follow from SCCMGuy. The link to this guide is below: https://sccmguy.com/2013/11/26/pki-certificates-for-configuration-manager-2012-r2-part-1-of-4-web-server-certificate/ We have used this in the past our various labs and it details well what you need to…
If you have recently upgraded your SCCM to version 1511, you will have had to have upgraded your ADK to the Windows 10 version. However, did you first note down your customisation and network card drivers that you had in your boot image? If not, you will now find that those tabs are missing. So,…
If you have upgraded to SCCM 1511 recently then you may have not yet noticed that their is a new Software Center available and included within the Software Center itself is an area when users can download the applications directly instead of having to have Silverlight installed and use Internet Explorer. The old Software Center…
We today ran into an issue where our SCCM OSD PXE boot was not working. It was coming up with a very confusing message stating: “A required device isn’t connected or cannot be accessed” This led us to start looking at the hard drive and the drivers, however, the solution was completely different. The problem…
If you need a WMI query for Group Policy or for Configuration Manager for machines that have Internet Explorer installed and even a version filter, then you can use the following: SELECT * FROM CIM_Datafile WHERE Name = “C:Program FilesInternet Exploreriexplore.exe” AND Version LIKE “11.%” You can then change the “11.%” part to the version…
Have you deployed a Task Sequence in SCCM R2 SP1 and then cannot see it when you PXE boot your machine? Well, this is a bug and it is very easily fixed. All you need to do is go through your normal process of creating and deploying a Task Sequence, but after you have created…
If you are looking at doing some housekeeping on your Application Catalog within SCCM for user requests then you will find that there is not a Microsoft supported why of doing this. This has been causing us problem recently having approved software for a user and then the users going onto different machines and installing…
A lot of people ask us about getting older versions of Java Clients. So we have now launched a Java client micro-site with all the previous versions that we have available and all upcoming versions. You can download the Offline Installers and MSI files from our Java website using the link below: DOWNLOAD INSTRUCTIONS When…
