Skip to main content

Setting Default Application Model Properties Using an SQL Script

AdminStudio 2025 R2 | 30.0 | Application Manager

When a package is imported into the Application Catalog, AdminStudio inserts default values for various Microsoft System Center 2012 Configuration Manager application model properties which cannot be extracted from the imported package.

You can use an SQL script to set these default values. To do this, you just need to update an existing SQL script file (CustomDefaultValues.SQL) and then run that SQL file to update your Application Catalog. The defaults will then be applied to all new packages imported into the Application Catalog.

You can also choose to run the script each time you create a new Application Catalog.

Editing the CustomDefaultValues.SQL Script File​

To specify default values for application model properties, you need to modify the CustomDefaultValues.SQL script file, which can be found in the following location:

    C:\Program Files (x86)\AdminStudio\2025\Support\SQL_Scripts
tip

If you run this script, all of the properties in the script file will be updated. If you want to update just a few of the properties, you can create a script file that only contains a subset of the properties and then run that script.

The following application model properties are defined in the CustomDefaultValues.SQL file:

PropertyValuesSQl Statement to Set Default Value
<MadCap:xref class="GeneralCrossRef" href="ASplatform_Set_ASProperty_1.htm#platformapi_3207111163_1140727">AutoInstall </MadCap:xref>True FalseUPDATE [ASCMProperty] SET [DefaultValue]='True' WHERE Name='AutoInstall'
<MadCap:xref class="GeneralCrossRef" href="ASplatform_Set_ASProperty_1.htm#platformapi_3207111163_1076428">Classification </MadCap:xref>Desktop ServerUPDATE [ASCMProperty] SET [DefaultValue]='Desktop' WHERE Name='Classification'
<MadCap:xref class="GeneralCrossRef" href="ASplatform_Set_ASProperty_1.htm#platformapi_3207111163_1140665">DisplaySupersedes </MadCap:xref>True FalseUPDATE [ASCMProperty] SET [DefaultValue]='False' WHERE Name='DisplaySupersedes'
<MadCap:xref class="GeneralCrossRef" href="ASplatform_Set_ASProperty_1.htm#platformapi_3207111163_1140735">DistributionPriority </MadCap:xref>High Medium LowUPDATE [ASCMProperty] SET [DefaultValue]='Medium' WHERE Name='DistributionPriority'
<MadCap:xref class="GeneralCrossRef" href="ASplatform_Set_ASProperty_1.htm#platformapi_3207111163_1076679">EnforceBehaviour </MadCap:xref>BasedOnExitCode NoAction ProgramReboot ForceRebootUPDATE [ASCMProperty] SET [DefaultValue]='BasedOnExitCode' WHERE Name='EnforceBehaviour' AND [Class] = 'ASCMMsiUserExperience'
<MadCap:xref class="GeneralCrossRef" href="ASplatform_Set_ASProperty_1.htm#platformapi_3207111163_1076702">ExecuteTime </MadCap:xref>Any integer valueUPDATE [ASCMProperty] SET [DefaultValue]='120' WHERE Name='ExecuteTime' AND [Class] = 'ASCMMsiUserExperience'
<MadCap:xref class="GeneralCrossRef" href="ASplatform_Set_ASProperty_1.htm#platformapi_3207111163_1076465">FallbackToUnprotectedDP </MadCap:xref>True FalseUPDATE [ASCMProperty] SET [DefaultValue]='False' WHERE Name='FallbackToUnprotectedDP' AND [Class] = 'ASCMMSIContent'
<MadCap:xref class="GeneralCrossRef" href="ASplatform_Set_ASProperty_1.htm#platformapi_3207111163_1076642">InstallBehaviour </MadCap:xref>User System AnyUPDATE [ASCMProperty] SET [DefaultValue]='System' WHERE Name='InstallBehaviour' AND [Class] = 'ASCMMsiUserExperience'
<MadCap:xref class="GeneralCrossRef" href="ASplatform_Set_ASProperty_1.htm#platformapi_3207111163_1076579">InstallFolder </MadCap:xref>Any string valueUPDATE [ASCMProperty] SET [DefaultValue]='' WHERE Name='InstallFolder' AND [Class] = 'ASCMMsiInstaller'
<MadCap:xref class="GeneralCrossRef" href="ASplatform_Set_ASProperty_1.htm#platformapi_3207111163_1076654">LogonRequirement </MadCap:xref>True Null FalseUPDATE [ASCMProperty] SET [DefaultValue]='Null' WHERE Name='LogonRequirement' AND [Class] = 'ASCMMsiUserExperience'
<MadCap:xref class="GeneralCrossRef" href="ASplatform_Set_ASProperty_1.htm#platformapi_3207111163_1076692">MaxExecuteTime </MadCap:xref>Any integer valueUPDATE [ASCMProperty] SET [DefaultValue]='60' WHERE Name='MaxExecuteTime' AND [Class] = 'ASCMMsiUserExperience'
<MadCap:xref class="GeneralCrossRef" href="ASplatform_Set_ASProperty_1.htm#platformapi_3207111163_1076487">OnFastNetwork </MadCap:xref>Download DownloadContentForStreamingUPDATE [ASCMProperty] SET [DefaultValue]='Download' WHERE Name='OnFastNetwork' AND [Class] = 'ASCMMSIContent'
<MadCap:xref class="GeneralCrossRef" href="ASplatform_Set_ASProperty_1.htm#platformapi_3207111163_1076498">OnSlowNetwork </MadCap:xref>DoNothing Download DownloadContentForStreamingUPDATE [ASCMProperty] SET [DefaultValue]='DoNothing' WHERE Name='OnSlowNetwork' AND [Class] = 'ASCMMSIContent'
<MadCap:xref class="GeneralCrossRef" href="ASplatform_Set_ASProperty_1.htm#platformapi_3207111163_1076511">PeerCache </MadCap:xref>True FalseUPDATE [ASCMProperty] SET [DefaultValue]='True' WHERE Name='PeerCache' AND [Class] = 'ASCMMSIContent' To set the Allow client to share content on the same subnet property (for MSI or Script packages), pass PeerCache as a property name along with MSI/Script package ID. To set the Enable peer-to-peer content distribution property (for an App-V package), pass PeerCache as a property name along with the App-V package ID.
<MadCap:xref class="GeneralCrossRef" href="ASplatform_Set_ASProperty_1.htm#platformapi_3207111163_1076534">PinOnClient </MadCap:xref>True FalseUPDATE [ASCMProperty] SET [DefaultValue]='True' WHERE Name='PinOnClient' AND [Class] = 'ASCMMSIContent'
<MadCap:xref class="GeneralCrossRef" href="ASplatform_Set_ASProperty_1.htm#platformapi_3207111163_1140744">PreferredDistribute </MadCap:xref>True FalseUPDATE [ASCMProperty] SET [DefaultValue]='False' WHERE Name='PreferredDistribute'
<MadCap:xref class="GeneralCrossRef" href="ASplatform_Set_ASProperty_1.htm#platformapi_3207111163_1140821">PrestagedDPSetting </MadCap:xref>Auto OnlyContentChange ManualCopyUPDATE [ASCMProperty] SET [DefaultValue]='ManualCopy' WHERE Name='PrestagedDPSetting'
<MadCap:xref class="GeneralCrossRef" href="ASplatform_Set_ASProperty_1.htm#platformapi_3207111163_1076666">ProgramVisibility </MadCap:xref>Maximized Normal Minimized HiddenUPDATE [ASCMProperty] SET [DefaultValue]='Hidden' WHERE Name='ProgramVisibility' AND [Class] = 'ASCMMsiUserExperience'
<MadCap:xref class="GeneralCrossRef" href="ASplatform_Set_ASProperty_1.htm#platformapi_3207111163_1076546">RequireLoad </MadCap:xref>True FalseUPDATE [ASCMProperty] SET [DefaultValue]='False' WHERE Name='RequireLoad' AND [Class] = 'ASCMMSIContent'
RequiresUserInteractionTrue FalseUPDATE [ASCMProperty] SET [DefaultValue]='False' WHERE Name='RequiresUserInteraction'
<MadCap:xref class="GeneralCrossRef" href="ASplatform_Set_ASProperty_1.htm#platformapi_3207111163_1076609">RunAs32 </MadCap:xref>True FalseUPDATE [ASCMProperty] SET [DefaultValue]='False' WHERE Name='RunAs32' AND [Class] = 'ASCMMsiInstaller'
<MadCap:xref class="GeneralCrossRef" href="ASplatform_Set_ASProperty_1.htm#platformapi_3207111163_1076620">SourceUpdateProductCode </MadCap:xref>Any valid GUIDUPDATE [ASCMProperty] SET [DefaultValue]='' WHERE Name='SourceUpdateProductCode' AND [Class] = 'ASCMMsiInstaller'
<MadCap:xref class="GeneralCrossRef" href="ASplatform_Set_ASProperty_1.htm#platformapi_3207111163_1076589">UninstallCommandLine </MadCap:xref>Any string valueUPDATE [ASCMProperty] SET [DefaultValue]='' WHERE Name='InstallCommandLine' AND [Class] = 'ASCMMsiInstaller'
<MadCap:xref class="GeneralCrossRef" href="ASplatform_Set_ASProperty_1.htm#platformapi_3207111163_1076589">UninstallCommandLine </MadCap:xref>Any string valueUPDATE [ASCMProperty] SET [DefaultValue]='' WHERE Name='UninstallCommandLine' AND [Class] = 'ASCMMsiInstaller'
<MadCap:xref class="GeneralCrossRef" href="ASplatform_Set_ASProperty_1.htm#platformapi_3207111163_1076599">UninstallFolder </MadCap:xref>Any string valueUPDATE [ASCMProperty] SET [DefaultValue]='' WHERE Name='InstallFolder' AND [Class] = 'ASCMMsiInstaller'

Adding the CustomDefaultValues.SQL Script to the Scripts Run During Application Catalog Creation​

When you create a new Application Catalog, the scripts listed in the <Create> section under <AdminStudio> in the Upgrade.xml file are run. The Upgrade.xml file is found in the following location:

C:\Program Files (x86)\AdminStudio\2025\Support

If you want to use an SQL script to set the default Application Model properties for all applications that are imported into a new Application Catalog, you need to add the name of the CustomDefaultValues.SQL file to this script.

To add the CustomDefaultValues.SQL script to the Upgrade.xml file:

  1. Edit the CustomDefaultValues.SQL script file, as described in Editing the CustomDefaultValues.SQL Script File, and copy it to the following location: C:\Program Files (x86)\AdminStudio\2025\Support\SQL_Scripts

  2. Open the following file in a text editor:

    C:\Program Files (x86)\AdminStudio\2025\Support\Upgrade.xml

  3. Locate the <AdminStudio> element in the Upgrade.xml file.

  4. Add the CustomDefaultValues.SQL file to the list of scripts in the <SQLServer> child element of the <Create> element, as highlighted below:

    <AdminStudio>
      <Version version="12.01" target="13286599"/>
      <Create>
        <SQLServer>
          <Script internal="yes">AS_System_Schema.SQL</Script>
          <Script>Seed_Data.SQL</Script>
          
          
          <Script>CustomReportWizard.SQL</Script>
          <Script>AS_TestCenter.sql</Script>
          <Script>AS_TestEngine.sql</Script>
          <Script>Reporting.StoredProcedures.sql</Script>
          <Script>CustomDefaultValues.SQL</Script>
        </SQLServer>
        ...
      </Create>

  5. Save the Upgrade.xml file. The next time you create a new Application Catalog, the CustomDefaultValues.SQL script will be run, setting the default application model properties that you have defined.