<?xml version="1.0" encoding="UTF-8"?><rss version="2.0"><channel><title>WiseSoft.co.uk articles for IT Professionals</title><link>http://www.wisesoft.co.uk</link><description>Articles for IT Professionals from WiseSoft.co.uk.  Active Directory, Scripting, SQL Server etc.</description><ttl>120</ttl><item><title><![CDATA[ Extract User Data To a CSV File (Inc Terminal Services Attributes)]]> </title><link>http://www.wisesoft.co.uk/scripts/vbscript_extract_user_data_to_a_csv_terminal_services.aspx</link><guid isPermaLink="true">http://www.wisesoft.co.uk/scripts/vbscript_extract_user_data_to_a_csv_terminal_services.aspx</guid><description><![CDATA[ Extract user data from Active Directory as a CSV file.  Handling for terminal services attributes is included. ]]> </description><pubDate>Tue, 17 Nov 2009 19:54:55 GMT</pubDate></item><item><title><![CDATA[ Add all users in OU to Group]]> </title><link>http://www.wisesoft.co.uk/scripts/vbscript_add_all_users_in_ou_to_group.aspx</link><guid isPermaLink="true">http://www.wisesoft.co.uk/scripts/vbscript_add_all_users_in_ou_to_group.aspx</guid><description><![CDATA[ Add all the users from a organizational unit (OU) to a group.  e.g. Add all users from "Developers" OU to "Developers" group.  Could easily be modified to include an additional filter - e.g. Add all users from "Developers" department to "Developers" group. ]]> </description><pubDate>Mon, 30 Mar 2009 19:04:47 GMT</pubDate></item><item><title><![CDATA[ IsMember Functions]]> </title><link>http://www.rlmueller.net/freecode1.htm</link><guid isPermaLink="true">http://www.rlmueller.net/freecode1.htm</guid><description><![CDATA[ A collection of VBScripts for testing Active Directory group membership.  Choose your script based on whether you want to include "nested members" and membership in "primary groups".  A variety of techniques are applied depending on your requirements to achive optimal performance. ]]> </description><pubDate>Mon, 02 Mar 2009 17:25:44 GMT</pubDate></item><item><title><![CDATA[ Move All Users In Department to a Specified OU and Replace Group Membership]]> </title><link>http://www.wisesoft.co.uk/scripts/vbscript_move_all_users_in_department_to_a_specified_ou_and_replace_group_membership.aspx</link><guid isPermaLink="true">http://www.wisesoft.co.uk/scripts/vbscript_move_all_users_in_department_to_a_specified_ou_and_replace_group_membership.aspx</guid><description><![CDATA[ This script will move all the users in the "Marketing" department to the "Marketing" OU.  It will then replace existing group membership with a specified list of groups (ignoring primary group).  See "setup" section for configuration.

EXISTING GROUP MEMBERSHIP WILL BE REPLACED - Please be careful when using this script! ]]> </description><pubDate>Thu, 03 Jul 2008 14:31:47 GMT</pubDate></item><item><title><![CDATA[ Move All Users In Department to a Specified OU]]> </title><link>http://www.wisesoft.co.uk/scripts/vbscript_move_all_users_in_department_to_a_specified_ou.aspx</link><guid isPermaLink="true">http://www.wisesoft.co.uk/scripts/vbscript_move_all_users_in_department_to_a_specified_ou.aspx</guid><description><![CDATA[ This script will move all the users in the "Marketing" department to the "Marketing" OU.  Simply modify the setup section to suite your own requirements. ]]> </description><pubDate>Thu, 03 Jul 2008 13:16:12 GMT</pubDate></item><item><title><![CDATA[ Extract User Data To a CSV File]]> </title><link>http://www.wisesoft.co.uk/scripts/vbscript_extract_user_data_to_csv.aspx</link><guid isPermaLink="true">http://www.wisesoft.co.uk/scripts/vbscript_extract_user_data_to_csv.aspx</guid><description><![CDATA[ Extract user data from Active Directory to a CSV file.  By default all users in the domain will be exported with attributes from the "General" page in ADU&C.  The script is easy to modify if different criteria is required. See the "Setup" section to change criteria. ]]> </description><pubDate>Fri, 18 Apr 2008 14:01:50 GMT</pubDate></item><item><title><![CDATA[ Set a Default Logon Script for All User Accounts]]> </title><link>http://www.wisesoft.co.uk/scripts/vbscript_set_a_default_logon_script_for_all_user_accounts.aspx</link><guid isPermaLink="true">http://www.wisesoft.co.uk/scripts/vbscript_set_a_default_logon_script_for_all_user_accounts.aspx</guid><description><![CDATA[ Updates the "Logon Script" (scriptPath) attribute for all users that do not have a logon script apecified.  This script can easily be changed to modify other attributes. ]]> </description><pubDate>Sun, 09 Mar 2008 12:27:13 GMT</pubDate></item><item><title><![CDATA[ Search for a User with a Specified SAMAccountName]]> </title><link>http://www.wisesoft.co.uk/scripts/powershell_search_for_a_user_with_a_specified_samaccountname.aspx</link><guid isPermaLink="true">http://www.wisesoft.co.uk/scripts/powershell_search_for_a_user_with_a_specified_samaccountname.aspx</guid><description><![CDATA[ Sample script that searches Active Directory for a user with the sAMAccountName kenmyer. The sAMAccountName attribute is replicated to the Global Catalog. This means you can connect to a Global Catalog server and search across the forest for a SAM Account Name.  ]]> </description><pubDate>Tue, 04 Mar 2008 02:31:07 GMT</pubDate></item><item><title><![CDATA[ Search for All Users Who Must Change Their Password On Their Next Logon]]> </title><link>http://www.wisesoft.co.uk/scripts/powershell_search_for_all_users_who_must_change_their_password_on_their_next_logon.aspx</link><guid isPermaLink="true">http://www.wisesoft.co.uk/scripts/powershell_search_for_all_users_who_must_change_their_password_on_their_next_logon.aspx</guid><description><![CDATA[ Sample script that searches Active Directory for all the users who must change their password on their next logon. The pwdLastSet attribute is not replicated to the Global Catalog; you cannot connect to a Global Catalog server and search across the forest for users whose passwords must be reset the next time they log on.  ]]> </description><pubDate>Tue, 04 Mar 2008 02:29:11 GMT</pubDate></item><item><title><![CDATA[ Search for All Users Who Have Remote Access Dial In Permissions]]> </title><link>http://www.wisesoft.co.uk/scripts/powershell_search_for_all_users_who_have_remote_access_dial_in_permissions.aspx</link><guid isPermaLink="true">http://www.wisesoft.co.uk/scripts/powershell_search_for_all_users_who_have_remote_access_dial_in_permissions.aspx</guid><description><![CDATA[ Sample script that searches Active Directory for all the users who have remote access dial-in permissions. The msNPAllowDialin attribute is not replicated to the Global Catalog; you cannot connect to a Global Catalog server and search across the forest for users with remote dial-in permissions. Note that this attribute is not automatically populated any time you create a user account.  ]]> </description><pubDate>Tue, 04 Mar 2008 02:28:10 GMT</pubDate></item><item><title><![CDATA[ Search for All Users Who Have Logged On at Least Once]]> </title><link>http://www.wisesoft.co.uk/scripts/powershell_search_for_all_users_who_have_logged_on_at_least_once.aspx</link><guid isPermaLink="true">http://www.wisesoft.co.uk/scripts/powershell_search_for_all_users_who_have_logged_on_at_least_once.aspx</guid><description><![CDATA[ Sample script that searches Active Directory for all the users who gave logged on to a domain controller at least once. The logonCount attribute is not replicated to the Global Catalog; you cannot connect to a Global Catalog server and search across the forest for users who have logged on a specified number of times. Note that this attribute is not replicated within a domain, either. To determine the number of times a user has logged on, you will have to retrieve this value from each domain controller.  ]]> </description><pubDate>Tue, 04 Mar 2008 02:27:12 GMT</pubDate></item><item><title><![CDATA[ Search for All Users Who Have a Home Directory]]> </title><link>http://www.wisesoft.co.uk/scripts/powershell_search_for_all_users_who_have_a_home_directory.aspx</link><guid isPermaLink="true">http://www.wisesoft.co.uk/scripts/powershell_search_for_all_users_who_have_a_home_directory.aspx</guid><description><![CDATA[ Sample script that searches Active Directory for all the users who have a home directory. The homeDirectory attribute is not replicated to the Global Catalog; you cannot connect to a Global Catalog server and search across the forest for all users who have an assigned home directory. Note that this attribute is not automatically populated any time you create a user account.  ]]> </description><pubDate>Tue, 04 Mar 2008 02:26:12 GMT</pubDate></item><item><title><![CDATA[ Search for All Users in a Specified Office Location]]> </title><link>http://www.wisesoft.co.uk/scripts/powershell_search_for_all_users_in_a_specified_office_location.aspx</link><guid isPermaLink="true">http://www.wisesoft.co.uk/scripts/powershell_search_for_all_users_in_a_specified_office_location.aspx</guid><description><![CDATA[ Sample script that searches Active Directory for all the users in Building 45/1675. The physicalDeliveryOfficeName attribute is not replicated to the Global Catalog; you cannot connect to a Global Catalog server and search across the forest for users from a specific office location. Note that this attribute is not automatically populated any time you create a user account.  ]]> </description><pubDate>Tue, 04 Mar 2008 02:25:21 GMT</pubDate></item><item><title><![CDATA[ Search for All Users in a Specified Company]]> </title><link>http://www.wisesoft.co.uk/scripts/powershell_search_for_all_users_in_a_specified_company.aspx</link><guid isPermaLink="true">http://www.wisesoft.co.uk/scripts/powershell_search_for_all_users_in_a_specified_company.aspx</guid><description><![CDATA[ Sample script that searches Active Directory for all the users in a domain from the Contoso company. The company attribute is not replicated to the Global Catalog; you cannot connect to a Global Catalog server and search across the forest for users from a specified company. Note that this attribute is not automatically populated any time you create a user account.  ]]> </description><pubDate>Tue, 04 Mar 2008 02:24:18 GMT</pubDate></item><item><title><![CDATA[ Search for All Users in a Department]]> </title><link>http://www.wisesoft.co.uk/scripts/powershell_search_for_all_users_in_a_department.aspx</link><guid isPermaLink="true">http://www.wisesoft.co.uk/scripts/powershell_search_for_all_users_in_a_department.aspx</guid><description><![CDATA[ Sample script that searches Active Directory for all the users in the Finance department. The Department attribute is not replicated to the Global Catalog; you cannot connect to a Global Catalog server and search across the forest for users from a specific department. Note that this attribute is not automatically populated any time you create a user account.  ]]> </description><pubDate>Tue, 04 Mar 2008 02:23:03 GMT</pubDate></item><item><title><![CDATA[ Search for All Users Having a Specified Exchange Server]]> </title><link>http://www.wisesoft.co.uk/scripts/powershell_search_for_all_users_having_a_specified_exchange_server.aspx</link><guid isPermaLink="true">http://www.wisesoft.co.uk/scripts/powershell_search_for_all_users_having_a_specified_exchange_server.aspx</guid><description><![CDATA[ Sample script that searches Active Directory for all the users that have the Exchange server o=fabrikam/ou=First Administrative Group/cn=Configuration/cn=Servers/cn=atl-msg-01. The msExchHomeServerName attribute is replicated to the Global Catalog. This means you can connect to a Global Catalog server and search across the forest for users having a specified Exchange server. This attribute is available only if you have installed Microsoft Exchange.  ]]> </description><pubDate>Tue, 04 Mar 2008 02:21:57 GMT</pubDate></item><item><title><![CDATA[ Search for All Users by the Date Their Account was Last Modified]]> </title><link>http://www.wisesoft.co.uk/scripts/powershell_search_for_all_users_by_the_date_their_account_was_last_modified.aspx</link><guid isPermaLink="true">http://www.wisesoft.co.uk/scripts/powershell_search_for_all_users_by_the_date_their_account_was_last_modified.aspx</guid><description><![CDATA[ Sample script that searches Active Directory for all user accounts modified on October 1, 2007 or later. The whenChanged attribute is replicated to the Global Catalog. This means you can connect to a Global Catalog server and search across the forest for users by the date their account was last modified.  ]]> </description><pubDate>Tue, 04 Mar 2008 02:20:42 GMT</pubDate></item><item><title><![CDATA[ Search for All Users by the Date Their Account was Created]]> </title><link>http://www.wisesoft.co.uk/scripts/powershell_search_for_all_users_by_the_date_their_account_was_created.aspx</link><guid isPermaLink="true">http://www.wisesoft.co.uk/scripts/powershell_search_for_all_users_by_the_date_their_account_was_created.aspx</guid><description><![CDATA[ Sample script that searches Active Directory for all user accounts created on October 1, 2007 or later. The whenCreated attribute is replicated to the Global Catalog. This means you can connect to a Global Catalog server and search across the forest for users by the date their account was created.  ]]> </description><pubDate>Tue, 04 Mar 2008 02:19:45 GMT</pubDate></item><item><title><![CDATA[ Search for All Users Whose Passwords Never Expire]]> </title><link>http://www.wisesoft.co.uk/scripts/powershell_search_for_all_users_whose_passwords_never_expire.aspx</link><guid isPermaLink="true">http://www.wisesoft.co.uk/scripts/powershell_search_for_all_users_whose_passwords_never_expire.aspx</guid><description><![CDATA[ Sample script that searches Active Directory for all user account passwords that never expire. The userAccountControl attribute is replicated to the Global Catalog. This means you can connect to a Global Catalog server and search across the forest for all users whose passwords never expire.  ]]> </description><pubDate>Tue, 04 Mar 2008 02:18:22 GMT</pubDate></item><item><title><![CDATA[ Search for All Disabled User Accounts]]> </title><link>http://www.wisesoft.co.uk/scripts/powershell_search_for_all_disabled_user_accounts.aspx</link><guid isPermaLink="true">http://www.wisesoft.co.uk/scripts/powershell_search_for_all_disabled_user_accounts.aspx</guid><description><![CDATA[ Sample script that searches Active Directory for all disabled user accounts. The userAccountControl attribute is replicated to the Global Catalog. This means you can connect to a Global Catalog server and search across the forest for users whose accounts have been disabled.  ]]> </description><pubDate>Tue, 04 Mar 2008 02:17:18 GMT</pubDate></item><item><title><![CDATA[ Search for All Users in a Domain]]> </title><link>http://www.wisesoft.co.uk/scripts/powershell_search_for_all_users_in_a_domain.aspx</link><guid isPermaLink="true">http://www.wisesoft.co.uk/scripts/powershell_search_for_all_users_in_a_domain.aspx</guid><description><![CDATA[ Sample script that searches Active Directory for all the users in a domain. The user objectCategory is replicated to the Global Catalog. This means you can connect to a Global Catalog server and search across the forest for all user accounts.  ]]> </description><pubDate>Tue, 04 Mar 2008 02:15:54 GMT</pubDate></item><item><title><![CDATA[ List All Computer Accounts in Active Directory]]> </title><link>http://www.wisesoft.co.uk/scripts/vbscript_list_all_computer_accounts_in_active_directory.aspx</link><guid isPermaLink="true">http://www.wisesoft.co.uk/scripts/vbscript_list_all_computer_accounts_in_active_directory.aspx</guid><description><![CDATA[ Returns the name and location for all the computer accounts in Active Directory.  ]]> </description><pubDate>Sat, 23 Feb 2008 09:37:24 GMT</pubDate></item><item><title><![CDATA[ Search for Specific Computer Accounts]]> </title><link>http://www.wisesoft.co.uk/scripts/vbscript_search_for_specific_computer_accounts.aspx</link><guid isPermaLink="true">http://www.wisesoft.co.uk/scripts/vbscript_search_for_specific_computer_accounts.aspx</guid><description><![CDATA[ Returns the name and location for all the computers in the domain that are running Windows Server 2003. ]]> </description><pubDate>Sat, 23 Feb 2008 09:32:23 GMT</pubDate></item><item><title><![CDATA[ Groups and Members Report]]> </title><link>http://www.wisesoft.co.uk/scripts/vbscript_groups_and_members_report.aspx</link><guid isPermaLink="true">http://www.wisesoft.co.uk/scripts/vbscript_groups_and_members_report.aspx</guid><description><![CDATA[ Create a CSV Report lising all the groups in the Active Directory domain and all the members of the group.  The csv report will list the group name, group ADsPath, group type (global security/distribution, domain local security/distribution, universal security/distribution, BuiltIn), Member Type (user,group,contact), Member (Name/sAMAccountName) and Member ADsPath. ]]> </description><pubDate>Wed, 13 Feb 2008 17:10:10 GMT</pubDate></item><item><title><![CDATA[ Display Attribute Information]]> </title><link>http://www.wisesoft.co.uk/scripts/vbscript_display_attribute_information.aspx</link><guid isPermaLink="true">http://www.wisesoft.co.uk/scripts/vbscript_display_attribute_information.aspx</guid><description><![CDATA[ Prompt for an attribute name and display information about the attribute by searching the active directory schema. ]]> </description><pubDate>Fri, 15 Sep 2006 09:13:36 GMT</pubDate></item><item><title><![CDATA[ Get the distinguished name (DN) of a Computer]]> </title><link>http://www.wisesoft.co.uk/scripts/vbscript_get_the_distinguished_name_of_a_computer.aspx</link><guid isPermaLink="true">http://www.wisesoft.co.uk/scripts/vbscript_get_the_distinguished_name_of_a_computer.aspx</guid><description><![CDATA[ Get the distinguished name of a computer by specifying the NETBIOS domain name and NETBIOS computer name.  This sample script will get the distinguished name of the current computer. ]]> </description><pubDate>Sun, 20 Aug 2006 13:47:36 GMT</pubDate></item><item><title><![CDATA[ IsMember Function]]> </title><link>http://www.wisesoft.co.uk/scripts/vbscript_ismember_function.aspx</link><guid isPermaLink="true">http://www.wisesoft.co.uk/scripts/vbscript_ismember_function.aspx</guid><description><![CDATA[ Function to test the group membership of a user/computer.  Function accounts for Primary Group membership and nested groups.  A dictionary object is used to make the function efficient for testing group membership in multiple groups. ]]> </description><pubDate>Thu, 17 Aug 2006 15:33:05 GMT</pubDate></item><item><title><![CDATA[ Export Users from Active Directory to Excel]]> </title><link>http://www.wisesoft.co.uk/scripts/vbscript_export_users_from_active_directory_to_excel.aspx</link><guid isPermaLink="true">http://www.wisesoft.co.uk/scripts/vbscript_export_users_from_active_directory_to_excel.aspx</guid><description><![CDATA[ Run a query against your Active Directory domain and save the results in an Excel worksheet. ]]> </description><pubDate>Sun, 13 Aug 2006 07:32:06 GMT</pubDate></item><item><title><![CDATA[ Find Computer's Organizational Unit]]> </title><link>http://www.wisesoft.co.uk/scripts/vbscript_find_computer's_organizational_unit.aspx</link><guid isPermaLink="true">http://www.wisesoft.co.uk/scripts/vbscript_find_computer's_organizational_unit.aspx</guid><description><![CDATA[ Function to find the organizational unit from the name of the computer.  The sample script uses the name of the logged on computer and searches Active Directory for it's OU. ]]> </description><pubDate>Mon, 24 Jul 2006 14:21:49 GMT</pubDate></item><item><title><![CDATA[ List Exchange Mailbox stores]]> </title><link>http://www.wisesoft.co.uk/scripts/vbscript_list_exchange_mailbox_stores.aspx</link><guid isPermaLink="true">http://www.wisesoft.co.uk/scripts/vbscript_list_exchange_mailbox_stores.aspx</guid><description><![CDATA[ Query active directory for a list of exchange mailbox stores. ]]> </description><pubDate>Wed, 14 Jun 2006 15:45:51 GMT</pubDate></item><item><title><![CDATA[ List users with mailbox]]> </title><link>http://www.wisesoft.co.uk/scripts/vbscript_list_users_with_mailbox.aspx</link><guid isPermaLink="true">http://www.wisesoft.co.uk/scripts/vbscript_list_users_with_mailbox.aspx</guid><description><![CDATA[ Creates a CSV file of all the users in the domain that have an Exchange mailbox ]]> </description><pubDate>Sat, 14 Jan 2006 14:32:15 GMT</pubDate></item><item><title><![CDATA[ List Exchange Servers]]> </title><link>http://www.wisesoft.co.uk/scripts/vbscript_list_exchange_servers.aspx</link><guid isPermaLink="true">http://www.wisesoft.co.uk/scripts/vbscript_list_exchange_servers.aspx</guid><description><![CDATA[ Searches Active Directory for a list of exchange servers ]]> </description><pubDate>Sat, 14 Jan 2006 14:21:58 GMT</pubDate></item><item><title><![CDATA[ Export Domain Computer List to CSV]]> </title><link>http://www.wisesoft.co.uk/scripts/vbscript_export_domain_computer_list_to_csv.aspx</link><guid isPermaLink="true">http://www.wisesoft.co.uk/scripts/vbscript_export_domain_computer_list_to_csv.aspx</guid><description><![CDATA[ Creates a csv file of all the computers in the domain, including the operating system, service pack and version. 
 ]]> </description><pubDate>Sat, 14 Jan 2006 14:19:29 GMT</pubDate></item></channel></rss>