Jump to content


  • 0
zophar

MDT 2012 - Database - SQL

Question

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 !

Share this post


Link to post
Share on other sites

2 answers to this question

Recommended Posts

  • 0

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

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...


×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.