http://www.sqlmag.com/authors/author/author/5317830/rss/5317830en-USFri, 25 May 2012 11:05:27 GMTFri, 25 May 2012 11:05:27 GMThttp://www.sqlmag.com/article/vbscript/document-your-domain-groupsJim Turner goes beyond the typical group-listing script, providing an admin script that produces a thorough single-domain listing of all your Active Directory (AD) groups in a nicely formatted, easy-to-read layout.]]>Jim TurnerMon, 28 Dec 2009 00:00:00 GMThttp://www.sqlmag.com/article/vbscript/document-your-domain-groupshttp://www.sqlmag.com/article/security/cyber-threat-scannerYour system has been infected or you need to scan your system to meet security requirements. The Cyber Threat Scanner, a utility that can scan your computer systems at a moment’s notice, is just what you need. ]]>Jim TurnerTue, 24 Nov 2009 00:00:00 GMThttp://www.sqlmag.com/article/security/cyber-threat-scannerhttp://www.sqlmag.com/article/html-application-hta/time-to-round-up-those-scriptsIf you have scripts scattered all over the place on your computer, try ScriptRoundUp.vbs. It locates scripts meeting your criteria, then copies them to a central location so you can back them up and easily find them in the future.]]>Jim TurnerWed, 17 Jun 2009 00:00:00 GMThttp://www.sqlmag.com/article/html-application-hta/time-to-round-up-those-scriptshttp://www.sqlmag.com/article/vbscript/a-refreshing-look-at-cpu-loadsHere’s a script that you can use to quickly check your servers’ CPU loads.]]>Jim TurnerThu, 04 Jun 2009 00:00:00 GMThttp://www.sqlmag.com/article/vbscript/a-refreshing-look-at-cpu-loadshttp://www.sqlmag.com/article/html-application-hta/hta-automatically-creates-mappingsAfter discovering a script that determines and maps the next available drive to a network share, a reader incorporated the script into an HTML Application. With this HTA, you can create persistent or nonpersistent mappings and use alternative credentials.]]>Jim TurnerThu, 14 May 2009 00:00:00 GMThttp://www.sqlmag.com/article/html-application-hta/hta-automatically-creates-mappingshttp://www.sqlmag.com/article/visual-basic-vb/active-directory-growth-tracker-a-script-to-count-objectsLearn how to use this script to track Active Directory objects so you stay current on your AD numbers.]]>Jim TurnerTue, 05 May 2009 00:00:00 GMThttp://www.sqlmag.com/article/visual-basic-vb/active-directory-growth-tracker-a-script-to-count-objectshttp://www.sqlmag.com/article/permissions/utility-can-help-reduce-uac-headaches-when-working-with-scriptsIf User Account Control (UAC) is giving you a hard time when you’re writing or running scripts on Windows Vista or Windows Server 2008, try the Elevate Script HTA. With just a few clicks, you can run .vbs and .js scripts under administrative privileges.]]>Jim TurnerTue, 17 Mar 2009 00:00:00 GMThttp://www.sqlmag.com/article/permissions/utility-can-help-reduce-uac-headaches-when-working-with-scriptshttp://www.sqlmag.com/article/vbscript/scripting-on-a-clusterRunning scripts reliably on a cluster can be challenging. Here’s a solution that’s not only effective but also easy to implement.]]>Jim TurnerTue, 17 Mar 2009 00:00:00 GMThttp://www.sqlmag.com/article/vbscript/scripting-on-a-clusterhttp://www.sqlmag.com/article/html-application-hta/divide-and-conquer-mega-sized-text-and-log-filesWhen a text or log file is so massive that it’s hard to work with, use the Log Splitter utility to split that file into several smaller, more manageable files.]]>Jim TurnerMon, 23 Feb 2009 00:00:00 GMThttp://www.sqlmag.com/article/html-application-hta/divide-and-conquer-mega-sized-text-and-log-fileshttp://www.sqlmag.com/article/html-application-hta/scripting-utilities-to-keep-tabs-on-your-printersTracking changes to printer configurations in a large organization can be very difficult. These two scripts can save you troubleshooting effort by recording changes and letting you compare data from different dates.]]>Jim TurnerTue, 10 Feb 2009 00:00:00 GMThttp://www.sqlmag.com/article/html-application-hta/scripting-utilities-to-keep-tabs-on-your-printershttp://www.sqlmag.com/article/auditing/track-active-directory-changesAuditing changes to Active Directory groups can be a nightmare unless you have third-party software—or this useful script. ]]>Jim TurnerTue, 27 Jan 2009 00:00:00 GMThttp://www.sqlmag.com/article/auditing/track-active-directory-changeshttp://www.sqlmag.com/article/html-application-hta/happy-holiday-htaSend an HTA greeting card that features a holiday tree with blinking multicolored lights and a "Happy Holidays" greeting. You can easily personalize the greeting.]]>Jim TurnerFri, 21 Nov 2008 00:00:00 GMThttp://www.sqlmag.com/article/html-application-hta/happy-holiday-htahttp://www.sqlmag.com/article/vbscript/are-recycle-bins-wasting-a-lot-of-space-on-your-windows-servers-Here’s a VBScript script you can use to monitor how much disk space is being consumed by the Recycle Bins stored in a server’s Recycler folder and how much space is available on that server’s local hard drives.]]>Jim TurnerSat, 01 Nov 2008 00:00:00 GMThttp://www.sqlmag.com/article/vbscript/are-recycle-bins-wasting-a-lot-of-space-on-your-windows-servers-http://www.sqlmag.com/article/permissions/vista-s-uac-can-cause-problems-when-writing-and-running-scriptsWindows Vista’s User Account Control (UAC) can cause problems and annoyances when developing and testing VBScript scripts that require administrator access. Here’s how you can avoid those problems and annoyances without disabling UAC.]]>Jim TurnerSat, 01 Nov 2008 00:00:00 GMThttp://www.sqlmag.com/article/permissions/vista-s-uac-can-cause-problems-when-writing-and-running-scriptshttp://www.sqlmag.com/article/vbscript/build-directory-tree-structure-reportsDocumenting your directory structure provides insight about how your applications and server drives are built and where key components reside.]]>Jim TurnerWed, 24 Sep 2008 00:00:00 GMThttp://www.sqlmag.com/article/vbscript/build-directory-tree-structure-reportshttp://www.sqlmag.com/article/html-application-hta/keep-track-of-and-plan-your-vacation-time-with-the-time-off-plannerAs you enter the vacation time you’re taking off, this HTML Application (HTA) automatically deducts those hours from your vacation-hours balance. It even color-codes the weeks you’re on-call so that you can avoid scheduling time off during those weeks.]]>Jim TurnerWed, 23 Jul 2008 00:00:00 GMThttp://www.sqlmag.com/article/html-application-hta/keep-track-of-and-plan-your-vacation-time-with-the-time-off-plannerhttp://www.sqlmag.com/article/html-application-hta/how-to-easily-view-the-extended-properties-of-filesWindows Server 2008 and Windows Vista have seven times more file properties than their predecessors. Here’s how you can easily select and view the properties you’re interested in seeing, no matter whether you’re using the newest or an older OS.]]>Jim TurnerWed, 16 Jul 2008 00:00:00 GMThttp://www.sqlmag.com/article/html-application-hta/how-to-easily-view-the-extended-properties-of-fileshttp://www.sqlmag.com/article/html-application-hta/determining-the-properties-to-include-in-predefined-categoriesIf you want to create custom categories for GetExtendedFilePropertyDetails.hta, here are some tools you can use to determine the extended file properties available on your system.]]>Jim TurnerWed, 16 Jul 2008 00:00:00 GMThttp://www.sqlmag.com/article/html-application-hta/determining-the-properties-to-include-in-predefined-categorieshttp://www.sqlmag.com/article/vbscript/using-ado-to-access-excel-part-2ADO lets you access your spreadsheets as databases that you can query, sort, search, and modify.]]>Jim TurnerWed, 02 Jul 2008 00:00:00 GMThttp://www.sqlmag.com/article/vbscript/using-ado-to-access-excel-part-2http://www.sqlmag.com/article/vbscript/using-ado-to-access-excel-part-1Use a sample VBScript file to see how you can access Excel spreadsheets with ADO, to filter and modify your data.]]>Jim TurnerWed, 25 Jun 2008 00:00:00 GMThttp://www.sqlmag.com/article/vbscript/using-ado-to-access-excel-part-1