sql2016
System Center

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

by Andrew Armstrong - Leave a Comment

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 days, however you can just …

SCCM – WQL Query for machines with a valid Hardware Scan in the last x days Read More
sql2016
Guide / System Center

SCCM – WQL Query for MAC Address Prompt

by Andrew Armstrong - Leave a Comment

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 WQL Collection queries are available here. …

SCCM – WQL Query for MAC Address Prompt Read More
sccm logo
Guide / System Center

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

by Andrew Armstrong - 3 Comments.

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 WHERE SMS_R_System.SystemOUName = “TECHYGEEKSHOME/LAB/COMPUTERS/WINDOWS 7” …

SCCM – Query for devices in a specific Active Directory Organisational Unit (OU) Read More
sql2016
Guide / System Center

SCCM – SQL Query for ConfigMgr clients not upgraded to CM2012 (v5)

by Andrew Armstrong - Leave a Comment

This is a query for ConfigMgr 2012 and it will return the machines that do not have the 2012 client installed on them. This is useful if you have gone through an upgrade from 2007 to 2012 and need to know if or where machines have not fully upgraded themselves so that you can take remedial action on them. This …

SCCM – SQL Query for ConfigMgr clients not upgraded to CM2012 (v5) Read More
IElogo
Guide / MSI

Remove IE MSI

by Andrew Armstrong - Leave a Comment

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 own environment to as many …

Remove IE MSI Read More
Close-up of a black video game controller with colorful buttons and a plugged-in cable, focused on the left joystick and directional pad, ideal for playing free games.
Gaming

EA & Need For Speed Rivals – Nothing but problems!

by Andrew Armstrong - Leave a Comment

Recently, I started playing Need for Speeds Rivals on the new Xbox One console. This is a title that I’m very familiar with and have played all versions over the many years of the Need for Speed franchise. However, Rivals has been nothing but a major disappointment – don’t get me wrong, the game itself is brilliant – no complaints …

EA & Need For Speed Rivals – Nothing but problems! Read More
powershell
Guide / Microsoft

Powershell error when running scripts – scripts disabled

by Andrew Armstrong - Leave a Comment

If you are trying to run a Powershell script, you may find sometimes that you get this following error message: Cannot be loaded because the execution of scripts is disabled on this system. There is a very simple fix for this, all you have to do is ensure that you run your Powershell program as administrator to give it elevated …

Powershell error when running scripts – scripts disabled Read More
Server Information SQL Query for SCCM
Guide / System Center

Server Information SQL Query for SCCM

by Andrew Armstrong - Leave a Comment

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 it to create a report using SSRS. This query by default brings back the following information: Query More Queries Our full range of SQL and WQL Collection queries are available here. …

Server Information SQL Query for SCCM Read More
sccm logo
Guide / System Center

SCCM – WQL Query for devices with Google Earth installed

by Andrew Armstrong - 2 Comments.

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 Collection queries are available here. Feedback …

SCCM – WQL Query for devices with Google Earth installed Read More
xbox controller
Gaming / Guide

Xbox One – Need for Speed – Rivals – Car will not move!

by Andrew Armstrong - Leave a Comment

We have had reports of people purchasing Need for Speed: Rivals for their Xbox One and installing the game, starting the tutorial at the beginning and then finding that the car does not move!! A quick fix for this is to completely power off your Xbox One console and start up the game again – this should now work fully …

Xbox One – Need for Speed – Rivals – Car will not move! Read More