Friday, May 27, 2011

Listing all members in an Active Directory group

Is it possible to find out if a user is part of an Active Directory security group?You can use the command line to list all members of an Active Directory group like this:

NET GROUP "group name" /DOMAIN

Alternatively you could also use the dsget command.

Monday, May 23, 2011

The End of Excel

I am truly not the first one to find out that the "end" of Excel…

… is at XFD:1048576

or: 16,384 columns and over one million rows.

Even Excel has an end...

(verified with Excel 2007 and 2010)

Sunday, May 22, 2011

.REG file to turn off the Shutdown Event Tracker

Wha tis the Shutdown Event Tracker?

It's this dialog box:

One of the most annoying dialogs on non-production servers...

Why is there a Shutdown Even Tracker?

Shutdown Event Tracker provides a simple and standard mechanism one can use to consistently document the reasons for shutting down or restarting the computer. This information is used to analyze the root causes of shutdowns and develop a more complete understanding of the system environment.
(Source: Microsoft KB 555541, Author: Soumitra Sengupta, MVP)

How do I enable/disable it?

You can use a registry key or group policies to turn it on/off.

HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Reliability

Name: ShutdownReasonUI
Type: REG_DWORD
Value: 0 = disabled | 1 = enabled

Download .REG file: DisableShutdownEventTracker.reg

Further information: