November 21, 2007
Using Scan Results.txt, you can quickly and effectively get a comprehensive list of the Microsoft patches your servers need with little administrative intervention.
October 10, 2007
Here's a list of LDAP query strings you can create as saved queries in Active Directory Users and Computers.
October 10, 2007
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.
August 15, 2007
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.
June 6, 2007
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.
May 16, 2007
The adage "No pain, no gain" doesn't hold true if you use the All-Info-MultiServer.vbs script to obtain statistics about your Windows servers.
May 9, 2007
CleanDir.js helps you manage the size of your log file folders by making it easy to delete files in a folder and limit a folder's size.
May 2, 2007
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.
March 7, 2007
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.
February 14, 2007
Use the Script component to create a custom script that extends your SSIS package.
February 1, 2007
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.
January 10, 2007
When SSIS’s predefined tasks aren’t enough, use the Script task’s rich environment to create custom code within the control flow of an SSIS package.
January 3, 2007
Use VBScript to script Excel reports and draw on Excel’s formatting features to emphasize key report areas.
Add these Headlines to your Website
