How to extend the MDT 2010 database with custom settings

Add a new column to the settings table (can be done with SQL Management Studio)



Give it a name and specify a datatype



Run the following stored procedure against the MDT database

EXECUTE sp_refreshview '[dbo].[ComputerSettings]'
EXECUTE sp_refreshview '[dbo].[LocationSettings]'
EXECUTE sp_refreshview '[dbo].[MakeModelSettings]'
EXECUTE sp_refreshview '[dbo].[RoleSettings]'

Edit the customsettings.ini with the new column

Under the [Settings] section add your column name to the properties line



Now its possible to add a value to the column you added.



To test this run: cscript ZTIGather.wsf /inifile:E:\deployshare\CustomSettings.ini from the scripts directory and point to the customsettings.ini file that is configured with the settings to query the MDT database.





Now we can see that the property CustomCollection002 is set to C0010000


To reference the new value you would use the variable %CustomCollection002%


For more information see the section “Extending the Schema of the MDT DB” in “Using the Microsoft Deployment Toolkit.docx” that can be downloaded here: Optional - MDT 2010 Print-Ready Documentation

Comments (8)
  1. anonymouscommenter says:

    Just what i was looking for.  Saves me reading boring MS manuals!!! LOL

  2. anonymouscommenter says:

    I have setup DB etc. and in Database created a Computer entry with serial and under Make and Model an entry for Model. Problem is that when I run litetouch.vbs the model entry seems to overide the computer serial entry made. (For ex. serial number is of a Dell Optiplex 960 and model entry is Dell Optiplex 960.) Surely serial number should get preferance. When I remove the model entry then query runs all conditions associated with serial?

    How do ensure that if the serial nmber is found that the model query gets disregarded?

  3. anonymouscommenter says:

    You can set the Priority in CustomSettings.ini

  4. anonymouscommenter says:

    Thanks. This helped me in MDT 2013 too

  5. anonymouscommenter says:

    This just resolved an ongoing headache where additional NICs were being applied as Disks during deployment!

  6. anonymouscommenter says:

    I can't figure out for the life of me how I'm supposed to "EXECUTE sp_refreshview '[dbo].[ComputerSettings]'" I tried googling around but I can't find any way to execute that procedure. Microsoft SQL Management Studio will let me execute normal stored
    procedures, but sp_refreshview I can only edit.

  7. Martin Modin says:

    David Zair. Just start a new query in SQL server management studio and make sure you select the MDT database, then you should be able to execute the SP. I’ll update the post with a screenshot.

    1. Adrien says:

      Can you upload the post with screenshot ? i must refresh the mdt database with columns but i dont know how

      Thanks a lot.

Comments are closed.

Skip to main content