In the "RedGate - Create Database Release" step template for OctopusDeploy, the powershell script contains logic for uploading Change.html, Warning.xml and Update.sql files (among others) as artifacts on the current Release. The only text added to the resulting artifact file name besides these keywords is the name of the database. In our environment, every single release produces each of the above artifacts, and if you view a Release that has been promoted through multiple environments the Artifact listing just shows the exact same artifact names repeated over and over with no indication of the environment in which they were produced. For example, we might see:

Changes-databasename.html
8 days ago
Warnings-databasename.xml
8 days ago
Update-databasename.sql
8 days ago
Changes-databasename.html
8 days ago
Warnings-databasename.xml
8 days ago
Update-databasename.sql
8 days ago

It would be great if the step template had an optional "Artifact Tag" parameter that could be used to inject additional text into the artifact names. Then it would be easy to use Octo variables to set the environment name or some other value as part of the artifact file names.