Making IT Happen
If you are using Configuration Manager and you want to create a collection of all devices that do not have the Configuration Manager Client installed, then you can use this WQL query: More 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 … Read more
If you want to create a collection in Configuration Manager to show you all the devices that are not up to a specified version, then you can use the WQL 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 SMS_R_System.ClientVersion != “5.00.8412.1007” Where “5.00.8412.1007” is the latest version number that you are … Read more
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. 4,270
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 … Read more
If you are looking for a SCCM collection query for virtual machines in your environment, then you can use this query below: 2,937
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 … Read more
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 … Read more
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 The … Read more
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 … Read more
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 … Read more
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 … Read more
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 … Read more
