The following environment variables are always available for PowerShell scripts and SQL statements:
Variable: $EtereSqlServerInstance
Description: Name of the SQL Server instance
Example: 172.31.230.106
Variable: $EtereSqlDatabase
Description: Name of the Etere database
Example: EtereDB
Variable: $EtereSqlAuthentication
Description: Authentication type (0 = Windows; 1 = SQL Server)
Example: 0
Variable: $EtereSqlLoginName
Description: Login name if authentication is SQL Server (1)
Variable: $EtereSqlLoginPass
Description: Password if authentication is SQL Server (1)
Variable: $EtereJobId
Description: Value of the "WF_JOB.JOB_ID" field
Example: 43606
Variable: $EtereJobLogPath
Description: Path dove scrivere un eventuale file di log
Example: C:\Users\UsrDM009\AppData\Local\Etere\Log\dm.job
Variable: $EtereJobLogFilePrefix
Description: Prefix suggested for the log file
Example: mm9.dm.job.1_20131121-170102.a1.j43606.s118c0.d31c0.Powershell.psexec
Variable: $EtereUniqueName
Description: Unique name of the file in Etere
Example: 02BD0000000000000303
Variable: $EtereAssetId
Description: ID of the asset in Etere
Example: 4613
Variable: $EtereAssetNewtype
Description: Type of the asset
Example: CLIP
Variable: $EtereAssetCode
Description: Code of the asset
Example: CLIP0000004613
Variable: $EtereSrcMetafileId
Description: ID of the source metafile
Example: 1817
Variable: $EtereSrcMetafileFileID
Description: Name of the source metafile
Example: 4613
Variable: $EtereSrcCodecId
Description: ID of the source codec
Example: 37
Variable: $EtereSrcFile0
Description: First file associated to the metafile
Example: ftp://msrv3/video/4613.WMV
Variable: $EtereSrcFileList
Description: XML list of all files associated to the source metafile
Example: <files> <file>ftp://msrv3/video/4613.WMV</file> <file>ftp://msrv7/video/4613_nc.WMV</file> </files>
Variable: $EtereSrcPath0
Description: First path associated with the metafile
Example: ftp://msrv3/video/
Variable: $EtereSrcPathList
Description: XML list of all paths associated to the source metafile
Example: <folders> <folder>ftp://msrv3/video/</folder> <folder>ftp://msrv7/video/</folder> </folders>
Variable: $EtereDstMetafileId
Description: ID of the target metafile
Example: 31
Variable: $EtereDstCodecId
Description: ID of the target codec
Example: 37
Variable: $EtereDstPath0
Description: First path associated to the metafile
Example: ftp://msrv3/video/
Variable: $EtereDstPathList
Description: XML list of all paths associated to the target metafile
Example: <folders> <folder>ftp://NLE/IN1/</folder> <folder>ftp://NLE/IN2/</folder> </folders>
Note: Please note that in file tags, the less symbol (<) may be written as < whereas the greater symbol (>) symbol as >
For information on variables supported for custom names please refer to the Supported Runtime Variables chapter.