Microsoft Evaluation VHD’s – Windows Server 2012 Contoso Administrator Password

Although most people will be using full versions of Windows Server 2012 products by now, some may still use the evaluation VHDs from Microsoft. We have just downloaded all 11GB of VHD files from Microsoft for doing some testing and got to the point where we need to enter the Contoso Administrator password. After trying all the passwords we could …

Microsoft Evaluation VHD’s – Windows Server 2012 Contoso Administrator Password Read More

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 example, we are using “Microsoft …

SCCM – WQL Query for devices with specific software installed Read More

Report on Dell Warranty Statuses for all machines using SCCM & Dell Client Integration Pack

Dell have an excellent tool freely available called Dell Client Integration Pack. Included in this tool is something called Warranty Status. What this part of the tool does is looks at your SCCM SQL database for Dell machines and their asset tags, then checks against its own warranty database for the warranty information. It then inserts all the warranty information into …

Report on Dell Warranty Statuses for all machines using SCCM & Dell Client Integration Pack Read More

Windows 8.1 Dot.Net 3 Feature Enable using Operating System media offline

If you are having trouble in getting the Dot.Net 3 feature to enable on your Windows 8 machine, there is a way that you can do this offline by using DISM and the original Windows 8 media. Instructions Firstly, you sure ensure that you have your original Windows 8 media in your optical drive (or on a USB stick). Then …

Windows 8.1 Dot.Net 3 Feature Enable using Operating System media offline Read More

How to add a custom static page to your blog and not adding it to your menu tabs – Google Blogger

We have recently been asked about how to add a static page to Google Blogger, but not have it added to the menu tabs – whilst keeping other tabs in place. So in essence – how to create a hidden custom page. We use these to give general information on pages without them being added to our menu bar and …

How to add a custom static page to your blog and not adding it to your menu tabs – Google Blogger Read More

SCCM – WQL Query for MAC Address Prompt

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 – Query for devices in a specific Active Directory Organisational Unit (OU)

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

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

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

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

Remove IE MSI Read More

Powershell error when running scripts – scripts disabled

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