From time to time the need arises to change a Windows product key, the below uses slmgr.vbs to change the Windows product key and activates Windows;

- Open an Administrative Command Prompt

- Enter the command slmgr.vbs /ipk <product key>

- Enter the command slmgr.vbs /ato

If you have a need to find the user accounts present on a linux computer via te shell the below command should help;

cat /etc/passwd | grep "/home" | cut -d: -f1

This will list all users on the computer that have a home directory, you could also run cat /etc/passwd to get more inforation and all kinds of system accounts

To find the version of SUSE or openSUSE and the service pack / patch level installed via the shell run the command;

cat /etc/SuSE-release

You should get an output like the below;

SUSE Linux Enterprise Server 11 (x86_64)
VERSION = 11
PATCHLEVEL = 3
 

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