Export Active Directory Lists - updated

Corrected routine to work with any domain. This script uses various small BAT, VBS and EXE utilities. The beauty of this script is the way it reads the top-level members of a group, then process this list, determining which members are users and which ones are nested groups. It writes out the users and expands the nested groups. It then writes out the users and expands and further nested sub-group. Finally, it writes all this out to a TXT file, listing the groups and sub-groups at the top, and users below. The list is sorted and duplicate names are removed to take into account a use belonging to more than one nested list. Use the active directory MMC (View-Advanced Features)to obtain the Canonical name of object. See the readme file. Zipfile 12138ADGroupMembers.zip Readme 10530Readme.doc

excel tips

Handling Excel Errors
VBA: UDF to perform a 3-parameter Vlookup
automate excel 

Tips by Category

Tips By Excel Version

Recommended Tips

Most Viewed Tips Use Windows PowerShell to Automate Microsoft Excel

#This cmdlet picks the servers from workstations.txt one by one, and collects IP details of each server and pushes them #into excel sheet 

MS os tweaks

Windows Services Optimizer

BlackViper

techspot

Tweaking Windows Vista.

Vista Service Guide: Part 1
Vista Service Guide: Part 2
Vista Service Guide: Part 3

tweak vista

tweak xp

Services Guide for Windows XP


Vista Tweaks (All Versions)

Boot Windows XP from a USB flash drive

BadCopy Pro Recover Corrupted or Lost Data

BadCopy Pro Recover Corrupted or Lost Data

WS-Man

WS-Management v1.1 delivers WS-Management functionality on Windows XP SP2, Windows Server 2003 SP1, Windows Server 2003 SP2, Windows 2003 Server R2



WS-Management, From Wikipedia, the free encyclopedi, is a specification of a SOAP-based protocol for the management of servers, devices, applications and more. The specification is based on DMTF open standards and Internet standards for Web Services and was published in March, 2005 by a group of companies, including AMD, Dell, Intel, Microsoft, Sun Microsystems and others.


WS-Management provides a common way for systems to access and exchange management information across the IT infrastructure. The specification is quite rich, supporting much more than get/set of simple variables, and in that it is closer to WBEM or Netconf than to SNMP. A mapping of the DMTF-originated Common Information Model into WS-Management was also defined.



Supported in powershell ctp 2 and beyond




 a Few Good Vista WS-Man (WinRM) Commands

Windows Remote Management

Microsoft Script Editor

If you are on a machine that does not have a professional script editor, like primalScript, you can use the Microsoft Script Editor which is part of office


Search for mse7.exe for its location based on the version of office being used

xp host on esx

install of windows xp pro in esx 3.0, it can't find hard drive
VMware ESX Server guest OS performance tips,

wmi-excel

WMI simplifies system information retrieval
some examples of WMI procedures adapted in Excel
Retrieving hardware information with WMI

Connecting to WMI Objects

Access-Based Enumeration

Access-Based Enumeration techNet mag - hide shares the user doesn't have permission to access

Basically when you have a user connect to a shared folder, and they are browsing within that folder structure, if they don’t have permission to a folder/file then they just don’t see it. Gone are the previous issues of getting access denied messages, followed by helpdesk calls to clarify if they should be allowed in to Folder

This article shows how to use Access-Based Enumeration to hide shared files and folders from network users who are not authorized to access them. This helps prevent footprinting of your network resources and helps ensure the privacy of sensitive information stored on your servers.

How can I enable access-based share enumeration so that users see only files and folders to which they have access?



Windows Server 2003 Access-based Enumeration download

project - exchaneg automation

• create a 15 element samacctIndex array and populate with 0
  
• remove spaces from last name - use regx
  
• combine 1st letter of frist name with revised last name -samacctMain
  
• search 4 all samacctMain
• 4 each samacctMain use regex 2 strip samacctIndex
• put samacctIndex in samacctIndex(samacctIndex) element replacing 0
• search 4 first 0 in samacctIndexarray the element # will become the samacctIndex
• combine samacctMain+samacctIndex = samacctName
• destroy & recreate a 15 element samacctIndex array and populate with 0

admin ou & groups

• get all users with admin loc codes
• ou they're in
• groups they're in
• other qualifiers i.e department responsibility
• look 4 coreolation

HOW TO: Reconnect a mailbox to another user

VBScript to create a large number of mailbox-enabled user accounts

sorting excel data via VBA
sort method doc
Using VBA to Sort Data on Multiple Sheets
Sorting Cells using VBA
subroutine which will sort the active worksheet by first column, then remove any duplicates
re-sorts a named range when data is added

replace a user acct ctrl-F

Sorting a Range using VBA - Excel Help Forum

The Recipient Update Service and Linked Value Replication

Select a Product Advanced SearchHow to work with the Exchange Recipient Update Service

How to Manually Update the Recipient Update Service via script

Creating Exchange Users with Excel (Part 1)

Creating Exchange Users with Excel (Part 2)

exchange Management & Administration Articles

The SelfADSI Tutorial introduces administrators to the scripting in Active Directory environments and other LDAP directory systems. The aim is to understand and being able to develop directory scripts without having specific previous knowledge in ADS or LDAP. Preferred scripting language is Visual Basic Script (VBScript). ADS scripting / LDAP scripting is easy - learn it with SelfADSI.

The minimum attributes needed for RUS are mailNickname (Exchange Alias) and msExchHomeServerName

In this section of the SelfADSI Scripting tutorial the Exchange 2000/Exchange 2003 attributes of an Active Directory Services object will be described. These AD attributes and the additional tabs in the admin utility are only visible if Exchange has been installed in the Active Directory forest and if the according management tools exist on your machine - and if the regarding object is mail enabled.

http://www.microsoft.com/technet/scriptcenter/scripts/message/default.mspx?mfr=true

Alphabetical list of AD attributes

SelfADSI tutorial according "Creating mail enabled users".

A User Comes and a User Goes

http://www.petri.co.il/creating_exchange_users_with_excel.htm



http://msdn.microsoft.com/en-us/library/aa221612(office.11).aspx



http://msdn.microsoft.com/en-us/library/aa221357(office.11).aspx



http://www.ozgrid.com/



http://digiassn.blogspot.com/2006/01/multiple-row-selection-in-excel-vba.html

getting married

http://forums.msexchange.org/m_1800465423/tm.htm

http://forums.msexchange.org/m_180041600/tm.htm

http://forums.msexchange.org/m_1800412283/tm.htm

http://forums.msexchange.org/m_10075700/tm.htm

what is your recipient policy.

Normalizing-Denormalized Tables

Normalizing-Denormalized Tables