Re: Generate Computernames in MDT 2010 based on prefix and a sequencenumber

Hi Johan,

Thank you for this one.
Can i use this same procedure for both ZTI & LTI?

Cheers

Re: Generate Computernames in MDT 2010 based on prefix and a sequencenumber

I've setup a full deployment environment following the book guidelines "Deployment Fundamentals - Volume 1" (Arwidmark-Nystrom).

I made only the following change: the bootstrap.ini include only domain name (so username and password are needed to continue). I was able to deploy without problems the images to our test PC. We would like to start the deploy in production environment but I need to generate automaticallyu the name of each PC. For this reason I setup the stored procedure found here but as far as now I was unable to make it work and I even found the reason !

But I cannot fix it; basically the procedure cannot connect to MDT database because it tries to query it using local administrator account (!) instead of the one I've passed at the beginning of deployment (a domain account with privilege over stored procedure). When the OS deployment is finished, in fact, the user logged in is the local administrator (I was expecting instead the domain one used at the begin).

Any ideas ? Why it's using local admin?

These are the errors (found in ZTIGather.log):

Connecting to SQL Server using connect string: Provider=SQLOLEDB;OLE DB Services=0;Data Source=10.6.128.40\SQLEXPRESS;Initial Catalog=MDT;Network Library=DBNMPNTW;Integrated Security=SSPI ZTIGather 28/02/2012 11.24.45 0 (0x0000)
Successfully opened connection to database. ZTIGather 28/02/2012 11.24.46 0 (0x0000)
Only the first MACADDRESS value will be used in the stored procedure call. ZTIGather 28/02/2012 11.24.46 0 (0x0000)
About to issue SQL statement: EXECUTE IdentifyComputer '00:0C:29:D8:3A:4D' ZTIGather 28/02/2012 11.24.46 0 (0x0000)
ERROR - Opening Record Set (Error Number = -2147217887) (Error Description: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.). ZTIGather 28/02/2012 11.24.46 0 (0x0000)
ADO error: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. (Error #-2147217887; Source: Microsoft OLE DB Provider for SQL Server; SQL State: ; NativeError: 0) ZTIGather 28/02/2012 11.24.46 0 (0x0000)
Unable to execute database query. ZTIGather 28/02/2012 11.24.46 0 (0x0000)

Re: Generate Computernames in MDT 2010 based on prefix and a sequencenumber

This is the bootstrap.ini I use; I do not have buildaccount as I've preferred to insert credentials without storing the password in "clear"; could it be the problem ?
________________________________
[Settings]
Priority=Default

[Default]
DeployRoot=\\SERVERNAME\DeploymentShare$

SkipBDDWelcome=YES

UserDomain=MYDOMAIN
UserID=
UserPassword=
______________________________________

Re: Generate Computernames in MDT 2010 based on prefix and a sequencenumber

This is the bootstrap.ini I use; I do not have buildaccount as I've preferred to insert credentials without storing the password in "clear"; could it be the problem ?
________________________________
[Settings]
Priority=Default

[Default]
DeployRoot=\\SERVERNAME\DeploymentShare$

SkipBDDWelcome=YES

UserDomain=MYDOMAIN
UserID=
UserPassword=
______________________________________

Re: Generate Computernames in MDT 2010 based on prefix and a sequencenumber

This is the bootstrap.ini I use; I do not have buildaccount as I've preferred to insert credentials without storing the password in "clear"; could it be the problem ?
________________________________
[Settings]
Priority=Default

[Default]
DeployRoot=\\SERVERNAME\DeploymentShare$

SkipBDDWelcome=YES

UserDomain=MYDOMAIN
UserID=
UserPassword=
______________________________________

Re: Generate Computernames in MDT 2010 based on prefix and a sequencenumber

I'm using an administrative account who have "EXECUTE" permission over stored procedure. However I do not pass it using "bootstrap.ini", could be that the account is used only for join to domain (creating MINIT-XXXXXX) and then lost during the next phases ?

Re: Generate Computernames in MDT 2010 based on prefix and a sequencenumber

I fix a problem with the stored procedure and now it completes without errors as well as the whole deployment process.
Unfortunately the PC name won't be assigned as I expect and it remains in the format MININT-XXXXX.

When will the stored procedure be invoked ? Should I add a custom task in TS to make it work ?

Re: Generate Computernames in MDT 2010 based on prefix and a sequencenumber

I fix a problem with the stored procedure and now it completes without errors as well as the whole deployment process.
Unfortunately the PC name won't be assigned as I expect and it remains in the format MININT-XXXXX.

When will the stored procedure be invoked ? Should I add a custom task in TS to make it work ?

Re: Generate Computernames in MDT 2010 based on prefix and a sequencenumber

Hi Johan, I've been onto this subject for a few weeks and I managed to run the stored procedure successfully. It generates the computer names in the database but the new computer name does not return to the machine being installed. In smstslog it says:
"Successfully queried the database.
Records returned from SQL=1
Value for OSDCOMPUTERNAME is already set to GGN0004 so database value of GGN0016 will be ignored."
What could be wrong here? MDT database didn't have any record about this machine before.

Re: Generate Computernames in MDT 2010 based on prefix and a sequencenumber

Hi Johan, I've been onto this subject for a few weeks and I managed to run the stored procedure successfully. It generates the computer names in the database but the new computer name does not return to the machine being installed. In smstslog it says:
"Successfully queried the database.
Records returned from SQL=1
Value for OSDCOMPUTERNAME is already set to GGN0004 so database value of GGN0016 will be ignored."
What could be wrong here? MDT database didn't have any record about this machine before.

Re: Generate Computernames in MDT 2010 based on prefix and a sequencenumber

Hi Johan, I've been onto this subject for a few weeks and I managed to run the stored procedure successfully. It generates the computer names in the database but the new computer name does not return to the machine being installed. In smstslog it says:
"Successfully queried the database.
Records returned from SQL=1
Value for OSDCOMPUTERNAME is already set to GGN0004 so database value of GGN0016 will be ignored."
What could be wrong here? MDT database didn't have any record about this machine before.

Re: Generate Computernames in MDT 2010 based on prefix and a sequencenumber

https://skydrive.live.com/#cid=D418489FED312C0C&id=D418489FED312C0C%212137

The first gather step in TS is used to get MAC address and IP address of the machine and to display it in my custom hta where end user selects the appropriate department.
The second gather step is used to get the new computer name. After that another hta displays the new assigned computer name for 10 seconds and the TS continues. But the old name is always assigned though the computer's mac is not in the mdt database. (but the computer that is being installed has computer account in AD and SCCM database. The computer is in the OSD collection that I created.)

I don't know what I'm doing wrong but thank you very much for giving me a hand.

Re: Generate Computernames in MDT 2010 based on prefix and a sequencenumber

https://skydrive.live.com/#cid=D418489FED312C0C&id=D418489FED312C0C%212137

The first gather step in TS is used to get MAC address and IP address of the machine and to display it in my custom hta where end user selects the appropriate department.
The second gather step is used to get the new computer name. After that another hta displays the new assigned computer name for 10 seconds and the TS continues. But the old name is always assigned though the computer's mac is not in the mdt database. (but the computer that is being installed has computer account in AD and SCCM database. The computer is in the OSD collection that I created.)

I don't know what I'm doing wrong but thank you very much for giving me a hand.

Re: Generate Computernames in MDT 2010 based on prefix and a sequencenumber

https://skydrive.live.com/#cid=D418489FED312C0C&id=D418489FED312C0C%212137

The first gather step in TS is used to get MAC address and IP address of the machine and to display it in my custom hta where end user selects the appropriate department.
The second gather step is used to get the new computer name. After that another hta displays the new assigned computer name for 10 seconds and the TS continues. But the old name is always assigned though the computer's mac is not in the mdt database. (but the computer that is being installed has computer account in AD and SCCM database. The computer is in the OSD collection that I created.)

I don't know what I'm doing wrong but thank you very much for giving me a hand.

Re: Generate Computernames in MDT 2010 based on prefix and a sequencenumber

Hmm, doing a refresh to see if a new reply has been sent after posting, my browser reposts again!! I'm sorry for the double posts :(

Have you been able to check the logs? I'm still clueless what's going on? If I can't resolve this issue I'll have to find another job :)

Re: Generate Computernames in MDT 2010 based on prefix and a sequencenumber

Thank you very much for the reply. Yes computer has its name assigned (either it's an old computer or a new computer added via computer association in SCCM) before the sql query but I still don't get why it doesn't get overwritten with the new name from sql. Your suggestion is smart, but I don't know how to implement it. If I create a new column in Settings table in MDT database, will that new column's variable be assigned if I create a new TS variable? In that case I should edit the Stored Procedure to update the new column I guess. Any more suggestions Johan? Thank you.

Re: Generate Computernames in MDT 2010 based on prefix and a sequencenumber

I altered the stored procedure so that it inputs the new name to a new column in "settings" table in MDT database. When executed it worked. But I don't know if sql returns that new column's value to the client? Do all the columns' values in "settings" table returned to the client when queried? If so I'm close to the end. Here are the last few line from my stored procedure if it helps.

/* Insert the new record */

INSERT INTO ComputerIdentity (MacAddress)
VALUES (@MacAddress)
INSERT INTO Settings (Type, ID, CustomOSDComputerName, OSDInstallSilent, OSInstall)
VALUES ('C',@@IDENTITY, @NewName, '1', 'Y')

COMMIT TRAN

END

/* Return the record as the result set */

SELECT * FROM ComputerIdentity
WHERE MacAddress = @MacAddress

Re: Generate Computernames in MDT 2010 based on prefix and a sequencenumber

Update: I tried the above method (also created a TS variable like you suggested) but the OSDComputerName variable didn't get its new name from sql. But Sql generates the new name and inputs it in CustomOSDComputerName column. How can we make sql to return this value to the client? Should we alter the last 2 lines in sql stored procedure?
/* Return the record as the result set */

SELECT * FROM ComputerIdentity
WHERE MacAddress = @MacAddress

And how? I'm very sorry for bothering you and sending all these countless posts here :(

Re: Generate Computernames in MDT 2010 based on prefix and a sequencenumber

I don't know what to say... You can't imagine how much you helped someone you don't know. Thank you very very much Johan, it worked. I've been trying to solve this for weeks. Couldn't find any answer anywhere but this site. And it seems to be working now. You rock! ;) Thank you again and again...

Re: Generate Computernames in MDT 2010 based on prefix and a sequencenumber

I installed SQL 2012 with MDT 2012 Update 1. This no longer works. It will pull the computer name if it already exists, but it won't write to the computer name. It will create an entry in the DB with the MAC, ID, Type, and OSInstall columns, but not OSDComputerName or Description.

Any ideas?