In the Tridion Management Console in 2013 we can configure a publisher server for publishing to stage and another for publishing to live, by adding the publishing target tcmid into the Publication Targets field.

So how do we do that in Tridion 8.5 with Topology?

SDL 8.5 Documentation for Queue settings

"You can configure a host to only process messages for a specific Publication Target"

Where do I get a publication target tcmid for the filter?

enter image description here

Edit: Queried the database to get Publication Targets.

SELECT 'tcm:0-' +  CAST( [ID] as  varchar(10)) + '-65537' as 'tcmid' ,[TITLE]
where IS_EMULATED = 1

Is this really the recommended way to find the Publication Target data for configuring Publishers?


enter image description here

PowerShell Solution

# GetBPTPublishingTargets.ps1
Get BPT Publishing Targets
    Queue Publisher filtering in Tridion 8.5
    There is no GUI to show Business Process Type Publishing Target Type for Publication Filtering

Example of how to use this cmdlet
Produced by Chris Mills Tridionation Ltd 
[email protected]  07768805566

$modulename = "SQLPS"
if (Get-Module -ListAvailable -Name $modulename ) {
    #Write-Host "$modulename already installed"
    Import-Module -Name $modulename
else {
    $modulename = "SqlServer"
    if (Get-Module -ListAvailable -Name $modulename ) {
        Write-Host "$modulename already installed"
    else {
        # Install the installer
        if (-not(Get-Module -ListAvailable -Name PowerShellGet)) { 
            Install-PackageProvider -Name NuGet -MinimumVersion -Force 
        Install-Module -Name $modulename -Force
    Import-Module -Name $modulename

if (-not $setupOptions) {
    Write-Error "Please initialse setupOptions"

if (-not $credential) {
    $credential = Get-Credential  -Message "Remote Server Tridion Administrator SUP Account"

$tridion_cm = $setupOptions.CM_DB_NAME
$GetBPTPublishingTargetsTemplate = @"
    SELECT 'tcm:0-' +  CAST( [ID] as  varchar(10)) + '-65537' as 'tcmid' ,[TITLE] as 'Publication Target'
    FROM [$tridion_cm].[dbo].[PUBLICATION_TARGETS]
    where IS_EMULATED = 1
$GetBPTPublishingTargets | Out-Null

$DatabaseComand = @{
    Query          = ""
    Database       = $setupOptions.CM_DB_NAME
    ServerInstance = $setupOptions.CM_DB_HOST
    UserName       = $setupOptions.SA_ACCOUNT_NAME
    Password       = $setupOptions.SA_PASSWORD

try { 
    $DatabaseComand.query = $ExecutionContext.InvokeCommand.ExpandString($GetBPTPublishingTargetsTemplate)
    $result = Invoke-Sqlcmd @DatabaseComand
    $title = "SDL* Business Process Types Target Type ID - Tridionation Ltd 2018"
    $result | Out-GridView -Title $title
catch {
    Write-Output "SQL Query Error"
    Write-Output $error   

2 Answers 2


SDL* Case 00379116

Subject: Queue Publisher filtering in Tridion 8.5:

Mon 29/10/2018 12:47

There is no current way available to find and filter by publication target other than the way you have found.

There is an enhancement request is outstanding to address this issue for the GUI.
You can also up-vote the request by visiting this community ideas link: https://community.sdl.com/ideas/sdl-tridion-dx-ideas/sdl-tridion-sites-ideas/i/sdl-tridion-sites-ideas/add-possibility-to-filter-publish-transactions-by-purpose-for-scaled-out-publishers

You can also follow the progress via the product request on the gateway with reference: CRQ-5213


I am able to find Publication Target info in PUBLICATION_TARGETS table from DB. In Web 8.5 even though we enable Legacy Publishing we cannot see those targets, Looks like those are hidden as we will not be using in Web 8.5

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.