Generate Computernames in MDT 2010 based on prefix and a sequencenumber

This procedure works like this: If they computername is in the database already (known), it will assign that name to the PC. If the computer is not in the database (unknown), it will generate a computername based on the prefix and the next sequencenumber.

Step 1- Setting up the Database (detailed step-by-step guide & Video tutorial for this step is available for download on www.deploymentcd.com )

1. On the MDT Server (MDT01 in my example), install SQL Server 2008 Express SP1. After installation, enable Named Pipes and restart the service
2. Using the Deployment Workbench, in the advanced node, create a new Database (named MDT in my example)
3. Using SQL Management Studio (Server name is MDT01\SQLEXPRESS), create a Security Login for the domain\user account that you use for your Lite Touch installations
4. For the previously created Security Login, add the following permissions to the MDT Database.
   1. db_datareader
   2. db_datawriter

Step 2 - Add and configure a Stored Procedure + Table for generating computernames based on prefix + sequencenumber

1. Download the files from here... http://www.deployvista.com/Repository/tabid/71/EntryId/59/DMXModule/396/Download/attachment/language/en-US/Default.aspx
2. Using SQL Management Studio, open the InsertComputerNames.sql script and execute it (F5)
3. For the Security Login created in Step 1, grant execute permissions to the IdentifyComputer Stored Procedure (found under Programmability / Stored Procedures)
4. Open the MachineName.sql script and execute it (F5)
5. Edit the MachineNameSequence table, in the prefix field, type in PC, in the sequence field type in 0 (Zero)

Step 3 - Configure the Deployment Share rules

1. Use the info in the sample customsettings.ini file to configure the rules on your deployment share to use the stored procedure

/ Johan