Customizing the Text ScreenSaver with Group Policy

screensaver settings

“Customizing screensavers?” I hear you cry, “That’s a bit retro isn’t it?”

Nowadays screensavers have more or less disappeared. It makes much more sense to just turn off the screen after 10 minutes of inactivity. However, there are some instances where a screensaver can be useful, for example, an always-on kiosk or even digital signage.

One of the more useful standard screensavers in the Windows operating system is called “3D Text”. Useful because by default it will display the time but can be customized to display some text instead

Continue reading

Use Group Policy Preferences with WMI Targeting to Copy Files

wmi-lastmodified-1

Here’s a quick and simple guide on how to update a file based on it’s “last modified” date (but it can also be tweaked to use any file attribute). It uses the Item-Level Targeting feature of Group Policy Preferences. The problem is, the Targeting Editor only has a “File Match” option that can check whether a file exists or is of a certain version. Luckily, we can implement a custom WMI query to check any of the files attributes using the CIM_DataFile.

Continue reading

Excel Tip: Apply Conditional Formatting to the whole row

Conditional Formatting Menu in Excel 2013

One of the Microsoft Excel features I use quite a bit is Conditional Formatting. This is the feature (introduced in Excel 2007) that lets you re-colour a cell in your worksheet depending on the criteria you specify, e.g. highlight any cells containing the word “Server 2003″ in red.

The problem I was having was that I wanted the whole row to be highlighted, not just the particular record. It turns out this is fairly easy to do, even though it looks a bit difficult.

Step 1 - Create a new rule

  • The easiest way to start is to select one cell containing the text you want to highlight
  • Click the conditional formatting button on the toolbar and go to Highlight Cell Rules > Text that contains…
  • Format the text how you like, e.g. Light Red Fill with Dark Red Text
  • Click OK

You should now have one cell in your spreadsheet that is formatted how you want

Step 2 – Apply rule to the whole table

  • Click the conditional formatting button on the toolbar and go to Manage Rules…
  • You will see your new rule listed but the Applies to box will only reference one cell e.g. ‘ =$B$2
  • Change the text in the Applies to box to refer to the whole table e.g. ‘ =$A$1:$H$100 ‘
  • Click the Apply button

Now that rule will highlight any matching text in the entire table, not just one cell

Continue reading

The MDT and Office 2013 Click-to-Run Jigsaw Puzzle

office 2013 iconsIf you are trying to deploy a click-to-run (C2R) version of Office 2013/365 then it’s time to forget everything you knew about deploying office and start from a clean slate!

Due to Office 2013′s Cloud-based nature it is set up a bit differently to the traditional CD/MSI approach. This is fine if it’s your personal copy but what about deploying it to an whole office of PCs?

IT pros have been using the Microsoft Installer (MSI) technology for years to silently install Office programs. You can use a mix of existing switches to update and patch Office installations using Group Policy, scripts, Office Customization Tool (OCT) or the Microsoft Deployment Toolkit (MDT).  However, Microsoft, in their wisdom, decided to offer a brand new deployment methodology for Office 2013, Click-To-Run. There is still an MSI version out there but it is only available for the Volume Licensed customers, which means, if your business was used to buying the much cheaper Product Key Card (PKC) licenses, you are stuck with C2R. Oh, and by the way, WSUS can’t be used to update it either.

We came across this issue when we purchased and job lot of PKCs for Office Home and Business 2013. This includes Outlook, Word, Excel, PowerPoint and OneNote. This seems like an ideal buy for most small businesses as it includes all of the core Office apps that your average user would need. However, when it comes to deploying, customising and activating it is about as far from business-ready as you can get! I struggled for weeks trying to get things working correctly to allow a smooth integration with our Windows 7 deployment, I did finally get there, but I hit so many brick walls I almost gave up trying. The worst part is when you get a stock “You should buy Volume Licenses” response… erm yeh, I wish I knew that 3 months ago before the money was spent.

So here is my ultimate guide to installing, customising and activating Office 2013 C2R editions. It’s not going to be pretty but it will get you someway to a mostly automated and controlled deployment. It is specifically tailored towards Office 2013 Home and Business but should work for any Office 2013 C2R version that needs to be deployed in a Windows Domain

Continue reading

Legacy: Silently Install Crystal Reports Viewer 2

File this one under PITA.

As part of our #XPMustDie campaign we sometimes come across old software that simply cannot be updated in time. It’s usually some bespoke system that will take a lot of time and money to re-write or upgrade. In my opinion, it is better to get the OS secure and let an old legacy app run, than to keep a dusty Windows XP PC just for the use of one program. Of course, the ideal solution may be to virtualise the app but if you don’t have the infrastructure in place already then that may be cost-prohibitive or time consuming as well.

One such app we need to use is  Crystal Reports Viewer 2.0. This is completely unsupported by the publisher (SAP) and means it is very difficult to track down files or documentation.

Continue reading

Importing Trusted Certificates onto Legacy Wyse WinTerms

Overview

Root Certificates are used by web browsers to identify a trust with web sites. When root certificates expire, Windows usually auto-updates them (Vista and above) or deploys them through Microsoft Update (Windows XP). The Windows CE 5 operating system on the Wyse 3150 WinTerm (windows terminal) has no automatic way of updating them so they must be imported manually.

We had this situation arise when our remote users complained that they were unable to log on to one of our Citrix Servers. All they would get was an SSL Error 70 message when they tried to load the virtual desktop. Luckily, one of the more up to date terminals gave a more specific error, stating that one of the certificates, from GlobalSign, had expired. So my challenge became to get the latest one imported manually.

Continue reading

2013 Blog Stats in review

The WordPress.com stats helper monkeys prepared a 2013 annual report for this blog. Despite only having 8 new posts I feel like I’ve reconnected with my blog a bit and hopefully will be adding more useful articles on it soon. Thanks for reading :)

Here’s an excerpt:

The Louvre Museum has 8.5 million visitors per year. This blog was viewed about 130,000 times in 2013. If it were an exhibit at the Louvre Museum, it would take about 6 days for that many people to see it.

Click here to see the complete report.

Using Group Policy Preferences to deploy Favorites to Internet Explorer

My previous article, The new way to configure Internet Explorer proxy settings with Group Policy, spoke about how the Internet Explorer Maintenance section of Group Policy has been killed off in favour of ADMX templates and Group Policy Preferences. One benefit of this is that you get rid of the time-consuming “Branding Internet Explorer” section when a user logs on to a PC.

Thanks to the lack of communication from Microsoft, we now need to scramble around to get all of our Internet Explorer Favorites re-deployed for any PC with IE10 or above. Thankfully it is a relatively simple, if tedious task. I used the GPMC on a 2008 R2 member server

Continue reading

The new way to configure Internet Explorer proxy settings with Group Policy

Internet Explorer 10 was released for Windows 7 and Windows Server 2008 R2 machines back in February 2013. Nine months later and we are going through it again with Internet Explorer 11. For SysAdmins and IT Pros managing software updates, these new versions led to quite a significant change in how we use Group Policy to manage them.

I only recently discovered that when Windows 8 (and along with it IE10) was released they finally got rid of the “Internet Explorer Maintenance” Section of the Group Policy Editor. This section always struck me as an odd place to configure IE settings and I’m still not sure why they couldn’t just use the normal Administrative Template section.

Internet Explorer Maintenance in Server 2003 Group Policy Editor
Internet Explorer Maintenance in Server 2003 Group Policy Editor

Continue reading

Freeing up Disk Space on a Windows 8 tablet

Image from Graeme Newcomb, Flickr
Is your hard disk overloaded?

Updated 12/05/2014: Included some new savings that can be made after installing Windows 8.1 Update 1

I love my little Windows 8 HP ElitePad but if I had one major complaint its that I got the one with only 32GB. I knew, from years of maintaining PCs, laptops & netbooks, that the space would quickly be eaten up by Windows Updates alone! In fact, when the ElitePad was brand new out the box it unbelievably only had 11GB free.

I went to upgrade to Windows 8.1 now it has been publically released but discovered that I only had around 750MB free on my c: drive! The Win8.1 Pro download was 2.1GB itself so I had to do some serious freeing up of disk space. Unfortunately, Windows is quite good at hiding this stuff and a lot of online guides make recommend pointless “tips” such as “to save space, flush the DNS cache”!

So here is my guide on several options you have to free up space on your restricted device. Some of them, like removing the recovery partition, are one-offs but others can be repeated whenever space starts to get a bit tight

Continue reading