System Center Orchestrator – SQL Query to show log file data
If you are using System Center Orchestrator (SCORCH) Runbooks then you may have run into issues where the database is increasing in size due to the large amount of log files being...
Tagged: SQL
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 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...
SQL Server Management Studio (SSMS) 2016 Released
Microsoft have now released SQL Server Management Studio (SSMS) 2016 and is ready to download and use. You can get the download by clicking the button below: Download SSMS 2016 SQL Server Management...
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...
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...
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...
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:
1 2 3 | 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 simple fix for this. All you need to do is to open...
Create a SSRS Report using Configuration Manager Database Data
We have written a number of guides on how to collect client machine data using Configuration Manager 2012 in the past including guides like Autodesk serial number collection, Adobe serial number collection...
SCCM 2012 – WQL Query for machines with specific software installed and version or below
If you need to identify machines with specific software installed on a machine but would also like to know whether they have a certain version of the stated software or below, then...
