‘Alan Kaplan for VA VISN 6 ’11-16-06 ‘This script changes the SA account password on a SQL Database ‘I use the excellent freeware program SQLRecon to get this information, ‘http://www.specialopssecurity.com/labs/sqlrecon/ Option Explicit Const adOpenStatic = 3 Const adLockOptimistic = 3 Dim sqlRS, strDBServer Set sqlRS = CreateObject(“ADODB.Recordset”) Dim message, strPW Dim oCP,oService,strServiceState, strStartType Dim WshShell…
Author: Alan
See https://www.akaplan.com/about/
Windows Easy Transfer Companion (Beta)
When Aloha Bob’s PC Relocator was purchased by Microsoft, I thought it was buried. But it has been finally released. After a recent unpleasant experience with PCMover at $40, I look forward to seeing what this free software will do. “Windows Easy Transfer Companion enables you to automatically transfer your most important programs from your…
How to Manage a DL Using the Search Function
This one drove me crazy. I was made the manager of a distribution list outside my domain. I did not have the permissions to change the group memberships when I tried to do so through Outlook. There is a KB article for this, http://support.microsoft.com/?kbid=318074. My Exchange admin sent me the workaround: Click Start Click…
Check DHCP scopes
Check DHCP This script allows you to dump a list of all leases from DHCP, and to optionally dump only those that do no meet your naming convention. It requires dhcpcmd.exe from the resource kit, you should look at the code for optional edits.
My scripts on cwashington.netreach.net
http://www.google.com/search?q=kaplan++site%3Acwashington.netreach.net
My files on myITForum.com
Not sure why there is no good search function on myITForum.com. I have posted a large number of scripts there: http://www.google.com/search?num=50&q=akaplan+downloads+site%3Amyitforum.com
Hotpatching information – Installing certain patches without rebooting
From our Microsoft TAM: Have you ever wanted to be able to install Microsoft security updates without having to reboot your servers? With Hotpatching, you can do just that for selected updates. Please read on for details. Using Hotpatching Technology to Reduce Servicing Reboots http://technet2.microsoft.com/windowsserver/en/library/8bf7c6e4-3175-43bd-a67a-827ff3a586011033.mspx?mfr=true How to use HotPatching to install security…
Hotfix for Win32_DiskDrive
The hotfix for MSKB 916191, “Windows Management Instrumentation queries do not return any information for the Win32_DiskDrive class or for the Win32_DiskPartition class on a Windows XP-based computer”, also fixes the problem described in my previous post about this issue. See http://support.microsoft.com/default.aspx?scid=kb;en-us;916191
Bug in XP SP2 Win32_DiskDrive
WMI Queries of Win32_DiskDrive for the properties medialoaded and signature are not properly reported for non admin users of Windows XP SP2. This behavior is not seen in Server 2003, and I have not tested it with Vista. I have an open SRX with Microsoft for this issue, but expect to have it closed with…
Yet another Blog
I wanted to be able have an easy way to post scripts, and have a quick way to communicate with my friends and the scripting community. Thanks for reading.