http://www.sqlmag.com/authors/author/author/5648300/rss/5648300en-USFri, 25 May 2012 08:18:21 GMTFri, 25 May 2012 08:18:21 GMThttp://www.sqlmag.com/article/permissions/programmatically-change-permissions-in-print-clustersIf you have to change the permissions on the printers in your print cluster, you don’t have to make those changes manually. PrinterPerms.cmd demonstrates how you can script permission changes.]]>Steve SeguisWed, 26 Sep 2007 00:00:00 GMThttp://www.sqlmag.com/article/permissions/programmatically-change-permissions-in-print-clustershttp://www.sqlmag.com/article/windows-shell-bat-and-cmd/an-uncomplicated-way-to-copy-a-file-using-alternate-credentialsAlthough it might seem like a lot of complicated code will be needed to automate a task, sometimes there’s a simple solution. That’s the case with CopyFile.cmd, which you can use to copy any file to any remote machine.]]>Steve SeguisWed, 18 Jul 2007 00:00:00 GMThttp://www.sqlmag.com/article/windows-shell-bat-and-cmd/an-uncomplicated-way-to-copy-a-file-using-alternate-credentialshttp://www.sqlmag.com/article/vbscript/undocumented-class-lets-you-access-information-about-ie-controlsYou can use the MicrosoftIE_Object class with the root\cimv2\Applications\MicrosoftIE namespace to get the name and status of all the controls and programs that have been downloaded for Internet Explorer on a machine.]]>Steve SeguisWed, 23 May 2007 00:00:00 GMThttp://www.sqlmag.com/article/vbscript/undocumented-class-lets-you-access-information-about-ie-controlshttp://www.sqlmag.com/article/vbscript/an-unkludgy-way-to-back-up-filesA reader created a batch file to back up a database. However, the batch file was a kludge, so he wanted to write a better script. Curious as to how a scripting pro would go about it, he contacted Scripting Pro VIP. The result is BackupFile.vbs.]]>Steve SeguisThu, 17 May 2007 00:00:00 GMThttp://www.sqlmag.com/article/vbscript/an-unkludgy-way-to-back-up-fileshttp://www.sqlmag.com/article/vbscript/an-unkludgy-way-to-back-up-files95677A reader created a batch file to back up a database. However, the batch file was a kludge, so he wanted to write a better script. Curious as to how a scripting pro would go about it, he contacted Scripting Pro VIP. The result is BackupFile.vbs.]]>Steve SeguisWed, 25 Apr 2007 00:00:00 GMThttp://www.sqlmag.com/article/vbscript/an-unkludgy-way-to-back-up-files95677http://www.sqlmag.com/article/dhcp2/create-dhcp-scopesUse the Windows 2003 Netsh command to automatically change network settings, including DHCP configurations.]]>Steve SeguisMon, 08 May 2006 00:00:00 GMThttp://www.sqlmag.com/article/dhcp2/create-dhcp-scopeshttp://www.sqlmag.com/article/migration/capture-printer-data-quicklyNeed to document the printers installed on the your print servers so that you can later recreate it on new servers? Here’s a solution.]]>Steve SeguisMon, 11 Jul 2005 00:00:00 GMThttp://www.sqlmag.com/article/migration/capture-printer-data-quicklyhttp://www.sqlmag.com/article/log-files/gather-failed-logon-attemptsHere’s a way to quickly discover failed Kerberos-related logon attempts on your DCs without having to go to each machine individually.]]>Steve SeguisTue, 10 May 2005 00:00:00 GMThttp://www.sqlmag.com/article/log-files/gather-failed-logon-attemptshttp://www.sqlmag.com/article/task-scheduling/a-new-improved-stab-at-file-ownership-Learn how to determine file ownership without relying on external tools.]]>Steve SeguisTue, 10 May 2005 00:00:00 GMThttp://www.sqlmag.com/article/task-scheduling/a-new-improved-stab-at-file-ownership-http://www.sqlmag.com/article/task-scheduling/manipulating-command-line-parametersLearn how to manipulate variables]]>Steve SeguisTue, 10 May 2005 00:00:00 GMThttp://www.sqlmag.com/article/task-scheduling/manipulating-command-line-parametershttp://www.sqlmag.com/article/ldap/updating-ad-attributes-revisitedThe updateattribs.vbs script gets a makeover by its author. The new version lets you specify usernames instead of DNs as input and uses named parameters.]]>Steve SeguisMon, 11 Apr 2005 00:00:00 GMThttp://www.sqlmag.com/article/ldap/updating-ad-attributes-revisitedhttp://www.sqlmag.com/article/file-management/auditing-file-ownershipDiscover how Ownedby.cmd outputs the name of every file that a specified user has created in a particular directory structure.]]>Steve SeguisThu, 12 Feb 2004 00:00:00 GMThttp://www.sqlmag.com/article/file-management/auditing-file-ownershiphttp://www.sqlmag.com/article/auditing/querying-installed-software-remotelySimplify software audits by easily and quickly querying a registry subkey to display a list of installation applications and hotfixes.]]>Steve SeguisThu, 12 Feb 2004 00:00:00 GMThttp://www.sqlmag.com/article/auditing/querying-installed-software-remotelyhttp://www.sqlmag.com/article/scripting/working-around-ldap-administration-limitsIf your domain holds a large number of users, you might need to use one of these methods to make userstatusrpt.vbs return information about all your user accounts. ]]>Steve SeguisThu, 18 Sep 2003 00:00:00 GMThttp://www.sqlmag.com/article/scripting/working-around-ldap-administration-limitshttp://www.sqlmag.com/article/scripting/reporting-on-user-account-statusA short, simple script shows how to query AD for user account information.]]>Steve SeguisMon, 15 Sep 2003 00:00:00 GMThttp://www.sqlmag.com/article/scripting/reporting-on-user-account-statushttp://www.sqlmag.com/article/active-directory-service-interfaces-adsi/how-to-locate-roaming-usersFinding out who is logged on to a particular computer is fairly easy, but finding out the machine a roaming user is logged to isn’t so easy. Here are two strategies you can use.]]>Steve SeguisMon, 08 Sep 2003 00:00:00 GMThttp://www.sqlmag.com/article/active-directory-service-interfaces-adsi/how-to-locate-roaming-usershttp://www.sqlmag.com/article/active-directory-service-interfaces-adsi/easily-update-ad-attributesYou can create a VBScript script that uses ADSI to update AD according to the values in an Excel spreadsheet. ]]>Steve SeguisMon, 09 Jun 2003 00:00:00 GMThttp://www.sqlmag.com/article/active-directory-service-interfaces-adsi/easily-update-ad-attributeshttp://www.sqlmag.com/article/reporting2/using-excel-to-parse-the-input-fileUse Excel to overcome the shortcomings of CSV files.]]>Steve SeguisMon, 09 Jun 2003 00:00:00 GMThttp://www.sqlmag.com/article/reporting2/using-excel-to-parse-the-input-filehttp://www.sqlmag.com/article/permissions/automatically-audit-access-to-files-and-foldersOver time, permissions on shared files and folders can become unmanageable. Here’s an alternative to manually checking file and folder permissions.]]>Steve SeguisTue, 27 May 2003 00:00:00 GMThttp://www.sqlmag.com/article/permissions/automatically-audit-access-to-files-and-foldershttp://www.sqlmag.com/article/auditing/event-log-auditing-part-2Use this script to generate logon and logoff reports for a particular user for a specified time interval.]]>Steve SeguisTue, 11 Feb 2003 00:00:00 GMThttp://www.sqlmag.com/article/auditing/event-log-auditing-part-2