Hi Peter,

Select all (Ctrl-A) allows you to copy some stuff from EventMonitor into an Excel table.

Digging deeper... Publishing has many dimensions: event types, the data size, the data complexity, standard or custom DITA-OT, and rendering to your final format (PDF, ZIP, etc). So two API tips come to mind

1. Since 13SP2/13.0.2 there is a BackgroundTask API call, through ISHRemote it is opened up via cmdlet Get-IshBackgroundTask
   Where start and end date is the total handling time (not the queue/wait time).
   
2. Since 'ever' the EventMonitor web client view, has a Events API behind it, through ISHRemote it is opened up via cmdlet Get-IShEvent so the following code sample could inspire
   $requestedMetadata = Set-IshRequestedMetadataField -Name "EVENTID" -Level "Progress" |
   Set-IshRequestedMetadataField -Name "EVENTTYPE" -Level "Progress" |
   Set-IshRequestedMetadataField -Name "EVENTDATATYPE" -Level "Detail"
   $metadataFilter = Set-IshMetadataFilterField -Name "ACTION" -Level "Detail" -FilterOperator In -Value "Request started, Start execution, Execution completed"
   Get-IshEvent -EventTypes @("PUBLISHREACHINTERNAL") -RequestedMetadata $requestedMetadata -MetadataFilter $metadataFilter -ModifiedSince "01/01/2020 00:00:00"

On the cmdlets have a look at the referenced recording and code samples on https://community.sdl.com/product-groups/sdl-tridion-dx/tridion-docs/b/weblog/posts/automating-on-sdl-tridion-docs-tds2019---business-process-examples 

Or https://github.com/sdl/ISHRemote/releases/tag/v0.7 

Best wishes,
Dave

Hi Peter,

Select all (Ctrl-A) allows you to copy some stuff from EventMonitor into an Excel table.

Digging deeper... Publishing has many dimensions: event types, the data size, the data complexity, standard or custom DITA-OT, and rendering to your final format (PDF, ZIP, etc). So two API tips come to mind

1. Since 13SP2/13.0.2 there is a BackgroundTask API call, through ISHRemote it is opened up via cmdlet Get-IshBackgroundTask
   Where start and end date is the total handling time (not the queue/wait time).
   
2. Since 'ever' the EventMonitor web client view, has a Events API behind it, through ISHRemote it is opened up via cmdlet Get-IShEvent so the following code sample could inspire
   $requestedMetadata = Set-IshRequestedMetadataField -Name "EVENTID" -Level "Progress" |
   Set-IshRequestedMetadataField -Name "EVENTTYPE" -Level "Progress" |
   Set-IshRequestedMetadataField -Name "EVENTDATATYPE" -Level "Detail"
   $metadataFilter = Set-IshMetadataFilterField -Name "ACTION" -Level "Detail" -FilterOperator In -Value "Request started, Start execution, Execution completed"
   Get-IshEvent -EventTypes @("PUBLISHREACHINTERNAL") -RequestedMetadata $requestedMetadata -MetadataFilter $metadataFilter -ModifiedSince "01/01/2020 00:00:00"

On the cmdlets have a look at the referenced recording and code samples on https://community.sdl.com/product-groups/sdl-tridion-dx/tridion-docs/b/weblog/posts/automating-on-sdl-tridion-docs-tds2019---business-process-examples 

Or https://github.com/sdl/ISHRemote/releases/tag/v0.7 

Best wishes,
Dave

@Dave, thanks a lot!