Skip to main content

1E 8.1 (on-premises)

Scripts

All scripts are referenced on other pages within the documentation.

Scripts for installation and upgrades
Install Windows Server roles and features

The following PowerShell script is used on Windows Server roles and features. Tachyon Setup can do all of this except for Basic Authentication (required by 1E Core) and HTTP redirect (required if Nomad is supporting down-level clients after replacing ActiveEfficiency).

Click here to download - RolesInstall.ps1

RolesInstall.ps1 - Configure IIS using PowerShell

Import-Module ServerManager

Get-WindowsFeature | Out-file $PSScriptRoot\ServerManager-1.txt -Append
Install-WindowsFeature Web-Server,
Web-Http-Redirect,
Web-Dyn-Compression,
Web-Basic-Auth,
Web-IP-Security,
Web-Windows-Auth,
Web-Asp-Net45,
Web-Mgmt-Console,
Net-Framework-45-Core,
Net-Framework-45-ASPNET

Uninstall-WindowsFeature Web-DAV-Publishing
   
Get-WindowsFeature | Out-file $PSScriptRoot\ServerManager-2.txt -Append
Changing the configuration of Network Adapters

The following extract is used here: Changing the configuration of Network Adapters.

If the configuration of any network adapters is changed, then the Tachyon website configuration for IP Address and Domain Restrictions may need to be updated with the server's new IPv4 and IPv6 addresses. Failure to update the configuration after a network change will cause issues between the Switch and the Core and prevent the Tachyon Server from functioning.

Use the PowerShell cmdlet Gevt-NetIPAddress to determine the current IP Addresses, and if necessary update the configuration of the Core web application.

The following AddIpSec.ps1 script can be used to refresh local IP Addresses. It does not remove old, unwanted, or remote IP Addresses. Nor does it add addresses for remote Switches, which would need to be added manually.

Click Read more... to view AddIpSec.ps1.

Change Shopping 6.0 Sync from ActiveEfficiency to direct Configuration Manager

The following SQL script is used on In-place upgrade of ActiveEfficiency Server for Nomad.

Click here to download - ReplaceActiveEfficiencySyncWithConfigMgrSync.sql

Note

Click Read more... to view source for ReplaceActiveEfficiencySyncWithConfigMgrSync.sql

Manually migrate Nomad data from ActiveEfficiency to Content Distribution

The following PowerShell and SQL scripts are used on Side-by-side upgrade of ActiveEfficiency Server for Nomad.

Click here to download - AE-CD Data Migration Scripts.zip

Note

  1. ExportData.ps1 - run on any computer that has read access to the ActiveEfficiency database

  2. CreateTables.sql - run on the SQL Server instance that hosts the ContentDistribution database created by Tachyon Setup

  3. ImportData.ps1 - run on any computer that has write access to the ContentDistribution database.

Granting Network Service access to Configuration Manager

The following SQL script is used on:

Click here to download - ConfigMgr_DViewAccess_permissions.SQL

Click Read more... to view ConfigMgr_DViewAccess_permissions.SQL.

Estimating the RAM requirements for AI Powered Auto-curation

The following scripts are used on AI Powered Auto-curation to calculate the amount of additional RAM that is required before you enable this feature.

The following script is run on the Configuration Manager database before Tachyon is installed.

The following script is run on SLA-Data database after Tachyon is installed and has already populated the inventory repository.

Modifying 1E Catalog AI Powered Auto-curation file download post-installation

The following script can be used to modify the EnableAIPackageSync setting in the Settings table of the 1ECatalog database, and is used on the Configuring 1E Catalog connection to 1E Cloud page.

Click Read more... to view the SQL script to configure the EnableAIPackageSync setting.

Modifying the AI Package Deployment Path

The following script can be used to modify the AIModelDeploymentPath setting in the Settings tables of the SLA-Shared and SLA-Data databases and is used on the AI Powered Auto-curation page.

It is not possible to modify the download path use by the 1E Catalog Update service.

Click Read more... to view the SQL script to configure the AIModelDeploymentPath setting.

Modifying 1E Client Cloud synchronization behavior post-installation

The following script is used to configure the 1E Catalog SubscriptionType setting and is used on the Configuring 1E Catalog connection to 1E Cloud page.

Click Read more... to view the SQL script to configure the SubscriptionType setting.

Operational scripts
Create Direct-based management groups from a file

The following PowerShell script is used on Management Groups page.

Note

This script has changed to support an API change in Platform 8.1

Click here to download - Create-DirectManagementGroupUsingFile.ps1

Click Read more... to view Create-DirectManagementGroupUsingFile.ps1.

Create Direct-based management groups from a Configuration Manager collection

The following PowerShell script is used on Management Groups page.

Note

This script has changed to support an API change in Platform 8.1

Click here to download - Create-DirectManagementGroupUsingCmCollection.ps1

Click Read more... to view Create-DirectManagementGroupUsingCmCollection.ps1.