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

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

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

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

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: