The Sitecore Publish Queue Detail report is a single-file, drop-in utility for viewing detailed info from the Sitecore Publish Queue. This is handy for verifying what will be published during the next Incremental Publish or for troubleshooting publishing issues.
- Current version: 1.0.1
- About & Download: Sitecore Publish Queue Detail (GitHub)
As of 2022, this module will be updated and maintained for all 10.x versions of Sitecore XM/XP (likely 10.3 and 10.4). This module will not support future Sitecore composable CMS products, such as Sitecore XM Cloud.
Publish Queue information is only accessible via the database (dbo.PublishQueue table) or via the Sitecore API (Sitecore.Publishing.PublishManager class). This utility utilizes the API to generate a report of all items in the Publish Queue due for publishing during the next Incremental Publish, and includes the following information for each item:
- ID
- Name
- Language
- Publish Action
- Source Database
- Target Database
There may be a discrepency in the publish queue totals between the Publish Queue Stats page and this report. This is because Sitecore uses multiple APIs for loading publish queue information (you need to go deep into the Sitecore SQL DataProvider classes in Sitecore.Kernel.dll to digest this). Keep in mind that this report displays items that are actually queued for the next Incremental Publish.
Note: this report displays items in a final workflow state. Items without any assigned workflow will not be displayed on this report, but may be published.
- Sitecore 8.2 or greater
Copy the PublishQueueDetail.aspx file and place it inside the Sitecore admin directory (<your_webroot>/sitecore/admin). You can place it anywhere in the webroot, but this information should probably only be accessed by admin-level users.
The file is a self-contained ASPX page, with all backend logic inline with a <script> tag. Near the top of the C# script code, you can update the dbMaster and dbWeb values to match your master and web databases, respectively.
For questions / comments / issues, contact me:
- Twitter: @BrandonMBruno or @SitecoreSpark
- Email: bmbruno [at] gmail [dot] com
MIT License. See accompanying "License.txt" file.