none
Custom Field in MDT 2012 Database RRS feed

  • Question

  • Hello,

    I am attempting to add some custom fields into my MDT database and having some issues.  I followed a post that I found telling me how to do this and it seems to have worked.  Here is a link to the post: http://blogs.technet.com/b/mmodin/archive/2010/02/03/how-to-extend-the-mdt-2010-database-with-custom-settings.aspx.  The trouble I have is that I am not able to use the environment variables after I have the fields setup in the database.  

    According to the above link I should be able to run ZTIGather.wsf and see that I have new environment variables for the fields that I setup.  When I do this I see nothing.  This is the part int he post I am talking about:

    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.

     

    Capture5

     

    Capture6

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

    My field names are LegacyComputer and NewComputer.  I am able to assign values to them in the MDT database, however when I run ZTIGather.wsf I see the first part where it says "Added new custom propery LEGACYCOMPUTER" and "Added new custom propery NEWCOMPUTER", but I do not see the second part showing "Property LEGACYCOMPUTER is now = VALUE".  What am I doing wrong and how can I get this issue resolved?


    Wade Preston

    Wednesday, July 10, 2013 3:01 PM

Answers

  • Ok, I just found the problem.  I reestablished the link from MDT to the sql database and that corrected the issue.  This must have went bad when I renamed the MDT share.  Anyhow it is working now.

    Wade Preston

    • Marked as answer by Wade Preston Wednesday, July 10, 2013 8:54 PM
    Wednesday, July 10, 2013 8:54 PM

All replies

  • Can you post your CustomSettings.ini?

    David Coulter | http://DCtheGeek.blogspot.com | @DCtheGeek

    Wednesday, July 10, 2013 3:40 PM
    Answerer
  • Here it is:

    [Settings]
    Priority=CSettings, CPackages, CApps, CAdmins, CRoles, Default,TaskSequenceID,ByLaptopType,ByDesktopType,Model
    Properties=LegacyComputer, NewComputer

    [Default]
    OSInstall=YES
    SkipAdminPassword=YES
    SkipApplications=YES
    SkipAppsOnUpgrade=YES
    SkipBDDWelcome=NO
    SkipBitLocker=YES
    SkipComputerBackup=YES
    ComputerBackupLocation=NONE
    SkipDeploymentType=NO
    DeploymentType=NEWCOMPUTER
    SkipComputerName=YES
    OSDComputerName=%ComputerName%
    SkipDomainMembership=YES
    DomainAdmin=risacct
    DomainAdminDomain=baldwin.corp
    DomainAdminPassword=1@mk!n&
    GPOPackPath=Win7SP1-MDTGPOPackMod

    SkipFinalSummary=YES
    SkipLocaleSelection=YES
    KeyboardLocale=en-US
    UserLocale=en-US
    UILanguage=en-US
    SkipPackageDisplay=NO
    SkipProductKey=YES
    SkipSummary=YES
    SkipTaskSequence=YES
    SkipTimeZone=YES
    TimeZoneName=Central Standard Time
    SkipUserData=YES
    USMT4=YES
    USMT3=NO
    USMTOfflineMigration = True
    UserDataLocation=NETWORK
    UDShare=\\nasserver\Images\USMT\
    UDDir=%ComputerName%
    ScanStateArgs=/v:5 /o /c
    LoadStateArgs=/v:5 /c /lac
    WipeDisk=False
    EventService=http://wdsserver:9800
    WSUSServer=http://wsusserver:8530
    WUMU_ExcludeKB001=KB976002 ;Microsoft Browser Choice Screen Update for EEA
    WUMU_ExcludeKB002=KB2267621 ;Microsoft Security Essentials
    WUMU_ExcludeKB003=KB2434419 ;Windows Live Essentials 2011
    Applications001={b567ef34-aa69-45f6-9fe1-dd62769f8380}
    Applications002={89da45fd-7872-4e67-b819-dd5327334eb4}
    Applications003={e9e4caf1-211f-431c-a135-5cd67056d1f2}
    Applications004={b6dc5f79-f3e2-4c8e-8bd6-25fc013a4397}

    [CSettings]
    SQLServer=wdsserver
    Instance=SQLEXPRESS
    Database=MDT
    Netlib=DBNMPNTW
    SQLShare=NewPC$
    Table=ComputerSettings
    Parameters=UUID, AssetTag, SerialNumber, MacAddress
    ParameterCondition=OR

    [CPackages]
    SQLServer=wdsserver
    Instance=SQLEXPRESS
    Database=MDT
    Netlib=DBNMPNTW
    SQLShare=NewPC$
    Table=ComputerPackages
    Parameters=UUID, AssetTag, SerialNumber, MacAddress
    ParameterCondition=OR
    Order=Sequence

    [CApps]
    SQLServer=wdsserver
    Instance=SQLEXPRESS
    Database=MDT
    Netlib=DBNMPNTW
    SQLShare=NewPC$
    Table=ComputerApplications
    Parameters=UUID, AssetTag, SerialNumber, MacAddress
    ParameterCondition=OR
    Order=Sequence

    [CAdmins]
    SQLServer=wdsserver
    Instance=SQLEXPRESS
    Database=MDT
    Netlib=DBNMPNTW
    SQLShare=NewPC$
    Table=ComputerAdministrators
    Parameters=UUID, AssetTag, SerialNumber, MacAddress
    ParameterCondition=OR

    [CRoles]
    SQLServer=wdsserver
    Instance=SQLEXPRESS
    Database=MDT
    Netlib=DBNMPNTW
    SQLShare=NewPC$
    Table=ComputerRoles
    Parameters=UUID, AssetTag, SerialNumber, MacAddress
    ParameterCondition=OR

    [Latitude E6400]

    [Latitude E6410]

    Latitude E6520]
    Applications001={24de29f5-6c9b-4bdf-9024-e148bb808033}

    [OptiPlex 7010]

    [OptiPlex 745]

    [OptiPlex 755]

    [OptiPlex 780]

    [OptiPlex 790]

    [OptiPlex GX280]

    [OptiPlex GX620]

    [Precision M4300]

    [Precision M6300]

    [Precision M65]

    [Precision M6600]

    [Precision M70]

    [Precision T3600]
    ;64bit nvidia
    Applications001={24de29f5-6c9b-4bdf-9024-e148bb808033}
    ;32bit nvidia
    ;Applications002={92036755-fc44-494e-ade5-ee2ca94f322c}

    [Precision T5600]

    [Precision WorkStation 390]
    Applications001={24de29f5-6c9b-4bdf-9024-e148bb808033}

    [Precision WorkStation T3400]
    Applications001={24de29f5-6c9b-4bdf-9024-e148bb808033}

    [Precision WorkStation T3500]
    Applications001={24de29f5-6c9b-4bdf-9024-e148bb808033}

    [Precision WorkStation T7400]
    Applications001={24de29f5-6c9b-4bdf-9024-e148bb808033}

    [1952AP2]
    ;Lenovo HotKey software
    Applications001={05d6b686-5f6c-4fc0-86fb-a2de7e0d20bc}
    ;Lenovo UNAV software
    Applications002={3dff97c2-550a-440b-b932-8c4e57199420}

    [20823HU]
    ;Lenovo HotKey software
    Applications001={05d6b686-5f6c-4fc0-86fb-a2de7e0d20bc}
    ;Lenovo UNAV software
    Applications002={3dff97c2-550a-440b-b932-8c4e57199420}

    [20828ZU]
    ;Lenovo HotKey software
    Applications001={05d6b686-5f6c-4fc0-86fb-a2de7e0d20bc}
    ;Lenovo UNAV software
    Applications002={3dff97c2-550a-440b-b932-8c4e57199420}

    [2082BKU]
    ;Lenovo HotKey software
    Applications001={05d6b686-5f6c-4fc0-86fb-a2de7e0d20bc}
    ;Lenovo UNAV software
    Applications002={3dff97c2-550a-440b-b932-8c4e57199420}

    [237372U]
    ;Lenovo HotKey software
    Applications001={05d6b686-5f6c-4fc0-86fb-a2de7e0d20bc}
    ;Lenovo UNAV software
    Applications002={3dff97c2-550a-440b-b932-8c4e57199420}

    [2378R4U]
    ;Lenovo HotKey software
    Applications001={05d6b686-5f6c-4fc0-86fb-a2de7e0d20bc}
    ;Lenovo UNAV software
    Applications002={3dff97c2-550a-440b-b932-8c4e57199420}

    [2378RGU]
    ;Lenovo HotKey software
    Applications001={05d6b686-5f6c-4fc0-86fb-a2de7e0d20bc}
    ;Lenovo UNAV software
    Applications002={3dff97c2-550a-440b-b932-8c4e57199420}

    [2623D4U]
    ;Lenovo HotKey software
    Applications001={05d6b686-5f6c-4fc0-86fb-a2de7e0d20bc}
    ;Lenovo UNAV software
    Applications002={3dff97c2-550a-440b-b932-8c4e57199420}

    [2652C3U]
    ;Lenovo HotKey software
    Applications001={05d6b686-5f6c-4fc0-86fb-a2de7e0d20bc}
    ;Lenovo UNAV software
    Applications002={3dff97c2-550a-440b-b932-8c4e57199420}

    [2652PBU]
    ;Lenovo HotKey software
    Applications001={05d6b686-5f6c-4fc0-86fb-a2de7e0d20bc}
    ;Lenovo UNAV software
    Applications002={3dff97c2-550a-440b-b932-8c4e57199420}

    [2901CTO]
    ;Lenovo HotKey software
    Applications001={05d6b686-5f6c-4fc0-86fb-a2de7e0d20bc}
    ;Lenovo UNAV software
    Applications002={3dff97c2-550a-440b-b932-8c4e57199420}

    [417032U]
    ;Lenovo HotKey software
    Applications001={05d6b686-5f6c-4fc0-86fb-a2de7e0d20bc}
    ;Lenovo UNAV software
    Applications002={3dff97c2-550a-440b-b932-8c4e57199420}

    [43147NU]
    ;Lenovo HotKey software
    Applications001={05d6b686-5f6c-4fc0-86fb-a2de7e0d20bc}
    ;Lenovo UNAV software
    Applications002={3dff97c2-550a-440b-b932-8c4e57199420}

    [6371E5U]
    ;Lenovo HotKey software
    Applications001={05d6b686-5f6c-4fc0-86fb-a2de7e0d20bc}
    ;Lenovo UNAV software
    Applications002={3dff97c2-550a-440b-b932-8c4e57199420}

    [64607EU]
    ;Lenovo HotKey software
    Applications001={05d6b686-5f6c-4fc0-86fb-a2de7e0d20bc}
    ;Lenovo UNAV software
    Applications002={3dff97c2-550a-440b-b932-8c4e57199420}

    [6460DWU]
    ;Lenovo HotKey software
    Applications001={05d6b686-5f6c-4fc0-86fb-a2de7e0d20bc}
    ;Lenovo UNAV software
    Applications002={3dff97c2-550a-440b-b932-8c4e57199420}

    [8741W3Y]
    ;Lenovo HotKey software
    Applications001={05d6b686-5f6c-4fc0-86fb-a2de7e0d20bc}
    ;Lenovo UNAV software
    Applications002={3dff97c2-550a-440b-b932-8c4e57199420}

    [87445BU]
    ;Lenovo HotKey software
    Applications001={05d6b686-5f6c-4fc0-86fb-a2de7e0d20bc}
    ;Lenovo UNAV software
    Applications002={3dff97c2-550a-440b-b932-8c4e57199420}

    [23539LU]
    ;Lenovo HotKey software
    Applications001={05d6b686-5f6c-4fc0-86fb-a2de7e0d20bc}
    ;Lenovo UNAV software
    Applications002={3dff97c2-550a-440b-b932-8c4e57199420}

    [2320HQU]
    ;Lenovo Sierra Wireless QMI Driver Package
    Applications001={8dc2f433-a8a3-40db-980c-cdb1c57caddd}
    ;Lenovo HotKey software
    Applications002={05d6b686-5f6c-4fc0-86fb-a2de7e0d20bc}
    ;Lenovo UNAV software
    Applications003={3dff97c2-550a-440b-b932-8c4e57199420}



    Wade Preston


    • Edited by Wade Preston Wednesday, July 10, 2013 5:41 PM error in name
    Wednesday, July 10, 2013 4:29 PM
  • Ok, I just found the problem.  I reestablished the link from MDT to the sql database and that corrected the issue.  This must have went bad when I renamed the MDT share.  Anyhow it is working now.

    Wade Preston

    • Marked as answer by Wade Preston Wednesday, July 10, 2013 8:54 PM
    Wednesday, July 10, 2013 8:54 PM