Situation, i'm about to install MDT 2012 to upgrade our MDT 2010. No the 'problem' is that some off the customsettings features like computername are changed in osdcomputername, some things are deprecated some are new features. So far so good.

I have installed the deploymentshare on to DFS and now i like to customize my settings into SQL, based on locations and gateway.

Here is my customsettings.ini

[Settings]
Priority=Locations, Default
Properties=MyCustomProperty
[Default]
EventService=http://server:9800
[Locations]
SQLServer=server.domain
DBID=user
DBPwd=*****
Instance=MSSQLSERVER
Port=1433
Database=DEV_MDT
Netlib=DBNMPNTW
Table=Locations
Parameters=DefaultGateway

When i check by following url the connection to my DB everything is going well
http://deployment.xt.../tag/ztigather/

This is my ztigather.log, i have filtered out where the sql section
Added new custom property MYCUSTOMPROPERTY
Using from [Settings]: Rule Priority = LOCATIONS, DEFAULT
------ Processing the [LOCATIONS] section ------
Determining the INI file to use.
Using DEFAULT VALUE: Ini file = \\server\CustomSettings.ini
Finished determining the INI file to use.
Using specified INI file = \\%server%\CustomSettings.ini
CHECKING the [LOCATIONS] section
Using from [LOCATIONS]: SQLServer = server.domain
Using from [LOCATIONS]: Instance = MSSQLSERVER
Using from [LOCATIONS]: Port = 1433
Using from [LOCATIONS]: Database = DEV_MDT
Using from [LOCATIONS]: Netlib = DBMSSOCN
Using from [LOCATIONS]: Table = Locations
StoredProcedure key not defined in the section [LOCATIONS]
Using from [LOCATIONS]: DBID = user
Using from [LOCATIONS]: DBPwd = ********
SQLShare key not defined in the section [LOCATIONS]
ParameterCondition key not defined in the section [LOCATIONS]
Default ParameterCondition 'AND' will be used for building queries with multiple parameters.
OPENING STANDARD SECURITY SQL CONNECTION to server server.domain using login user.
< Message containing password has been suppressed>
Successfully opened connection to database.
About to issue SQL statement: SELECT * FROM Locations WHERE DEFAULTGATEWAY IN ('10.4.176.1','fe80::be16:65ff:fe87:d701')
Successfully queried the database.
Records returned from SQL = 1
Property LOCATION001 is now = Test
Added LOCATION value from SQL:  LOCATION = Test
------ Processing the [DEFAULT] section ------
Property SLSHAREDYNAMICLOGGING is now = \\server\SLShareDynamicLogging\%OSDComputername%
Using from [DEFAULT]: SLSHAREDYNAMICLOGGING = \\server\SLShareDynamicLogging\%OSDComputername%
Property EVENTSERVICE is now = http://server:9800
Using from [DEFAULT]: EVENTSERVICE = http://server:9800
------ Done processing \\server\CustomSettings.ini ------



Correct me if i'm wrong but the sql connection is OK, the select statement results OK but he's not processing the rule from Test that are set in the DB.


Can somebody please help me !

Hi,

I think this question might get better support in MDT forum.

http://social.technet.microsoft.com/Forums/en-US/home?forum=mdt

Best Regards,

Joyce Li

hi

I was wondering if anyone knows how to automate the naming process in MDT2012- essentially what I want to do s set up a database (maybe MySQL DBV) pre-stage the computer names and their corresponding Mac address and then use some script to pull these names from the DB allocate it to the corresponding mac address? Is this possible if anyone can help I will be eternally grateful . I look forward to hearing from someone