SQL

SQL Server Version Numbers

SQL Server Version Numbers

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 […]

SQL Server Configuration Manager cannot connect to WMI provider fix

SQL Server Configuration Manager cannot connect to WMI provider fix

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 […]

SCCM – 52 Operational Collections

SCCM – 52 Operational Collections

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 […]

SCCM Collection based on Active Directory Organisation Unit (OU) Membership

SCCM Collection based on Active Directory Organisation Unit (OU) Membership

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 […]

Orchestrator Not Showing Newly Created Folders or Runbooks

Orchestrator Not Showing Newly Created Folders or Runbooks

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 […]

SQL Reporting Services Error – Maximum request length exceeded

SQL Reporting Services Error – Maximum request length exceeded

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 […]

Configuration Manager – How to Change the Approve/Deny Status of an Application Catalog Request

Configuration Manager – How to Change the Approve/Deny Status of an Application Catalog Request

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 […]

SCCM Query – Report on Distribution Point Statuses

SCCM Query – Report on Distribution Point Statuses

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 […]

SCCM – Report on Outlook Archive PST files on Devices

SCCM – Report on Outlook Archive PST files on Devices

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 […]

SCCM – WQL Query for Devices with Configuration Manager Client Installed and no System Center Endpoint Protection Installed

SCCM – WQL Query for Devices with Configuration Manager Client Installed and no System Center Endpoint Protection Installed

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 […]

Scroll to top