Logo
programming4us
programming4us
programming4us
programming4us
Home
programming4us
XP
programming4us
Windows Vista
programming4us
Windows 7
programming4us
Windows Azure
programming4us
Windows Server
programming4us
Windows Phone
 
programming4us
Windows 7

Fine-Tuning MDT Deployments : Working with the MDT Database (part 4) - Extending the MDT Database with Custom Settings

- How To Install Windows Server 2012 On VirtualBox
- How To Bypass Torrent Connection Blocking By Your ISP
- How To Install Actual Facebook App On Kindle Fire
8/7/2013 6:37:39 PM

2.4. Extending the MDT Database with Custom Settings

In addition to working with the default tables and views in the database, you can extend the schema of the MDT database so that you can add custom values. In this scenario, you are going to add the name of an application server that differs for each location, so that you can automatically use this name when you configure the custom application during the installation of the workstation.

Before extending your MDT database, make sure that you have created a backup of the database in case something goes wrong. To create the new ApplicationServer variable, you must add a new column to the settings table called ApplicationServer, which will contain the name of the application server you are going to use in a specific location:

  1. Open SQL Server Management Studio, and in the Object Explorer browse to the MDT database => Tables => dbo.settings => Columns (Figure 5).

  2. Right-click Columns and select New Column.

  3. Type the name of the new column you want to define (in this case, ApplicationServer), select nvarchar(50) as the data type, and make sure that Allow Nulls is selected.

  4. Refresh all views that have a reference to the settings table by running the sp_refreshview stored procedure. You can do this by defining a new query in SQL Server Management Studio that contains the following lines:

    Execute sp_refreshview ComputerSettings
    Execute sp_refreshview LocationSettings
    Execute sp_refreshview MakeMode1Settings
    Execute sp_refreshview Ro1eSettings

  5. Execute this query against the MDT database by clicking "! Execute" on the main toolbar.

  6. You should now have a new option available on the Details tab of your computer settings, in your location settings, in your make and model settings, and in your role settings. Figure 6 details this.

    Figure 5. Microsoft SQL Server Management Studio
    Figure 6. Newly added option ApplicationServer

Next you must provide the name of the application server in the location settings:

  1. Select the Details tab and scroll all the way down to the ApplicationServer setting.

  2. Open the location for which you want to set the ApplicationServer setting.

  3. Modify its value with the name of the application server for that location.

Before you can use the new ApplicationServer value, you need to create a reference in your CustomSettings.ini file so that this value is queried:

  1. Open the CustomSettings.ini file using a text editor and find the Settings section. Find the Properties setting and modify its value from MyCustomProperty to App1icationServer, as follows:

    [Settings]
    Priority=CSettings, CPackages, CApps, CAdmins, CRo1es, Locations, LSettings,
    LPackages, LApps, LAdmins, LRo1es, MMSettings, MMPackages, MMApps, MMAdmins,
    MMRo1es, RSettings, RPackages, RApps, RAdmins, Defau1t
    Properties=App1icationServer
    
    					  

  2. You can now use the %App1icationServer% variable in your MDT task sequence step to install the application, providing %App1icationServer% as an argument for the installation procedure.

Other -----------------
- Fine-Tuning MDT Deployments : Creating a Linked Deployment Share (part 2) - Maintaining Linked Deployment Shares
- Fine-Tuning MDT Deployments : Creating a Linked Deployment Share (part 1) - Understanding Linked Deployment Shares
- Working with the User State Migration Tool (part 5) - Getting Extra Mileage Out of the USMT
- Working with the User State Migration Tool (part 4) - Applying the Data and Settings Using LoadState
- Working with the User State Migration Tool (part 3) - Gathering Data by Running ScanState
- Working with the User State Migration Tool (part 2) - Setting Up the Source Computer
- Working with the User State Migration Tool (part 1) - Using the USMT in Four Deployment Scenarios
- Sharing Your Computer with Others : Join a Homegroup
- Sharing Your Computer with Others : Create a Homegroup
- Sharing Your Computer with Others : Delete an Account
 
 
Top 10
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Finding containers and lists in Visio (part 2) - Wireframes,Legends
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Finding containers and lists in Visio (part 1) - Swimlanes
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Formatting and sizing lists
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Adding shapes to lists
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Sizing containers
- Microsoft Access 2010 : Control Properties and Why to Use Them (part 3) - The Other Properties of a Control
- Microsoft Access 2010 : Control Properties and Why to Use Them (part 2) - The Data Properties of a Control
- Microsoft Access 2010 : Control Properties and Why to Use Them (part 1) - The Format Properties of a Control
- Microsoft Access 2010 : Form Properties and Why Should You Use Them - Working with the Properties Window
- Microsoft Visio 2013 : Using the Organization Chart Wizard with new data
- First look: Apple Watch

- 3 Tips for Maintaining Your Cell Phone Battery (part 1)

- 3 Tips for Maintaining Your Cell Phone Battery (part 2)
programming4us programming4us
Popular tags
Microsoft Access Microsoft Excel Microsoft OneNote Microsoft PowerPoint Microsoft Project Microsoft Visio Microsoft Word Active Directory Biztalk Exchange Server Microsoft LynC Server Microsoft Dynamic Sharepoint Sql Server Windows Server 2008 Windows Server 2012 Windows 7 Windows 8 windows Phone 7 windows Phone 8
programming4us programming4us
 
programming4us
Natural Miscarriage
programming4us
Windows Vista
programming4us
Windows 7
programming4us
Windows Azure
programming4us
Windows Server
programming4us
Game Trailer