SCCM WQL Query – No ConfigMgr Client Installed

ssc 0

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

SCCM WQL Query – Clients without latest version installed

sccm logo

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

SCCM – 52 Operational Collections

sccm logo

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

SCCM – Report on Outlook Archive PST files on Devices

sccm logo 600x400

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

SCCM – WQL Query for Devices with Configuration Manager Client Installed and no System Center Endpoint Protection Installed

sql2016

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

Configuration Manager Report Query for Servers not rebooted in the last week

sccm logo

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

SCCM Report Query for Machines without Client Installed

sql2016

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

Configuration Manager Report Query for Client Version

sql2016

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

Configuration Manager Report Query for Machine Count by Manufacturer

sql2016

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

Configuration Manager Report Query for Server Name and Properties

sql2016

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