Category: Query

sql2016

SCCM – 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. select distinct SMS_R_System.Name, SMS_R_System.ADSiteName, SMS_G_System_X86_PC_MEMORY.TotalPhysicalMemory, SMS_R_System.IPAddresses, SMS_R_System.LastLogonUserName, SMS_R_System.DistinguishedName...

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. select SMS_R_System.Name, SMS_R_System.CreationDate from SMS_R_System where DateDiff(dd,SMS_R_System.CreationDate, GetDate ())...

Get WMI Query v1.4 Released

UPDATE: Get WMI Query v1.5 is now available – click the Downloads button to obtain ================================================================ We are pleased to announce the release of Get WMI Query v1.4 This is an update to the...

Get WMI Query v1.3 Released

UPDATE: Get WMI Query v1.6 is now available – click the Downloads above to grab it now ====================================================================================================== We are pleased to announce the release of Get WMI Query v1.3. This program is designed...

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

sccm

SCCM Collection Queries

We have been building a number of collections within SCCM lately so we thought we would start to build up a reference here of various collections, some simple, some more complex. We...