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 […]
Tag: SQL
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 […]
SCCM WQL Query – All Inactive Clients
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 […]
Microsoft SQL Server 2012 Express
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 […]
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 […]
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 […]
SCCM Collection Query – Virtual Machines
If you are looking for a SCCM collection query for virtual machines in your environment, then you can use this query below:
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 […]
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 […]
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 […]
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 […]
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 […]