Friday, July 27, 2012

AD User List Query

I found this script on the web some time ago and it's great to dump all of the users out of AD into an Excel file.  I've been asked to do this many times for a variety of reasons.  Just copy this text exactly, place the script on a DC and run.  That's all it takes.


Dim ObjWb
Dim ObjExcel
Dim x, zz
Set objRoot = GetObject("LDAP://RootDSE")
strDNC = objRoot.Get("DefaultNamingContext")
Set objDomain = GetObject("LDAP://" & strDNC) ' Bind to the top of the Domain using LDAP using ROotDSE
Call ExcelSetup("Sheet1") ' Sub to make Excel Document
x = 1
Call enummembers(objDomain)
Sub enumMembers(objDomain)
On Error Resume Next
Dim Secondary(20) ' Variable to store the Array of 2ndary email alias's
For Each objMember In objDomain ' go through the collection

If ObjMember.Class = "user" Then ' if not User object, move on.
x = x +1 ' counter used to increment the cells in Excel

    objwb.Cells(x, 1).Value = objMember.Class
    ' I set AD properties to variables so if needed you could do Null checks or add if/then's to this code
    ' this was done so the script could be modified easier.
SamAccountName = ObjMember.samAccountName
Cn = ObjMember.CN
FirstName = objMember.GivenName
LastName = objMember.sn
initials = objMember.initials
Descrip = objMember.description
Office = objMember.physicalDeliveryOfficeName
Telephone = objMember.telephonenumber
EmailAddr = objMember.mail
WebPage = objMember.wwwHomePage
Addr1 = objMember.streetAddress
City = objMember.l
State = objMember.st
ZipCode = objMember.postalCode
Title = ObjMember.Title
Department = objMember.Department
Company = objMember.Company
Manager = ObjMember.Manager
Profile = objMember.profilePath
LoginScript = objMember.scriptpath
HomeDirectory = ObjMember.HomeDirectory
HomeDrive = ObjMember.homeDrive
AdsPath = Objmember.Adspath
LastLogin = objMember.LastLogin

zz = 1 ' Counter for array of 2ndary email addresses
For each email in ObjMember.proxyAddresses
     If Left (email,5) = "SMTP:" Then
Primary = Mid (email,6) ' if SMTP is all caps, then it's the Primary
     ElseIf Left (email,5) = "smtp:" Then
        Secondary(zz) = Mid (email,6) ' load the list of 2ndary SMTP emails into Array.
        zz = zz + 1
     End If
Next
' Write the values to Excel, using the X counter to increment the rows.

objwb.Cells(x, 2).Value = SamAccountName
objwb.Cells(x, 3).Value = CN
objwb.Cells(x, 4).Value = FirstName
objwb.Cells(x, 5).Value = LastName
objwb.Cells(x, 6).Value = Initials
objwb.Cells(x, 7).Value = Descrip
objwb.Cells(x, 8).Value = Office
objwb.Cells(x, 9).Value = Telephone
objwb.Cells(x, 10).Value = EmailAddr
objwb.Cells(x, 11).Value = WebPage
objwb.Cells(x, 12).Value = Addr1
objwb.Cells(x, 13).Value = City
objwb.Cells(x, 14).Value = State
objwb.Cells(x, 15).Value = ZipCode
objwb.Cells(x, 16).Value = Title
objwb.Cells(x, 17).Value = Department
objwb.Cells(x, 18).Value = Company
objwb.Cells(x, 19).Value = Manager
objwb.Cells(x, 20).Value = Profile
objwb.Cells(x, 21).Value = LoginScript
objwb.Cells(x, 22).Value = HomeDirectory
objwb.Cells(x, 23).Value = HomeDrive
objwb.Cells(x, 24).Value = Adspath
objwb.Cells(x, 25).Value = LastLogin
objwb.Cells(x,26).Value = Primary

' Write out the Array for the 2ndary email addresses.
For ll = 1 To 20
objwb.Cells(x,26+ll).Value = Secondary(ll)
Next
' Blank out Variables in case the next object doesn't have a value for the property
SamAccountName = "-"
Cn = "-"
FirstName = "-"
LastName = "-"
initials = "-"
Descrip = "-"
Office = "-"
Telephone = "-"
EmailAddr = "-"
WebPage = "-"
Addr1 = "-"
City = "-"
State = "-"
ZipCode = "-"
Title = "-"
Department = "-"
Company = "-"
Manager = "-"
Profile = "-"
LoginScript = "-"
HomeDirectory = "-"
HomeDrive = "-"
Primary = "-"
For ll = 1 To 20
Secondary(ll) = ""
Next
    End If
 
    ' If the AD enumeration runs into an OU object, call the Sub again to itinerate
 
    If objMember.Class = "organizationalUnit" or OBjMember.Class = "container" Then
        enumMembers (objMember)
    End If
Next
End Sub
Sub ExcelSetup(shtName) ' This sub creates an Excel worksheet and adds Column heads to the 1st row
Set objExcel = CreateObject("Excel.Application")
Set objwb = objExcel.Workbooks.Add
Set objwb = objExcel.ActiveWorkbook.Worksheets(shtName)
Objwb.Name = "Active Directory Users" ' name the sheet
objwb.Activate
objExcel.Visible = True
objwb.Cells(1, 2).Value = "SamAccountName"
objwb.Cells(1, 3).Value = "CN"
objwb.Cells(1, 4).Value = "FirstName"
objwb.Cells(1, 5).Value = "LastName"
objwb.Cells(1, 6).Value = "Initials"
objwb.Cells(1, 7).Value = "Descrip"
objwb.Cells(1, 8).Value = "Office"
objwb.Cells(1, 9).Value = "Telephone"
objwb.Cells(1, 10).Value = "Email"
objwb.Cells(1, 11).Value = "WebPage"
objwb.Cells(1, 12).Value = "Addr1"
objwb.Cells(1, 13).Value = "City"
objwb.Cells(1, 14).Value = "State"
objwb.Cells(1, 15).Value = "ZipCode"
objwb.Cells(1, 16).Value = "Title"
objwb.Cells(1, 17).Value = "Department"
objwb.Cells(1, 18).Value = "Company"
objwb.Cells(1, 19).Value = "Manager"
objwb.Cells(1, 20).Value = "Profile"
objwb.Cells(1, 21).Value = "LoginScript"
objwb.Cells(1, 22).Value = "HomeDirectory"
objwb.Cells(1, 23).Value = "HomeDrive"
objwb.Cells(1, 24).Value = "Adspath"
objwb.Cells(1, 25).Value = "LastLogin"
objwb.Cells(1, 26).Value = "Primary SMTP"
End Sub
MsgBox "Done" ' show that script is complete 

Monday, July 09, 2012

How to Create a USB install disc from ESXi ISO file.

I had to setup ESXi on some brand new Gen 8 HP ProLiant servers that had two hard drive cages and no optical drive.  Since I never carry a USB optical drive this was the best way to go.

I've outline a few very simple steps below to make your USB key bootable with ESXi so just boot from the USB drive and you're good to go.

Good luck!

1. Download UNetbootin and run the software.  Here are links to the different versions you may need. (Windows – Mac OS X – Linux).

2. Download the VMware vSphere ISO file.  Note to use the newest 5.0.0 update 1 as of this writing. -> VMware Download Center.

3. Start the UNetbootin application and choose Diskimage (ISO) and browse to the downloaded ISO file.  There are several options of top for many operating systems and applications if you happen you want to make one of those as well.

4. Choose Type: USB Drive and choose the correct USB drive letter that you want the bootable installer to be installed to.

5. Let the program run and you are finished.  Make sure you edit the boot sequence in your BIOS (UEFI mode on some systems) to boot from USB instead of CD/DVD-ROM or HDD.

The vSphere 5 documentation can be found online here.

Friday, July 06, 2012

HP Compaq 6200 Pro DownGrade to XP AHCI Driver

I ran into this one recently where a customer wanted to downgrade these new machines to Windows XP since their company currently does not have any plans to migrate from it.  Below are the steps I had to take in order to install Windows XP and then setup the AHCI driver afterwards

The main thing I had to do was to put the SATA controller in IDE mode first in order to get Windows XP to install.  The can be done by pressing ESC or F9 on the PC when it first boots. 

Here is the step by step process to do that:

1. After Windows XP is installed, install the chipset driver first & reboot:

http://h20000.www2.hp.com/bizsupport/TechSupport/S​oftwareDescription.jsp?lang=en&cc=us&prodTypeId=1...

The following steps are used for installing AHCI drivers in Windows XP operating system installed using the IDE mode.

2. Download AHCI driver from the HP Driver site.


3. Right-click the My Computer icon, click Manage, select Device Manager

4. Click the + symbol beside IDE ATA/ATAPI controllers so see all of the hardware devices.

5. You will find the Intel native SATA storage controller driver installed.

6. Right-click  the Serial ATA storage 4 Port controller listed, and click Update Driver .

7. In Welcome to the Hardware Update Wizard, select No, not this time. Click Next .

8. Select Install from a list or specific location (Advanced) . Click Next

9. Select Don't search I will choose the driver to install . Click Next

10. Click Have Disk

11. Click Browse

12. Select location where you saved ACHI drivers.

13. Select iaAHCI.inf

14. Click Open

15. This will list several SATA AHCI Controllers. From this list, select the Intel(R) Desktop/Workstation/Server Express Chipset SATA AHCI Controller. Click Next.

16. The Update Driver Warning will be shown. Click Yes.

17. The driver will install, and completing the Hardware update Wizard appears. Click Finish

18. You can find the updated controller in the device manager.

19. During restart boot to the BIOS setup utility . Go back to your device configurations sub menu and change the SATA Mode back to ACHI, save settings there (F10) and upon exit, save changes and reboot.

Now, the SATA driver is successfully installed and the desktop will boot into Windows with SATA Device Mode set to AHCI.

Thursday, June 21, 2012

Promote 2008 Server Core to a Domain Controller

To promote the server to be a DC in your domain, enter the following command:

Dcpromo /unattend /replicaOrnewDomain:replica
/replicaDomainDNSName:mydomain.local /ConfirmGC:yes
/username:mydomain\administrator /Password:*
/safeModeAdminPassword:LetmeIn123

This will run dcpromo adding the server as a global catalog server to the mydomain.local domain. The Domain restore Mode password will be set to LetMeIn123. You will be asked to enter the domain administrator password when the command is run (by way of the /password:* command)

Allow the process to complete.  Once it does the server will automatically reboot and will be a domain controller.

Wednesday, June 20, 2012

Rename Windows Server 2008 Core

I ran into this today and here's how to do it.  Just don't try this on a domain controller.  This works for a member server only.

To rename the server we use the netdom utility. The command is
Netdom renamecomputer OldComputerName /newname:NewComputerName