Quick Connect Management Shell: it is simple. Part1

Together with Quick Connect 5.0 you can use Quick Connect Management Shell. Main purposes of the QC Management Shell 1.0 are:

  • Run QC Workflow
  • Read QC sync history
  • Manage object mapping

To get full list of the QC cmdlets you can use cmdlet: Get-QCCommand. To get more details on how to use cmdlt, you can use cmdlet: get-help "name of the QC cmdlet" -full

Typical QC workflow history looks like:

And to get the same information using management shell you can use cmdlet: Get-QCSyncHistorySummaryRun * . Using this example, you will get a list of all runs of all workflows. To decrease a list of run history you can use the following parameters:

-WorkflowName

This parameter allows you to specify the name of the workflow for which you want to get summary. Accepts asterisk (*) as a wildcard character, and so you can use this cmdlet as in following example: Get-QCSyncHistorySummaryRun MyWor*ow

-RunID

This parameter accepts the ID of the workflow run. Usually you can get this as return value of the cmdlet Start-QCWorkflow

-LastN

This parameter accepts the number of the lust workflow runs whose summary you want to get.

-StartedBefore, -StartedAfter, -EndedBefore, - EndedAfter

These parameters used to limit the list of summary runs with dates. To test it you can use the following example: Get-QCSyncHistorySummaryRun * -StratedAfter "10.31.2011"

Typical results of the run of the cmdlet: Get-QCSyncHistorySummaryRun * have a output like this:

And of course you can use statements like these: where, select and export-csv statement to get list of workflow with errors and then format this list and then export this list to CSV file, like in example:

Get-QCSyncHistorySummaryRun * | Where-Object {$_.Status -like "PartialSuccess"} | Select WorkflowName, Status, Started, Completed | export-csv "file name"

Anonymous