Problem

Clients were unable to download updates from our internal WSUS server, the download failed with error 80244019 however the same clients could download the updates fine directly from Microsoft.

Details

Recently I had a need for a tool that would easily allow me or our Service Desk to monitor the health of our XenApp farm, there are obviously commercial products for this but I just needed something simple and free so I created this PowerShell script.

I have been running this on XenApp 6.5.

The script shows,

 - The total number of users logged onto the farm.

As part of a recent Microsoft SQL Server migration project I had a need to disabled and enable all of the Agent Jobs as various points, the below scripts did the job. This scripts have been tested on SQL 2005 to 2012

Disable All Jobs

USE MSDB;
GO
UPDATE MSDB.dbo.sysjobs
SET Enabled = 0
WHERE Enabled = 1;
GO

Enable All Jobs

USE MSDB;
GO
UPDATE MSDB.dbo.sysjobs
SET Enabled = 1
WHERE Enabled = 0;
GO

Problem:

I recently had the need to deploy IBM Client Access 6.1 on a Citrix XenApp 6.5 farm, everything was fine for the first month or so and then users started getting the error "PC5250 License Error CWB0999 Unexpected error: unexpected return code 9052 274d"

I want to share one of my recent finds, I have a Citrix farm that has users logged on 24/7 so scheduling a reboot is difficult. Luckily Dane Young over at itvce.com has created a rolling reboot script that does a great job.

The below query will return a list of none system databases on a Microsoft SQL Server;

SELECT name FROM master..sysdatabases WHERE dbid > 4

Or you can run the below to get a list of databases along with their size and remarks;

EXEC sp_databases

SoftYou can enter the command date to view the current time zone

To change the time zone you need to create a link from the appropriate location under "/usr/share/zoneinfo/.." to "/etc/localtime"

For example;

ln -sf /usr/share/zoneinfo/Europe/London /etc/localtime

If you ever need to change the executable a Windows service points to it can be done easily in the registry.

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\[Name of Service]

To change the location of the exe just change the ImagePath key.

Problem:

When trying to save a PowerPoint file you get a message similar to the below;

In my case I checked the presentation though out and could not find "Courier" in use

Workaround:

Replace the font listed with another font;

In PowerPoint 2003 select Format => Replace Fonts

Problem:

Recently I noticed that clients had not received my changes to my SCCM 2007 software meeting rules, they still had rules that I had previously deleted and they had not received my new rules.

Solution:

After I lot of digging around I found the below error in the policypv.box log on the SCCM server.

CPolicySource::HandleMeteringPolicy: could not retrieve metering rule RULECHG from SQL