SQL Server Magazine

Function Creates Multidimensional Arrays from Delimited Text Files

You don’t have to write a separate routine for text-based processes to arrange data into a usable form—use this VBScript script to create a multidimensional array of the data to reference it by rows and columns like a database.

Function Finds the nth Occurrence of Substrings

Although VBScript offers the InStr and InStrRev functions to find the position of a substring, they only find the position of the substring's first occurrence. If you need to find the position of a different occurrence, you can use the nInStr function.

Simple Saved Queries for Active Directory

Here's a list of LDAP query strings you can create as saved queries in Active Directory Users and Computers.

Using Saved Queries for Active Directory Management

Saved queries let you create, save, and organize queries that you'll use repeatedly for administering AD objects. Learn how to create basic queries with the wizardlike interface and custom queries using LDAP strings for more advanced searches.

Script Scrutinizes SNMP Servers' Security Status

ServerAlerts.vbs checks servers for SNMP security vulnerabilities. It also demonstrates how to add color and hyperlinks to server reports you create in Excel to make problematic servers stand out.

Create Excel Reports the VBScript Way, Part 5

Microsoft Excel's PivotTable feature lets you organize large amounts of data into attractive, focused reports. Walk through the key elements of a PivotTable subroutine and learn how it works.

Create Excel Reports the VBScript Way, Part 4

In part 4 of his Microsoft Excel scripting series, Jim Turner shows how to import delimited and fixed-length text files by using the Excel QueryTables class. He also shows how to write some creative formulas to get around a limitation in Excel.

Keep Tabs on Your Administrative Group Memberships

Here's a script that takes a snapshot of key administrative groups and reports any changes to the membership of those groups.

Create Excel Reports the VBScript Way, Part 2

Together, VBScript and Excel can perform many fundamental routines to make your reports effective. This article explores two routines you can use create charts and link to additional information to make your reporting more comprehensive.

Create Excel Reports the VBScript Way, Part 1

Combining Excel with VBScript scripts puts enormous flexibility and functionality at your fingertips. This first article in a five-part series introduces a useful HTA that you can use to learn how to script Excel reports.

eXLerate Your Scripts

Use VBScript to script Excel reports and draw on Excel’s formatting features to emphasize key report areas.

The Event Log Query Utility

Creating a WMI Moniker: Including the Security Parameter

Don't Let Daylight Saving Time Sneak Up on You

By simply double-clicking GetDLSDates.vbs, you can get a reminder of when daylight saving time begins and ends in the current year. Without having to change any code, this script will work the same year after year.

The Delay Function Extends WSH’s Sleep Method

This user-defined function works like the WScript.Sleep method but wakes the script up early if necessary.

LeapYear Function Might Have You Leaping for Joy

This VBScript function lets you determine whether a given year is a leap year.

A VBScript Version of VBA’s IIf Function

Just like VBA’s built-in IIf function, the VBScript user-defined IIf function evaluates an expression and returns a specific value, depending on whether the expression evaluates to True or False.