MDT 2012 - Database - SQL

[zophar]

Here i'm again.

I'm getting frustrated

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.xtremeconsulting.com/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 !

[zophar]

Anyone ? please

[zophar]

I founded myself ... Maybe a little buggy but here is the solution

 

When you 'Configure Database Rules' and select on the second screen just the option 'Query for location names on default gateways' you get the following extra in CS.ini

 

[Locations]
SQLServer=server.domain
DBID=user
DBPwd=*****
Instance=MSSQLSERVER
Port=1433
Database=DEV_MDT
Netlib=DBNMPNTW
Table=Locations
Parameters=DefaultGateway

 

When you search in the DB the table is not Locations but LocationSettings so CS.ini becomes

 

SQLServer=******
DBID=******
DBPwd=******
Instance=MSSQLSERVER
Port=1433
Database=*****
Netlib=DBMSSOCN
Table=LocationSettings
Parameters=DefaultGateway
SQLShare=*****

 

Working !!!

 

Maybe helpfull