Making IT Happen
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 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 getting this error message when you open SQL Server Configuration Manager in SQL Server: Cannot connect to WMI provider. You do not have permission or the server is unreachable. Note that you can only manage SQL Server 2005 and later servers with SQL Server Configuration Manager. Invalid namespace [0x8004100e] Then there is a […]
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 […]
If you are looking for a SCCM collection query for virtual machines in your environment, then you can use this query below:
You may want to create a Configuration Manager Collection based upon an Active Directory Organisation Unit. To do this you can use the following WQL code and then simply amend the last part to be the Organisation Unit that you want to base the Collection on: SELECT SMS_R_USER.ResourceID, SMS_R_USER.ResourceType, SMS_R_USER.Name, SMS_R_USER.UniqueUserName, SMS_R_USER.WindowsNTDomain FROM SMS_R_User WHERE […]
This is a re-post of a guide that we posted about two years ago, but this happened to us again thisweek so thought it would be good to share again… We ran into an issue where our newly created folders and runbooks in Orchestrator were not showing up in our SCCM (MDT) Execute Runbooks task […]
When running or trying to create a large report in SSRS, you may come across an error stating the below: Error 2: There was an exception running the extensions specified in the config file. Maximum request length exceeded. It took us a while to figure this one out but it is actually very simple. After […]
If you are a Configuration Manager administrator, the chances are that you are using the Application Catalog to allow users to install their own software.A great feature of this is that you can put in specialist or licensed software and add a “Request” button. This means that your end users will only get the software […]
In Configuration Manager 2012, there is a section under the Monitoring ribbon called Distribution Status. This will give you a lot of information about your distributions and your distribution points. If you look at Distribution Point Configuration Status, this gives you a good understanding of whether your drivers, packages, applications and images have deployed correctly […]
If you want to report on machines that have Outlook archive (PST’s) on them, where they are and how big they are, then you can use this guide to create a report that will do this for you using Configuration Manager. First of all, you will need to tell your Software Inventory to look for […]
We have had a report that one of our WQL queries has not been working correctly, this is the one for devices that have Configuration Manager client installed but do not have System Center Endpoint Protection installed on them. The original post is here: WQL Query for Devices without Endpoint Installed So, we have looked […]