Avatar for Andrew Armstrong

Andrew Armstrong

Founder of TechyGeeksHome and Head Editor for over 15 years! IT expert in multiple areas for over 23 years. Sharing experience and knowledge whenever possible! Making IT Happen.

sql2016

SCCM – 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. 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
sql2016

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

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
IElogo

Remove IE MSI

We are pleased to announce the release of our RemoveIE software in an MSI format. This will allow you to distribute the application to a large number of computers using tools such as Group Policy or SCCM. The MSI program is a free download and this does allow you to distribute the software within your…

Read More