Service Manager Database Using High RAM
We recently had a problem with our Service Manager database server using massively high RAM usage. It was using up all the RAM we gave it no matter how much extra we...
Tagged: SQL
SCCM – Report on PST File Locations
Users love to keep their email for as long as they possibly can, but when IT Admins start telling them to archive their email because their mailbox is too big, sometimes things...
SCCM – Active Directory Security Group Query for User Collection
If you are looking at setting up a SCCM user collection based on membership of an Active Directory Security Group, then you can use this WQL query for the collection. WQL Script...
SCCM – SQL Queries for Make, Model and Architectures of Devices
These simple SQL queries can be used to pull data from the Configuration Manager database to provide you with a count of all make, model and architecture devices in your business. Instructions...
SCCM – Create a device collection based on Exchange Server role
Following on from our recent posts for Configuration Manager collection queries, we have another one here for all devices that are Microsoft Exchange servers. Go ahead and create a new device collection...
SCCM – Create a device collection based on Domain Controller role
We have another WQL query here for you today to enable you to create a Configuration Manager collection based on whether a device is used as a domain controller. Go ahead and...
SCCM – Hardware and Client Version SQL Query
If you are looking for a SQL query to pull back hardware inventory information and the SCCM client version, then you can use the below to pull all this information together. SELECT...
SCCM SQL Query for Software not in Add Remove Programs
If you are looking for an SCCM SQL query to create a report to search for machines which do not have a particular software installed, you can use the following: Select Distinct...
SCCM – Differences between Add Remove Programs Database Tables
We had seen a few posts around the internet where people are asking the differences between the various Add_Remove_Programs data within the System Center Configuration Manager database. So we thought we would...
SCCM – SQL Query for all server CPU information
If you are looking for an SQL query to use against your System Center Configuration Manager database to give you the ability to report on server CPU information, this is the query...
SCCM – SQL Query for all Laptops
If you are using Configuration Manager, you will be aware that you can create a number of custom reports using the SCCM SQL data and SSRS to produce the reports. The best...
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...
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...
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 change the last “0” to “1” to...
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: Cannot connect to WMI provider. You do not have permission or the server is unreachable. Note...
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...
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: select SMS_R_System.ResourceId, SMS_R_System.ResourceType, SMS_R_System.Name, SMS_R_System.SMSUniqueIdentifier, SMS_R_System.ResourceDomainORWorkgroup, SMS_R_System.Client from SMS_R_System where...
