SIF Offline Prerequisites 9.3

Prerequisites-offline.json

{
    "Parameters": {
        "ComponentBasedServicing": {
            "Type": "String",
            "Description": "Registry location of component based servicing reboot pending key.",
            "DefaultValue": "HKLM:SOFTWARE\\Microsoft\\Windows\\CurrentVersion\\Component Based Servicing\\RebootPending"
        },
        "DotNet4RegistryLocation": {
            "Type": "String",
            "Description": "Registry location of .net4 release key",
            "DefaultValue": "HKLM:SOFTWARE\\Microsoft\\NET Framework Setup\\NDP\\v4\\Full"
        },
        "VisualCPP2015x64": {
            "Type": "String",
            "Description": "Installer file for VisualC++2015x64 (vc_redist.x64.exe). Found at: https://download.microsoft.com/download/6/D/F/6DF3FF94-F7F9-4F0B-838C-A328D1A7D0EE/vc_redist.x64.exe"
        },
        "SqlServerPSModulePackageFolder": {
            "Type": "String",
            "Description": "Folder containing the SqlServer PS Module (sqlserver.{version}.nupkg). Found at: https://www.powershellgallery.com/packages/Sqlserver"
        },
        "SharedManagementObjectsInstallerx86": {
            "Type": "String",
            "Description": "Installer file for Shared Management Objects (SharedManagementObjects_x86.msi). Found at: https://download.microsoft.com/download/B/1/7/B1783FE9-717B-4F78-A39A-A2E27E3D679D/ENU/x86/SharedManagementObjects.msi"
        },
        "SharedManagementObjectsInstallerx64": {
            "Type": "String",
            "Description": "Installer file for Shared Management Objects (SharedManagementObjects_x64.msi). Found at: https://download.microsoft.com/download/B/1/7/B1783FE9-717B-4F78-A39A-A2E27E3D679D/ENU/x64/SharedManagementObjects.msi"
        },
        "WebDeployInstaller": {
            "Type": "String",
            "Description": "Installer file for Web Deploy (WebDeploy_amd64_en-US.msi). Found at: https://www.microsoft.com/en-us/download/details.aspx?id=43717"
        },
        "URLRewriteInstaller": {
            "Type": "String",
            "Description": "Installer file for URL Rewrite (rewrite_amd64_en-US.msi). Found at: https://download.microsoft.com/download/1/2/8/128E2E22-C1B9-44A4-BE2A-5859ED1D4592/rewrite_amd64_en-US.msi"
        },
        "SQLClrTypesx86": {
            "Type": "String",
            "Description": "Installer file for SQL CLR Types (SQLSysClrTypes_x86.msi). Found at: https://download.microsoft.com/download/C/1/9/C1917410-8976-4AE0-98BF-1104349EA1E6/x86/SQLSysClrTypes.msi"
        },
        "SQLClrTypesx64": {
            "Type": "String",
            "Description": "Installer file for SQL CLR Types (SQLSysClrTypes_x64.msi). Found at: https://download.microsoft.com/download/C/1/9/C1917410-8976-4AE0-98BF-1104349EA1E6/x64/SQLSysClrTypes.msi"
        },
        "SQLClrTypes2016x86": {
            "Type": "String",
            "Description": "Installer file for SQL CLR Types (SQLSysClrTypes2016_x86.msi). Found at: https://download.microsoft.com/download/B/1/7/B1783FE9-717B-4F78-A39A-A2E27E3D679D/ENU/x86/SQLSysClrTypes.msi"
        },
        "SQLClrTypes2016x64": {
            "Type": "String",
            "Description": "Installer file for SQL CLR Types (SQLSysClrTypes2016_x64.msi). Found at: https://download.microsoft.com/download/B/1/7/B1783FE9-717B-4F78-A39A-A2E27E3D679D/ENU/x64/SQLSysClrTypes.msi"
        },
        "SQLDacFrameworkx86": {
            "Type": "String",
            "Description": "Installer file for SQL DAC Framework x86 (DacFramework_x86.msi). Found at: https://download.microsoft.com/download/6/E/4/6E406E38-0A01-4DD1-B85E-6CA7CF79C8F7/EN/x86/DacFramework.msi"
        },
        "SQLDacFrameworkx64": {
            "Type": "String",
            "Description": "Installer file for SQL DAC Framework x64 (DacFramework_x64.msi). Found at: https://download.microsoft.com/download/6/E/4/6E406E38-0A01-4DD1-B85E-6CA7CF79C8F7/EN/x64/DacFramework.msi"
        },
        "SQLODBC": {
            "Type": "String",
            "Description": "Installer file for SQL ODBC (msodbcsql.msi). Found at: https://download.microsoft.com/download/D/5/E/D5EEF288-A277-45C8-855B-8E2CB7E25B96/x64/msodbcsql.msi"
        },
        "DotNetMultiTargeting": {
            "Type": "String",
            "Description": "Installer file for .NET Core Hosting (dotnet-hosting-2.1.12-win.exe). Found at: https://download.visualstudio.microsoft.com/download/pr/eebd54bc-c3a2-4580-bb29-b35c1c5ffa92/22ffe5649861167d3d5728d3cb4b10a1/dotnet-hosting-2.1.12-win.exe"
        },
        "DotNetFramework": {
            "Type": "String",
            "Description": "Installer file for .NET Framework (NDP472-KB4054530-x86-x64-AllOS-ENU.exe). Found at: https://download.microsoft.com/download/6/E/4/6E48E8AB-DC00-419E-9704-06DD46E5F81D/NDP472-KB4054530-x86-x64-AllOS-ENU.exe"
        },
        "NuGetProvider": {
            "Type": "String",
            "Description": "NuGetProvider for being able to utilize Install-Package command in PowerShell. Acquired by running 'Install-PackageProvider -Name NuGet -RequiredVersion 2.8.5.208 -Force' on a connected PC and picking up the files inside 'C:\\Program Files\\PackageManagement\\ProviderAssemblies\\nuget\\2.8.5.208'"
        }
    },
    "Variables": {
        "Get.DotNet.Version": "[GetItemPropertyValue(Path:parameter('DotNet4RegistryLocation'),Name:'Release')]",
        "Check.DotNetFramework.Version": "[ValidateRange(Min:0,Max:461807,Param:variable('Get.DotNet.Version'))]",

        "Net.Hosting.Package": "[GetPackage(Name:'Microsoft` .NET` Core` 2.1.12` -` Windows` Server` Hosting',ErrorAction:'SilentlyContinue')]",

        "SQL.ODBC.Minimum.Version": "13.1.4414.46",
        "SQL.ODBC.Package": "[GetPackage(Name:'Microsoft` ODBC` Driver` 13` for` SQL` Server',ErrorAction:'SilentlyContinue')]",
        "SQL.ODBC.Version": "[SelectObject(InputObject:variable('SQL.ODBC.Package'),ExpandProperty:'Version')]",
        "SQL.ODBC.Version.Compare": "[InvokeExpression(Command:variable('SQL.ODBC.Version.Command'))]",
        "SQL.ODBC.Version.Command": "[concat('[system.version]\"',variable('SQL.ODBC.Null.Version'),'\" -ge [system.version]\"',variable('SQL.ODBC.Minimum.Version'),'\"')]",
        "SQL.ODBC.Null.Version": "[if(variable('SQL.ODBC.Version'),variable('SQL.ODBC.Version'),'0.0')]",

        "SQL.Dac.Framework.x86.Minimum.Version": "14.0.4079.2",
        "SQL.Dac.Framework.x86.Package": "[GetPackage(Name:'Microsoft` SQL` Server` Data-Tier` Application` Framework` `(x86`)',ErrorAction:'SilentlyContinue')]",
        "SQL.Dac.Framework.x86.Version": "[SelectObject(InputObject:variable('SQL.Dac.Framework.x86.Package'),ExpandProperty:'Version')]",
        "SQL.Dac.Framework.x86.Version.Compare": "[InvokeExpression(Command:variable('SQL.Dac.Framework.x86.Version.Command'))]",
        "SQL.Dac.Framework.x86.Version.Command": "[concat('[system.version]\"',variable('SQL.Dac.Framework.x86.Null.Version'),'\" -ge [system.version]\"',variable('SQL.Dac.Framework.x86.Minimum.Version'),'\"')]",
        "SQL.Dac.Framework.x86.Null.Version": "[if(variable('SQL.Dac.Framework.x86.Version'),variable('SQL.Dac.Framework.x86.Version'),'0.0')]",

        "SQL.Dac.Framework.x64.Minimum.Version": "14.0.4079.2",
        "SQL.Dac.Framework.x64.Package": "[GetPackage(Name:'Microsoft` SQL` Server` Data-Tier` Application` Framework` `(x64`)',ErrorAction:'SilentlyContinue')]",
        "SQL.Dac.Framework.x64.Version": "[SelectObject(InputObject:variable('SQL.Dac.Framework.x64.Package'),ExpandProperty:'Version')]",
        "SQL.Dac.Framework.x64.Version.Compare": "[InvokeExpression(Command:variable('SQL.Dac.Framework.x64.Version.Command'))]",
        "SQL.Dac.Framework.x64.Version.Command": "[concat('[system.version]\"',variable('SQL.Dac.Framework.x64.Null.Version'),'\" -ge [system.version]\"',variable('SQL.Dac.Framework.x64.Minimum.Version'),'\"')]",
        "SQL.Dac.Framework.x64.Null.Version": "[if(variable('SQL.Dac.Framework.x64.Version'),variable('SQL.Dac.Framework.x64.Version'),'0.0')]",

        "SQL.CLR.Types.Minimum.Version": "14.0.1000.169",
        "SQL.CLR.Types.Package": "[GetPackage(Name:'Microsoft` System` CLR` Types` for` SQL` Server` 2017',ErrorAction:'SilentlyContinue')]",
        "SQL.CLR.Types.Version": "[SelectObject(InputObject:variable('SQL.CLR.Types.Package'),ExpandProperty:'Version')]",
        "SQL.CLR.Types.Version.Compare": "[InvokeExpression(Command:variable('SQL.CLR.Types.Version.Command'))]",
        "SQL.CLR.Types.Version.Command": "[concat('[system.version]\"',variable('SQL.CLR.Types.Null.Version'),'\" -ge [system.version]\"',variable('SQL.CLR.Types.Minimum.Version'),'\"')]",
        "SQL.CLR.Types.Null.Version": "[if(variable('SQL.CLR.Types.Version'),variable('SQL.CLR.Types.Version'),'0.0')]",

        "SQL.CLR2016.Types.Minimum.Version": "13.2.5026.0",
        "SQL.CLR2016.Types.Package": "[GetPackage(Name:'Microsoft` System` CLR` Types` for` SQL` Server` 2016',ErrorAction:'SilentlyContinue')]",
        "SQL.CLR2016.Types.Version": "[SelectObject(InputObject:variable('SQL.CLR2016.Types.Package'),ExpandProperty:'Version')]",
        "SQL.CLR2016.Types.Version.Compare": "[InvokeExpression(Command:variable('SQL.CLR2016.Types.Version.Command'))]",
        "SQL.CLR2016.Types.Version.Command": "[concat('[system.version]\"',variable('SQL.CLR2016.Types.Null.Version'),'\" -ge [system.version]\"',variable('SQL.CLR2016.Types.Minimum.Version'),'\"')]",
        "SQL.CLR2016.Types.Null.Version": "[if(variable('SQL.CLR2016.Types.Version'),variable('SQL.CLR2016.Types.Version'),'0.0')]",

        "IIS.URLRewrite.Minimum.Version": "7.2.1980",
        "IIS.URLRewrite.Package": "[GetPackage(Name:'IIS` URL` Rewrite` Module` 2',ErrorAction:'SilentlyContinue')]",
        "IIS.URLRewrite.Version": "[SelectObject(InputObject:variable('IIS.URLRewrite.Package'),ExpandProperty:'Version')]",
        "IIS.URLRewrite.Version.Compare": "[InvokeExpression(Command:variable('IIS.URLRewrite.Version.Command'))]",
        "IIS.URLRewrite.Version.Command": "[concat('[system.version]\"',variable('IIS.URLRewrite.Null.Version'),'\" -ge [system.version]\"',variable('IIS.URLRewrite.Minimum.Version'),'\"')]",
        "IIS.URLRewrite.Null.Version": "[if(variable('IIS.URLRewrite.Version'),variable('IIS.URLRewrite.Version'),'0.0')]",

        "SharedManagementObjects.x86.Minimum.Version": "13.2.5026.0",
        "SharedManagementObjects.x86.Package": "[GetPackage(Name:'SQL` Server` 2016` Shared` Management` Objects',ErrorAction:'SilentlyContinue')]",
        "SharedManagementObjects.x86.Version": "[SelectObject(InputObject:variable('SharedManagementObjects.x86.Package'),ExpandProperty:'Version')]",
        "SharedManagementObjects.x86.Version.Compare": "[InvokeExpression(Command:variable('SharedManagementObjects.x86.Version.Command'))]",
        "SharedManagementObjects.x86.Version.Command": "[concat('[system.version]\"',variable('SharedManagementObjects.x86.Null.Version'),'\" -ge [system.version]\"',variable('SharedManagementObjects.x86.Minimum.Version'),'\"')]",
        "SharedManagementObjects.x86.Null.Version": "[if(variable('SharedManagementObjects.x86.Version'),variable('SharedManagementObjects.x86.Version'),'0.0')]",

        "SharedManagementObjects.x64.Minimum.Version": "13.2.5026.0",
        "SharedManagementObjects.x64.Package": "[GetPackage(Name:'SQL` Server` 2016` Shared` Management` Objects` `(x64`)',ErrorAction:'SilentlyContinue')]",
        "SharedManagementObjects.x64.Version": "[SelectObject(InputObject:variable('SharedManagementObjects.x64.Package'),ExpandProperty:'Version')]",
        "SharedManagementObjects.x64.Version.Compare": "[InvokeExpression(Command:variable('SharedManagementObjects.x64.Version.Command'))]",
        "SharedManagementObjects.x64.Version.Command": "[concat('[system.version]\"',variable('SharedManagementObjects.x64.Null.Version'),'\" -ge [system.version]\"',variable('SharedManagementObjects.x64.Minimum.Version'),'\"')]",
        "SharedManagementObjects.x64.Null.Version": "[if(variable('SharedManagementObjects.x64.Version'),variable('SharedManagementObjects.x64.Version'),'0.0')]",

        "WebDeploy.Minimum.Version": "10.0.1973",
        "WebDeploy.Package": "[GetPackage(Name:'Microsoft` Web` Deploy*',ErrorAction:'SilentlyContinue')]",
        "WebDeploy.Version": "[SelectObject(InputObject:variable('WebDeploy.Package'),ExpandProperty:'Version')]",
        "WebDeploy.Version.Compare": "[InvokeExpression(Command:variable('WebDeploy.Version.Command'))]",
        "WebDeploy.Version.Command": "[concat('[system.version]\"',variable('WebDeploy.Null.Version'),'\" -ge [system.version]\"',variable('WebDeploy.Minimum.Version'),'\"')]",
        "WebDeploy.Null.Version": "[if(variable('WebDeploy.Version'),variable('WebDeploy.Version'),'0.0')]",

        "SQLServer.Module.Minimum.Version": "21.1.18080",
        "SQLServer.Module": "[GetModule(ListAvailable:True,Name:'SqlServer',ErrorAction:'SilentlyContinue')]",
        "SQLServer.Module.First": "[variable('SqlServer.Module')[0]]",
        "SQLServer.Module.Test": "[if(variable('SQLServer.Module'),variable('SQLServer.Module.First'),$null)]",
        "SQLServer.Module.Version": "[SelectObject(InputObject:variable('SQLServer.Module.Test'),ExpandProperty:'Version')]",
        "SQLServer.Module.Version.Compare": "[InvokeExpression(Command:variable('SQLServer.Module.Version.Command'))]",
        "SQLServer.Module.Version.Command": "[concat('[system.version]\"',variable('SQLServer.Module.Null.Version'),'\" -ge [system.version]\"',variable('SQLServer.Module.Minimum.Version'),'\"')]",
        "SQLServer.Module.Null.Version": "[if(variable('SQLServer.Module.Version'),variable('SQLServer.Module.Version'),'0.0')]",

        "InstallArgs": "/passive /norestart",

        "VisualC++.x64.Minimum.Version": "14.0.24212.0",
        "VisualC++.x64.Package": "[GetPackage(Name:'Microsoft` Visual` C++` 201*` Redistributable` `(x64`)` -` 14*',ErrorAction:'SilentlyContinue')]",
        "VisualC++.x64.Package.First": "[variable('VisualC++.x64.Package')[0]]",
        "VisualC++.x64.Package.Test": "[if(variable('VisualC++.x64.Package'),variable('VisualC++.x64.Package.First'),$null)]",
        "VisualC++.x64.Version": "[SelectObject(InputObject:variable('VisualC++.x64.Package.Test'),ExpandProperty:'Version')]",
        "VisualC++.x64.Version.Compare": "[InvokeExpression(Command:variable('VisualC++.x64.Version.Command'))]",
        "VisualC++.x64.Version.Command": "[concat('[system.version]\"',variable('VisualC++.x64.Null.Version'),'\" -ge [system.version]\"',variable('VisualC++.x64.Minimum.Version'),'\"')]",
        "VisualC++.x64.Null.Version": "[if(variable('VisualC++.x64.Version'),variable('VisualC++.x64.Version'),'0.0')]",

        "VisualC++.x64.Debug.Minimum.Version": "14.0.0",
        "VisualC++.x64.Debug.Package": "[GetPackage(Name:'Microsoft` Visual` C++` 201*` x64` Debug` Runtime` -` 14*',ErrorAction:'SilentlyContinue')]",
        "VisualC++.x64.Debug.Version": "[SelectObject(InputObject:variable('VisualC++.x64.Debug.Package'),ExpandProperty:'Version')]",
        "VisualC++.x64.Debug.Version.Compare": "[InvokeExpression(Command:variable('VisualC++.x64.Debug.Version.Command'))]",
        "VisualC++.x64.Debug.Version.Command": "[concat('[system.version]\"',variable('VisualC++.x64.Debug.Null.Version'),'\" -ge [system.version]\"',variable('VisualC++.x64.Debug.Minimum.Version'),'\"')]",
        "VisualC++.x64.Debug.Null.Version": "[if(variable('VisualC++.x64.Debug.Version'),variable('VisualC++.x64.Debug.Version'),'0.0')]",

        "VisualC++.x64.Compare": "[or(variable('VisualC++.x64.Version.Compare'),variable('VisualC++.x64.Debug.Version.Compare'))]",

        "NuGetProvider.Path": "[joinpath(environment('SystemDrive'), 'Program Files', 'PackageManagement', 'ProviderAssemblies', 'nuget', '2.8.5.208')]",

        "IISReset.Location": "[JoinPath(environment('windir'),'System32','IISReset.exe')]",
        "Check.Reboot.Pending": "[TestPath(Path:parameter('ComponentBasedServicing'))]",
        "ExitMessage": "[if(variable('Check.Reboot.Pending'),'Sitecore prerequisites are now installed, you must reboot your machine to allow prerequisite components installations to finish.','Sitecore prerequisites are now installed, YOU MUST launch a new PowerShell session to run further SIF configurations.')]"
    },
    "Register": {
        "Tasks": {
            "InstallModule": "Install-Module",
            "EnableWindowsOptionalFeature": "Enable-WindowsOptionalFeature",
            "StartProcess": "Start-Process",
            "WriteInformation": "Write-Information",
            "RegisterPSRepository": "Register-PSRepository",
            "ImportPackageProvider": "Import-PackageProvider",
            "UnregisterPSRepository": "Unregister-PSRepository"
        },
        "ConfigFunction": {
            "GetModule": "Get-Module",
            "GetPackage": "Get-Package",
            "GetItemPropertyValue": "Get-ItemPropertyValue",
            "InvokeExpression": "Invoke-Expression",
            "SelectObject": "Select-Object",
            "TestPath": "Test-Path",
            "GetPSRepository": "Get-PSRepository"
        }
    },
    "Tasks": {
        "InstallC++2015x64": {
            "Type": "StartProcess",
            "Params": {
                "FilePath": "[parameter('VisualCPP2015x64')]",
                "ArgumentList": "[variable('InstallArgs')]",
                "Wait": true
            },
            "Skip": "[variable('VisualC++.x64.Compare')]"
        },
        "CreateNuGetProviderPaths": {
            "Description": "Ensure the destination path for the NuGetProvider exists.",
            "Type": "EnsurePath",
            "Params": {
                "Exists": [ "[variable('NuGetProvider.Path')]" ]
            }
        },
        "CopyNuGetProvider": {
            "Description": "Install the NuGet provider.",
            "Type": "Copy",
            "Params": {
                "Source": "[resolvepath(parameter('NuGetProvider'))]",
                "Destination": "[variable('NuGetProvider.Path')]"
            },
            "Skip": "[or(not(parameter('NuGetProvider')), TestPath(Path:JoinPath(variable('NuGetProvider.Path'), 'Microsoft.PackageManagement.NuGetProvider.dll'),Type:'Leaf'))]"
        },
        "ImportNuGetProvider": {
            "Description": "Import the NuGet provider.",
            "Type": "ImportPackageProvider",
            "Params": {
                "Name": "NuGet",
                "RequiredVersion": "2.8.5.208"
            },
            "Skip": "[not(parameter('NuGetProvider'))]"
        },
        "SQLServerModuleRepository": {
            "Type": "RegisterPSRepository",
            "Params": {
                "Name": "OfflinePackages",
                "InstallationPolicy": "Trusted",
                "SourceLocation": "[parameter('SqlServerPSModulePackageFolder')]"
            },
            "Skip": "[and(parameter('NuGetProvider'), parameter('SqlServerPSModulePackageFolder'), variable('SQLServer.Module.Version.Compare'))]"
        },
        "SQLServerModule": {
            "Type": "InstallModule",
            "Params": {
                "Name": "SqlServer",
                "Repository": "OfflinePackages"
            },
            "Skip": "[and(parameter('NuGetProvider'), parameter('SqlServerPSModulePackageFolder'), variable('SQLServer.Module.Version.Compare'))]"
        },
        "UnregisterSQLServerModuleRepository": {
            "Type": "UnregisterPSRepository",
            "Params": {
                "Name": "OfflinePackages",
                "ErrorAction": "SilentlyContinue"
            }
        },
        "WindowsFeatures": {
            "Type": "EnableWindowsOptionalFeature",
            "Params": {
                "Online": true,
                "FeatureName": [
                    "IIS-WebServer",
                    "IIS-WebServerManagementTools",
                    "IIS-ASPNET",
                    "IIS-ASPNET45",
                    "NetFx4Extended-ASPNET45",
                    "WAS-NetFxEnvironment",
                    "WAS-ProcessModel",
                    "WAS-WindowsActivationService"
                ],
                "All": true,
                "NoRestart": true
            }
        },
        "InstallSQLClrTypesx86": {
            "Type": "StartProcess",
            "Params": {
                "FilePath": "[parameter('SQLClrTypesx86')]",
                "ArgumentList": "[variable('InstallArgs')]",
                "Wait": true
            },
            "Skip": "[variable('SQL.CLR.Types.Version.Compare')]"
        },
        "InstallSQLClrTypesx64": {
            "Type": "StartProcess",
            "Params": {
                "FilePath": "[parameter('SQLClrTypesx64')]",
                "ArgumentList": "[variable('InstallArgs')]",
                "Wait": true
            },
            "Skip": "[variable('SQL.CLR.Types.Version.Compare')]"
        },
        "InstallSQLClrTypes2016x86": {
            "Type": "StartProcess",
            "Params": {
                "FilePath": "[parameter('SQLClrTypes2016x86')]",
                "ArgumentList": "[variable('InstallArgs')]",
                "Wait": true
            },
            "Skip": "[variable('SQL.CLR2016.Types.Version.Compare')]"
        },
        "InstallSQLClrTypes2016x64": {
            "Type": "StartProcess",
            "Params": {
                "FilePath": "[parameter('SQLClrTypes2016x64')]",
                "ArgumentList": "[variable('InstallArgs')]",
                "Wait": true
            },
            "Skip": "[variable('SQL.CLR2016.Types.Version.Compare')]"
        },
        "InstallSQLDacFrameworkx86": {
            "Type": "StartProcess",
            "Params": {
                "FilePath": "[parameter('SQLDacFrameworkx86')]",
                "ArgumentList": "[variable('InstallArgs')]",
                "Wait": true
            },
            "Skip": "[variable('SQL.Dac.Framework.x86.Version.Compare')]"
        },
        "InstallSQLDacFrameworkx64": {
            "Type": "StartProcess",
            "Params": {
                "FilePath": "[parameter('SQLDacFrameworkx64')]",
                "ArgumentList": "[variable('InstallArgs')]",
                "Wait": true
            },
            "Skip": "[variable('SQL.Dac.Framework.x64.Version.Compare')]"
        },
        "InstallSQLODBC": {
            "Type": "StartProcess",
            "Params": {
                "FilePath": "[parameter('SQLODBC')]",
                "ArgumentList": "/passive /norestart IACCEPTMSODBCSQLLICENSETERMS=YES",
                "Wait": true
            },
            "Skip": "[variable('SQL.ODBC.Version.Compare')]"
        },
        "SharedManagementObjectsx86": {
            "Type": "StartProcess",
            "Params": {
                "FilePath": "[parameter('SharedManagementObjectsInstallerx86')]",
                "ArgumentList": "[variable('InstallArgs')]",
                "Wait": true
            },
            "Skip": "[variable('SharedManagementObjects.x86.Version.Compare')]"
        },
        "SharedManagementObjectsx64": {
            "Type": "StartProcess",
            "Params": {
                "FilePath": "[parameter('SharedManagementObjectsInstallerx64')]",
                "ArgumentList": "[variable('InstallArgs')]",
                "Wait": true
            },
            "Skip": "[variable('SharedManagementObjects.x64.Version.Compare')]"
        },
        "InstallWebDeploy3.6": {
            "Type": "StartProcess",
            "Params": {
                "FilePath": "[parameter('WebDeployInstaller')]",
                "ArgumentList": "[variable('InstallArgs')]",
                "Wait": true
            },
            "Skip": "[variable('WebDeploy.Version.Compare')]"
        },
        "InstallURLRewrite2": {
            "Type": "StartProcess",
            "Params": {
                "FilePath": "[parameter('URLRewriteInstaller')]",
                "ArgumentList": "[variable('InstallArgs')]",
                "Wait": true
            },
            "Skip": "[variable('IIS.UrlRewrite.Version.Compare')]"
        },
        "InstallDotNetMultiTargeting": {
            "Type": "StartProcess",
            "Params": {
                "FilePath": "[parameter('DotNetMultiTargeting')]",
                "ArgumentList": "[variable('InstallArgs')]",
                "Wait": true
            },
            "Skip": "[variable('Net.Hosting.Package')]"
        },
        "InstallDotNetFramework": {
            "Type": "StartProcess",
            "Params": {
                "FilePath": "[parameter('DotNetFramework')]",
                "ArgumentList": "[variable('InstallArgs')]",
                "Wait": true
            },
            "Skip": "[not(variable('Check.DotNetFramework.Version'))]"
        },
        "IISReset": {
            "Type": "StartProcess",
            "Params": {
                "FilePath": "[variable('IISReset.Location')]",
                "ArgumentList": "/Restart",
                "Wait": true
            },
            "Skip": "[variable('Net.Hosting.Package')]"
        },
        "InformUser": {
            "Type": "WriteInformation",
            "Params": {
                "MessageData": "[variable('ExitMessage')]",
                "InformationAction": "Continue"
            }
        }
    }
}

Prerequisites-Offline.ps1

Import-Module -Name SitecoreInstallFramework -Force -RequiredVersion 2.2.0

# Installer files and packages
$VisualCPP2015x64 = Resolve-Path "..\..\Packages\vc_redist.x64.exe"
$SqlServerPSModulePackageFolder = Resolve-Path "..\..\Packages\"
$SharedManagementObjectsInstallerx86 = Resolve-Path "..\..\Packages\SharedManagementObjects_x86.msi"
$SharedManagementObjectsInstallerx64 = Resolve-Path "..\..\Packages\SharedManagementObjects_x64.msi"
$WebDeployInstaller = Resolve-Path "..\..\Packages\WebDeploy_amd64_en-US.msi"
$URLRewriteInstaller = Resolve-Path "..\..\Packages\rewrite_amd64_en-US.msi"
$SQLClrTypesx86 = Resolve-Path "..\..\Packages\SQLSysClrTypes_x86.msi"
$SQLClrTypesx64 = Resolve-Path "..\..\Packages\SQLSysClrTypes_x64.msi"
$SQLClrTypes2016x86 = Resolve-Path "..\..\Packages\SQLSysClrTypes2016_x86.msi"
$SQLClrTypes2016x64 = Resolve-Path "..\..\Packages\SQLSysClrTypes2016_x64.msi"
$SQLDacFrameworkx86 = Resolve-Path "..\..\Packages\DacFramework_x86.msi"
$SQLDacFrameworkx64 = Resolve-Path "..\..\Packages\DacFramework_x64.msi"
$SQLODBC = Resolve-Path "..\..\Packages\msodbcsql.msi"
$DotNetMultiTargeting = Resolve-Path "..\..\Packages\dotnet-hosting-2.1.12-win.exe"
$DotNetFramework = Resolve-Path "..\..\Packages\NDP472-KB4054530-x86-x64-AllOS-ENU.exe"
$NuGetProvider = Resolve-Path "..\..\Packages\Microsoft.PackageManagement.NuGetProvider.dll"

# Params
$preReqParams = @{
    Path = ".\Prerequisites-Offline.json"
    VisualCPP2015x64 = $VisualCPP2015x64
    SqlServerPSModulePackageFolder = $SqlServerPSModulePackageFolder
    SharedManagementObjectsInstallerx86 = $SharedManagementObjectsInstallerx86
    SharedManagementObjectsInstallerx64 = $SharedManagementObjectsInstallerx64
    WebDeployInstaller = $WebDeployInstaller
    URLRewriteInstaller = $URLRewriteInstaller
    SQLClrTypesx86 = $SQLClrTypesx86
    SQLClrTypesx64 = $SQLClrTypesx64
    SQLDacFrameworkx86 = $SQLDacFrameworkx86
    SQLDacFrameworkx64 = $SQLDacFrameworkx64
    SQLODBC = $SQLODBC
    DotNetMultiTargeting = $DotNetMultiTargeting
    DotNetFramework = $DotNetFramework
    NuGetProvider = $NuGetProvider
    SQLClrTypes2016x86 = $SQLClrTypes2016x86
    SQLClrTypes2016x64 = $SQLClrTypes2016x64
}

Install-SitecoreConfiguration @preReqParams *>&1 | Tee-Object Prerequisites-Offline.log