Category: SQL


sql2016

SCCM 2012 – WQL Query for machines with 4GB RAM or more

If you have a requirement to identify machines with 4GB RAM or more, then you can use the following WQL query to do this.

You can change the where...

sql2016

SCCM 2012 – WQL Query for devices with specific software installed

If you want to identify machines with a specific piece of software installed, you can utilise the Add/Remove Programs software inventory to do this by using this query.

In...

sql2016

SCCM 2012 – Newly discovered machines in the last 24 hours

If you want to identify machines that have been newly discovered within the last 24 hours, then you have use the query below.

If you want to change the...

sql2016

SCCM 2012 – WQL Query for Machines with less that 1GB RAM

If you need to identify machines within your SCCM environment that have a certain amount of RAM or less, you can use the following WQL query to do this.

...

sql2016

Server Information SQL Query for SCCM

The below SQL query can be used against your SCCM database to return information about your servers. You can edit this query to bring back different information and also use...

sccm

SCCM | WQL Query for devices with Google Earth installed

If you want to identify machines with Google Earth software installed, you can utilise the Add/Remove Programs software inventory to do this by using this query.

This WQL query...

sql2016

SCCM 2012 SP1 CU1 Client Version Queries

With the release of CU1 for System Center, you will notice that your Configuration Manager clients version will have changed to 5.00.7804.1202 from 5.00.7804.1000 If you would like to identify...