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 create a collection of active devices.
SQL
Read More
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 as well, then the download link is below: Microsoft SQL Server 2012 Express Download
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
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 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 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
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…
Report AutoCAD Product and Serial Numbers using Configuration Manager
This post is a rehash of an old post we did back in December 2013 but with the recent release of version 2016 of AutoCAD and AutoCAD LT and also the release of our updated code to retrieve the serial numbers from machines for this updated product; we thought that we would slightly update this…
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
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
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
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
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…
Configuration Manager Report Query for Servers not rebooted in the last week
If you want to report on the servers that have not had a reboot in the last week within your Configuration Manager environment then you can run this query directly on your SQL database or you can use it to create a report within SSRS. How to create a Configuration Manager Report using SSRS SQL…
SCCM Report Query for Machines without Client Installed
If you want to report on the machines that do not have the ConfigMgr client installed within your Configuration Manager environment then you can run this query directly on your SQL database or you can use it to create a report within SSRS. How to create a Configuration Manager Report using SSRS The query is…
Configuration Manager Report Query for Client Version
If you want to report on the versions of your ConfigMgr clients that you have within your Configuration Manager environment then you can run this query directly on your SQL database or you can use it to create a report within SSRS. How to create a Configuration Manager Report using SSRS The query is below…
Configuration Manager Report Query for Machine Count by Manufacturer
If you want to report on the number of machines per manufacturer that you have within your Configuration Manager environment then you can run this query directly on your SQL database or you can use it to create a report within SSRS. How to create a Configuration Manager Report using SSRS The query is below…
Configuration Manager Report Query for Server Name and Properties
If you want to report on the server names and properties of those servers that you have within your Configuration Manager environment then you can run this query directly on your SQL database or you can use it to create a report within SSRS. How to create a Configuration Manager Report using SSRS The query…
SCCM Report Query for Machine Make and Model Count
If you want to report on the number of certain makes and models of machines that you have within your Configuration Manager environment then you can run this query directly on your SQL database or you can use it to create a report within SSRS. How to create a Configuration Manager Report using SSRS SQL…
Configuration Manager Report Query for Systems with Torrent Software Installed
If you want to check if any of the client machines within your Configuration Manager network have torrent software installed, you can run this query directly on your SQL database or you can use it to create a report within SSRS. How to create a Configuration Manager Report using SSRS The query is below and…
Report Query for Package Distribution Status on Configuration Manager Distribution Points
If you want to check the distribution status on your Configuration Manager Distribution Points you can run this query directly on your SQL database or you can use it to create a report within SSRS. How to create a Configuration Manager Report using SSRS The query is below and can be altered to fit your…
Configuration Manager SQL Query for Installed Software Per Machine & Per Collection
If you are using Configuration Manager, you will be aware that you can create a number of custom reports using the SQL data and SSRS to produce the reports. The best way to start to create a custom report is to ensure that you get your SQL query correct first. We have written hundreds of…
SCCM – Low Disk Space SQL Query
This is a SQL query for your SCCM database or you can use it to create a report using SSRS. For this work, you must ensure that you have the Logical Disk class enabled in the hardware inventory settings. This will give you the following information: Computer Name Disk Description Drive Letter Volume Name File…
Query for all machines with SQL installed using Installed Software
If you wish to run a SQL query against your SCCM database to find all machines with SQL installed, then you can use this SQL query below: More SQL Queries Our full range of SQL and WQL Collection queries are available here. Feedback If you have any questions or feedback about this post, or if you…
