Category: SQL


0

SCCM SQL Query – Google Earth Installs

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...

SCCM 0

SCCM SQL Query – Spotify Installations

We have recently been asked to report on Spotify installations within our SCCM environment. The reason is that the IT policies state that users should not be installing Spotify on company machines...

0

SCCM SQL Query – Count Computers by Model

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...

0

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...

0

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 to install the SQL Console Management Tools...

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

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...

SQL Reporting Services Error – Maximum request length exceeded 0

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...

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

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

If you are a Configuration Manager 2012 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...