Hey, Scripting Guy! Quick-Hits Friday: The Scripting Guys Respond to a Bunch of Questions (10/16/09)


Bookmark and Share

In this post:


Has the WMI Problem with Dates and Daylight Saving Time Been Resolved?

Hey, Scripting Guy! Question

Hey, Scripting Guy! Back in the spring, I ran into a problem using the Win32_NTLogEvent WMI class in a script. The problem was the change to daylight saving time (DST) back in March in the United States. After a couple of weeks, the problem corrected itself (when the original DST time was reached), but it was a major pain. Has the situation with incorrect dates being reported via WMI been fixed? I also noticed it seemed to affect the Win32_Process WMI class as well.

— PG

Hey, Scripting Guy! AnswerHello PG,

Scripting Guy Ed Wilson here. I am completely familiar with the problem you describe, as I received several e-mails to scripter@microsoft.com describing the issue with dates and times in the Win32_NTLogEvent WMI class. I contacted the WMI team, and they tell me the problem has been resolved. The hotfix ID is KB 970413. Make sure you get the hotfix installed on all of your servers you will be querying via script.


How Can I Change the Color of Error Messages in the Windows PowerShell Console?

Hey, Scripting Guy! Question

Hey Scripting Guy! The lurid red on black error messages produced by Windows PowerShell are almost unreadable. How can I control the background and text colors of the error messages? I tried using the window properties, but they do not have an effect on this situation. Thanks.

— DM

Hey, Scripting Guy! Answer

Hello DM,

To change the color of the error messages in Windows PowerShell, you need to set a new value for $Host.PrivateData.ErrorForegroundColor. If you query the privatedata property directly, you will see the current settings for the error, warning, debug, and other messages:

PS C:> $Host.PrivateData


ErrorForegroundColor    : Red

ErrorBackgroundColor    : Black

WarningForegroundColor  : Yellow

WarningBackgroundColor  : Black

DebugForegroundColor    : Yellow

DebugBackgroundColor    : Black

VerboseForegroundColor  : Yellow

VerboseBackgroundColor  : Black

ProgressForegroundColor : Yellow

ProgressBackgroundColor : DarkCyan

If you wish to change the value, you assign a new color directly to the value you wish to change. This is seen here:

PS C:> $Host.PrivateData.ErrorForegroundColor = “cyan”

Please note that the change will only work for that particular Windows PowerShell session, so you may want to add the changes to your Windows PowerShell profile.

To determine the colors that are available, you can use the GetNames static method from the System.Enum .NET Framework class. This is seen here:

PS C:> [enum]::GetNames(“System.ConsoleColor”)

















You can also simply supply a bogus value for the systemColor. When this happens, Windows PowerShell will generate an error that contains allowed enumeration values. This technique is seen here:

PS C:> $Host.PrivateData.ErrorForegroundColor = “fusa”

Exception setting “ErrorForegroundColor”: “Cannot convert value “fusa” to type “System.ConsoleColor” due to invalid enumeration values. Specify one of the following enumeration values and try again. The possible enumeration values are “Black, DarkBlue, DarkGreen, DarkCyan, DarkRed, DarkMagenta, DarkYellow, Gray, DarkGray, Blue, Green, Cyan, Red, Magenta, Yellow, White”.”

At line:1 char:19

+ $Host.PrivateData. <<<< ErrorForegroundColor = “fusa”

    + CategoryInfo          : InvalidOperation: (:) [], RuntimeException

    + FullyQualifiedErrorId : PropertyAssignmentException


PS C:>


How Can I Read a Text File and Update 2,000 User Accounts?

Hey, Scripting Guy! Question

Hey, Scripting Guy! We were looking at updating the account expiry date for about 2,000 users; however, we really didn’t want to do this manually. We have a csv/text file of the users and their expiry dates that needs to be set. We have been able to find the VBScript for updating a single user, but this still means manual input for each user. Any help would be greatly appreciated. Here is the script we have:

strExpireDate = “<Date>”

strUserDN = “<UserDN>”


set objUser = GetObject(“LDAP://” & strUserDN) objUser.AccountExpirationDate = strExpireDate objUser.SetInfo WScript.Echo “Set user ” & strUserDN & ” to expire on ” & strExpireDate


‘ These two lines would disable account expiration for the user ‘ objUser.Put “accountExpires”,0 ‘ objUser.SetInfo


— CG

Hey, Scripting Guy! Answer

Hello CG,

You will need to read the CSV file first. To do this, you can use the FileSystemObject, and the ReadLine method. After you have read the line, you will need to use the split function to break up your line. Store the results in the strUserDN variable. A sample script is seen in the TechNet Script Center Gallery.  

You could also use a script similar to this one on the TechNet Script Center Gallery.


Can I Use a WildCard Character for File Names with the FileSystemObject?

Hey, Scripting Guy! Question

Hey, Scripting Guy! Please look at the following script, noting the last line:

    ‘Test Station File Cleaner

‘4/17/09 S Barton
on error resume next
Set fso = CreateObject(“Scripting.FileSystemObject”)
set filesize=fso.GetFile(filename1)
‘wscript.echo filesize.size
If filesize.size >= 1000000 then
fso.deleteFile “c:tunnelerror.log”
end if

set filesize=fso.GetFile(filename2)
‘wscript.echo filesize.size
If filesize.size >= 1000000 then
fso.deleteFile “c:tunneldata.log”
end if


I have been under the impression that the “*” wildcard character will not work in VBScript. Yet in this case, it does. Attached are two samples of the error files it removes. It does not work without the “*” or with the .log extension. This script is on our test stations and is run daily by Task Scheduler. Have I had the wrong impression?

— SB

Hey, Scripting Guy! Answer

Hello SB,

According to MSDN, the DeleteFile method will accept wildcard characters in the last portion of the file path. Therefore, the command seen here will work:


However, when you attempt to use a wildcard character for the first portion of the file name, it does not work. This is seen here:



How Can I Trim Strings That Are Returned from WMI Using Windows PowerShell?

Hey, Scripting Guy! Question

Hey, Scripting Guy! I was looking at one of the Windows Powershell Tips of the Week, but I am having an issue trying to duplicate one of the tips. Perhaps you can shed some light on why I can’t reproduce your results. Go easy on me; I am a total newbie with Windows Powershell. Here is the tip I am talking about:

Bonus Tip: Removing Characters From the Beginning of a String

Consider a folder containing a bunch of files similar to this (a sight familiar to digital camera users):





Suppose you want to remove the HIJK_ prefix from each of these file names. How can you do that? Well, here’s one way, using a string value instead of a file system object and file name property (although the approach is exactly the same):

$d = “HIJK_111112.jpg”

$e = $d.TrimStart(“HIJK_”)

Here is the code I tried, but it is not working for me:

$computer = “LocalHost”

$namespace = “rootCIMV2”

$BIOSVer = Get-WmiObject -class Win32_BIOS | Select SMBIOSBIOSVERSION

$Model = Get-WmiObject win32_computersystem | Select Model

$GX280 = “08”

$GX270 = “07”

$GX260 = “09”

$BIOS = $BIOSVer.TrimStart(“@{SMBIOSBIOSVersion=A”)

$Dell = $Model.TrimStart(“@{Model=OptiPlex “)

IF ($bios -eq $GX280)


write-host “GX280”


elseif ($bios -eq $GX270)


Write-host “2”


elseif ($bios -eq $GX260)


Write-host “3”


The error I am getting is seen here:

Image of error seen by MH

— MH

Hey, Scripting Guy! Answer