Category: Query


0

SCCM WQL Query – All Windows 10 Installs

If you are using Configuration Manager and you want to create a collection based on all Windows 10 installations, you can use this WQL query below:

You can change the “%Microsoft Windows NT...

0

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 query below...

0

SCCM WQL Query – No ConfigMgr Client Installed

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:

SCCM 0

SCCM WQL Query – Clients without latest version installed

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:

Where...

0

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...

SCCM 0

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...

SCCM 1

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:

 

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

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...

Configuration Manager Report Query for Machines without Client Installed 0

Configuration Manager 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...

Configuration Manager Report Query for Client Version 0

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...

Configuration Manager Report Query for Machine Count by Manufacturer 0

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...

Configuration Manager Report Query for Server Name and Properties 1

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...