Search the Community
Showing results for tags 'locations'.
-
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 !