Microsoft System Center Guides & Tutorials

SCCM – WQL Query for devices with specific software installed

17 February 202616 January 2014 by Andrew Armstrong

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. select distinct SMS_R_System.Name, SMS_R_System.OperatingSystemNameandVersion, SMS_R_System.ClientVersion from SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = “Microsoft Office Professional Plus 2010” order by SMS_R_System.Name In this … Read more

SCCM 2012 – Newly discovered machines in the last 24 hours

16 February 202515 January 2014 by Andrew Armstrong

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 ()) <= 1 If you want to change the 24 hours value, then just amend the where value of 1 (this is a day … Read more

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

16 February 202510 January 2014 by Andrew Armstrong

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. SQL Query Code You can change the where value “1024000” to the amount of RAM that you are looking for. More Queries Our full range of … Read more

SCCM – WQL Query for machines with a valid Hardware Scan in the last x days

16 February 20259 January 2014 by Andrew Armstrong

If you would like to identify the machines that have had a valid hardware inventory scan within the last x amount of days, you can use this WQL query as per below. select SMS_R_System.Name, SMS_G_System_WORKSTATION_STATUS.LastHardwareScan from SMS_R_System inner join SMS_G_System_WORKSTATION_STATUS on SMS_G_System_WORKSTATION_STATUS.ResourceId = SMS_R_System.ResourceId where DateDiff(dd,SMS_G_System_WORKSTATION_STATUS.LastHardwareScan,GetDate() ) <= 15 This query is defaulted to 15 … Read more

SCCM – WQL Query for MAC Address Prompt

17 February 20268 January 2014 by Andrew Armstrong

If you would like to search for a machine based upon its MAC address, you can use a WQL query to do this. The WQL query that you should use for this is below: select distinct SMS_R_System.Name, SMS_R_System.MACAddresses from SMS_R_System where SMS_R_System.MACAddresses = ##PRM:SMS_R_System.MACAddresses## order by SMS_R_System.MACAddresses More Queries Our full range of SQL and … Read more

SCCM – Query for devices in a specific Active Directory Organisational Unit (OU)

17 February 20267 January 2014 by Andrew Armstrong

If you are looking for a SCCM query query that will return all machines that are in a specified organisational unit (OU), then you can use this one below. All you need to do is change the demo OU below to your own required OU. Organisational Unit TECHYGEEKSHOME/LAB/COMPUTERS/WINDOWS 10 Query Script SELECT distinct * FROM SMS_R_System … Read more

Uninstalling Google Earth using SCCM

17 February 20262 January 2014 by Andrew Armstrong

Most users in organisations believe that Google Earth is a great tool for their work and freely install it on their work machines and think nothing of it. Well, Google Earth is NOT free for commercial use and if business users want to use Google Earth for work purposes on work machines, then a licence … Read more

SCCM – WQL Query for devices with Google Earth installed

17 February 20261 January 2014 by Andrew Armstrong

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 can then be used as part of an import function to create a device collection within SCCM. More Queries Our full range of SQL and WQL … Read more

Nitro PDF Serial Number Collection using SCCM

17 February 202613 December 2013 by Andrew Armstrong

Sorry but we have been forced to remove this page as NitroPDF believe that we are giving out serial numbers illegally. Although this is just a tutorial for how to gather your OWN PAID FOR serial numbers using SCCM, it seems this is not good enough for NitroPDF or Google. So, we have had to … Read more

SCCM – Create Stand Alone Media using larger capacity memory sticks

17 February 202627 October 2013 by Andrew Armstrong

If you need to create standalone media for any of your task sequences within SCCM, you may find that you have to use a large capacity memory stick. I have found that when I’ve tried to use a 64GB memory stick or above, the Create Stand Alone Media process always fails. So to get round … Read more

CM2012 Console Create Report Fix

16 February 20256 October 2013 by Andrew Armstrong

If you have Configuration Manager 2012 and you are using SQL Reporting, you may want to create some custom reports. In your Configuration Manager 2012 Console, you can browse to Monitoring, then into the Reporting module. This will display all the reports that are currently available to you. If you want to create a custom … Read more

MDT Toolkit speed up during OSD

17 February 20266 October 2013 by Andrew Armstrong

I was recently given a tip on how to speed up the MDT Toolkit Package part when running the Operating System Deployments within my SCCM environment. This is a simple yet effective change that slightly speeds things up if you have MDT integration enabled. The change is turning off a built in setting to delay … Read more